Maximize or restore the selected workbook window.ĭisplay the shortcut menu for the selected item.ĭisplay the menu or message for a smart tag.Ĭreate a chart of the data in the selected range.Ĭreate new worksheet with name like Macro1, Macro2… Select the menu bar and close an open menu and submenu at the same time. Recheck dependent formulas and then calculates all cells in all open workbooks. Performs calculations on formulas.Ĭalculate all worksheets in all open workbooks, regardless of whether they have changed since the last calculation. Perform spell check in the selected range.Īctivate move window cursor provided window is not maximized.Īctivate resize window cursor provided window is not maximized.Įnable Add to Selection mode – select non-adjacent cells when enabled. Switch to the previous workbook window when more than one workbook window is open. Switch to the previous pane in a worksheet that has been split. Switch to the next workbook window when more than one workbook window is open. Switch to the next pane in a worksheet that has been split. Switch between the Help task pane and the application window. Restore the window size of the open workbook. But movement is left and then to the above row. Selection toggles only until the cell that contains data then goes to the next row. Gives option to save or discard current changes. Repeat last action (for example, create a text box) or toggle among cell references. Thank you for reading CFI’s Excel shortcuts overview.Must Read: If you wish to explore basic and general uses of function keys read out post on the best and default uses of function keys F1 Shortcut KeyĬreate a chart from data in the current range.Ĭreate names by using row and column labels. In this case, the active cell is cell A2, with the text data “Orange.”Ĭells A2:A4 contain the text data Ĭells B1:D2 contain the text data Ĭells B2:B4 and D2:D4 contain currency data, denoted in $Ĭells C2:C4 contain number data Learn more about Excel
![what is excel shortcut keys what is excel shortcut keys](https://i.ytimg.com/vi/NXCVuE59DSs/maxresdefault.jpg)
There can only be one active cell regardless of how large a selection is. This would be referenced in Excel formulas as A2:D2. In this cutout from a spreadsheet, the user has a selection containing cells A2 to D2. These pieces of data only show columns A to D and rows 1 to 4. Converting to number type from percentage will show the number as a decimal. These can be converted back into number type data, and vice versa. Percentage type data are a subset of numbered data that is converted into a percentage.There are multiple formats for dates within Excel. Dates are pieces of data that denote a date and/or time.Currency/accounting pieces of data utilize numbers in conjunction with a currency marker.Unlike text type data which can use numbers, number type data cannot use letters. Numbers are pieces of data that utilize numbers exclusively.However, these numbers must be used in conjunction with letters or must manually be set to text. Text are pieces of data that utilize letters.There are also different types of data that exist within Excel. The value n depends on the operating system and version of Excel. A row is a group of horizontal cells, referenced in Excel by integers in increasing order from 1 to n.As such, the column directly after column Z is column AA, followed by column AB. Beyond column Z, Excel will repeat letters a second time. A column is a group of vertical cells, referenced in Excel by letters in ascending order from A to Z.If more than one cell is in the selection, the active cell will be highlighted in white, while the rest of the selection is highlighted in gray. A selection is the active cell, or a group of cells currently selected.
![what is excel shortcut keys what is excel shortcut keys](http://1.bp.blogspot.com/--HPZelS5f9g/UnfTi-YBRdI/AAAAAAAABxM/UKHDYhpgMd0/s1600/exceltip2day-[Ctrl]+++[Tab]+Excel+Shortcut+Key+Switch+To+The+Next+Tab+In+Dialog+Box_00.png)
An active cell is the cell currently selected by Excel.A cell is any of the many boxes within the Excel spreadsheet.
![what is excel shortcut keys what is excel shortcut keys](https://1.bp.blogspot.com/-rfT8E7utbBY/X3dBmSKaHWI/AAAAAAAAJCM/LSPL0Pv8zZkyVvcX_fCeob2hscCiS4zSQCLcBGAsYHQ/s1553/a7bee08b0de469d5c287f5896c523af5.jpg)
Before diving into the Excel shortcuts, it would be prudent to first discuss basic terminology around the elements of Excel.