Excel for Microsoft 365 Excel 2021 Excel 2019 Excel 2016 Excel 2013 Excel 2010 More...Less Show
In Excel, there are several types of option buttons and colored triangles that can appear in or next to a cell. These buttons and triangles provide useful commands and information about the contents of the cell, and they appear at the moment you need them. This article describes what each of these buttons and triangles mean and how you can work with them. Buttons that you might see on your worksheetThe seven buttons that can appear next to a cell are as follows: AutoCorrect Options, Paste Options, Auto Fill Options, Trace Error, Insert Options, and Apply formatting rule to. AutoCorrect OptionsThe AutoCorrect Options button might appear when you rest the mouse pointer on the small blue box under text that was automatically corrected. For example, if you type a hyperlink or an e-mail address in a cell, the Autocorrect Options button might appear. If you find text that you do not want to be corrected, you can either undo a correction or turn AutoCorrect options on or off. To turn AutoCorrect options on or off, click the AutoCorrect Options button, and then make a selection from the list.For more information, see Choose AutoCorrect options for capitalization, spelling, and symbols . Paste OptionsThe Paste Options button appears just below your pasted selection after you paste text or data. When you click the button, a list appears that lets you determine how to paste the information into your worksheet.The available options depend on the type of content that you are pasting, the program that you are pasting from, and the format of the text where you are pasting. For more information, see Move or copy cells and cell contents. Auto Fill OptionsThe Auto Fill Options button might appear just below your filled selection after you fill text or data in a worksheet. For example, if you type a date in a cell and then drag the cell down to fill the cells below it, the Auto Fill Options button might appear. When you click the button, a list of options for how to fill the text or data appears.The available options in the list depend on the content that you are filling, the program that you are filling from, and the format of the text or data that you are filling. For more information, see Fill data automatically in worksheet cells. Trace ErrorThe Trace Error button appears next to the cell in which a formula error occurs, and a green triangle appears in the upper-left corner of the cell.
When you click the arrow next to the button, a list of options for error checking appears. For more information, see Detect errors in formulas. Insert OptionsThe Insert Options button might appear next to inserted cells, rows, or columns.When you click the arrow next to the button, a list of formatting options appears. Note: If you do not want this button to be displayed every time that you insert formatted cells, rows, or columns, you can turn this option off in File > Options > Advanced > Under cut, copy, and paste > remove the checkbox next to Show Insert Options buttons . Apply formatting rule toThe Apply formatting rule to button is used to change the scoping method for conditional formatting data in a PivotTable report.When you click the arrow next to the button, a list of scoping options appears. Colored triangles that you might see in your worksheetThe two colored triangles that can appear in a cell are green (formula error), and red (comment). Green triangle
Red triangle
Need more help?You can always ask an expert in the Excel Tech Community or get support in the Answers community. Need more help?Which is a small green square in the lower right corner of a selected cell or range that you can use to copy one cell to adjacent cell or to create a series?Excel Lesson 2 Review. What is a box that displays the name of the active cell or range?The Name Box displays the cell reference of the active cell. The Name Box can also be used to assign names to cells or ranges of cells. To name a cell or range, highlight the cell or range you would like to name, type the name in the Name box, and press ENTER.
What is the name of the box that tells you what cell that is currently selected?In Microsoft Excel, the Name Box displays the cell that is currently selected in the spreadsheet. It is located to the left of the formula bar.
When you select a cell or click in a cell what happens?Select one or more cells
Click on a cell to select it. Or use the keyboard to navigate to it and select it. To select a range, select a cell, then with the left mouse button pressed, drag over the other cells. Or use the Shift + arrow keys to select the range.
|