As we can see in the above image, there are a lot of keyboard shortcuts available in the filter menu.Įxample #3 – Select Menu Items Using Arrow keys.As we can see that every cell contains drop down an icon like the image then, Press the ALT + down arrow key on the keyboard to open the filter menu like the below screenshot. Once the filter has enabled on your data, you can use the drop-down menus on each of the column headers. Refer to the below screenshot.Įxample #2 – Opening the Drop-down Filter Menu in Excel Once applying the filter, the drop-down filter menus will appear in the header row of your data.We also can use the Keyboard Shortcut CTRL+SHIFT+L for turning On/Off the filters. Go to the DATA tab then, click on the Filter option under the Sort Filter section.First, select a cell in your data range if the data range contains any blank columns or rows, then better to select the entire range of cells.Tab - Moves one cell to the right in a worksheet.We have given below sales data region wise. Shift+Tab - Moves to the previous cell in a worksheet, or moves one cell to the left in a selected range.

Shift+PageUp - Selects the cell range from the current cells to the previous screen of the same column(s). Shift+PageDown - Selects the cell range from the current cells to the next screen of the same column(s). Shift+mouse - Selects the area from the active cell to the clicked cell. Shift+Insert - Inserts the contents of the Clipboard at the insertion point and replaces any selection. Shift+Home - Extends the selection of cells to the first row of this window in this column. Shift+f10 - Displays context menu for a selected item. Shift+Enter - Moves one cell up in a selected cell range. Shift+ARROW - Extends the selection of cells by one cell, or row/column in that direction. PageUp - Selects the cells in the previous screen in the same column(s).

PageDown - Selects the cells in the next screen in the same column(s). Home - Moves to the cell in the upper-left corner of the window. List of Keyboard Shortcuts for SpreadsheetsĪlt+Enter - Starts a new line in the same cell.Īlt+F11 - Displays the Microsoft Visual Basic EditorĪlt+F8 - Displays the Macros dialog box to run, edit or delete macros.Īlt+Space - Displays the Control menu for the program windowĪRROW KEYS - Move one cell up, down, left, or right in a worksheet.īackspace - Clears the content of the active cell to reedit cell content.Ĭtrl+1 - Displays the Format Cells dialog box.Ĭtrl+Arrow keys - Selects the entire worksheet.Ĭtrl+Arrow keys - Moves to the edge of the current data region in a worksheet.Ĭtrl+B - Applies or removes bold formatting.Ĭtrl+D - Uses the Fill Down command to copy the contents and format of the topmost cell of a selected range into the cells below.Ĭtrl＋End - CTRL+END moves to the last cell on a worksheet, in the lowest used row of the rightmost used column.Ĭtrl+Enter - Fills the selected cell range with the current entry.Ĭtrl+F1 - Displays the Task Pane on the right side of the program window.Ĭtrl+H - Displays the Replace dialog box.Ĭtrl+Home - Moves to the beginning of a worksheet.Ĭtrl+I - Applies or removes italic formatting.Ĭtrl+K - Displays the Hyperlink dialog box to insert new hyperlinks or edit existing hyperlinks.Ĭtrl+mouse click - Selects multiple ranges of cells.Ĭtrl+O - Displays the Open dialog box to open or find a file.Ĭtrl+PageDown - Switches between worksheet tabs, from right-to-left.Ĭtrl+PageUp - Switches between worksheet tabs, from left-to-right.Ĭtrl+R - Uses the Fill Right command to copy the contents and format of the leftmost cell of a selected range into the cells to the right.Ĭtrl+S - Saves the active file with its current file name, location, and file format.Ĭtrl+Shift+= - Displays the Insert dialog box.Ĭtrl+Shift+ARROW - Extends the selection of cells to the last nonblank cell in the same column or row as the active cell, or if the next cell is blank, extends the selection to the next nonblank cell.Ĭtrl+Shift+Home - Extends the selection of cells to the beginning of the worksheet.Ĭtrl+Shift+Tab - Goes to previous worksheet tab.Ĭtrl+V - Inserts the contents of the Clipboard at the insertion point and replaces any selection.Ĭtrl+W - Closes the selected workbook window.Ĭtrl+Y - Repeats the last command or action, if possible.Ĭtrl+Z - Uses the Undo command to reverse the last command or to delete the last entry you typed.Įnter - Moves one cell down in a selected cell range.į2 - Edits the active cell and positions the insertion point at the end of the cell contents.į4 - Repeats the last action of adding or deleting the whole row/column.į7 - Displays the Spelling dialog box to check spelling in the active worksheet or selected range.į9 - Calculates all worksheets in all open workbooks.į12 - Displays the Save As dialog box to save the file with a different name, type or location.

Excel keyboard shortcut rename sheet