Once the Excel Name box is activated you can type in the address of a Cell or a Data range and press the Enter key to select it. Activate Excel Name BoxĪlt + F3 is the shortcut to activate Excel Name Box. Use the Right/Left Arrow keys to move to the Next/Previous sheets and press the Enter key to select a sheet. You will see a Green Rectangle around the current sheet tab. To select the current Sheet Tab press the function F6. Type in the name of the function and press Ctrl + Shift + A to insert the arguments of a function. This dialog box contains the definition of each function argument and is helpful for those who are new to Excel functions. To activate the Function Arguments dialog related to an Excel function, type in the function name, and press Ctrl + A. Select the data and press Ctrl + L to activate the Create Table dialog.Įxcel Table was previously known as List and this shortcut comes from that old name (L for List). But there is one more shortcut for creating a Table in Excel and that is Ctrl + L. Auto fill list for Cells without Data Validation ListsĬtrl + T is a very popular Excel shortcut that is used to create Tables.
0 Comments
Leave a Reply. |