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. The Auto Fill Options button might appear just below your filled selection after you fill text or data in a 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.įor more information, see Move or copy cells and cell contents. When you click the button, a list appears that lets you determine how to paste the information into your worksheet. The Paste Options button appears just below your pasted selection after you paste text or data. To turn AutoCorrect options on or off, click the AutoCorrect Options button, and then make a selection from the list.įor more information, see Choose AutoCorrect options for capitalization, spelling, and symbols . ![]() 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. For example, if you type a hyperlink or an e-mail address in a cell, the Autocorrect Options button might appear. The AutoCorrect Options button might appear when you rest the mouse pointer on the small blue box under text that was automatically corrected. The 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. Buttons that you might see on your worksheet This article describes what each of these buttons and triangles mean and how you can work with them. These buttons and triangles provide useful commands and information about the contents of the cell, and they appear at the moment you need them. ![]() In Excel, there are several types of option buttons and colored triangles that can appear in or next to a cell.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |