Quickly Move in Rows and Columns (CTRL+arrow key) To go back to the curser press CTRL+Backspace and excel will take you back to active cell.įor Mac, it’s Command+Delete. Or you may use mouse to navigate on sheet (which I don’t prefer). When you apply remove filter using shortcut, excel moves view to top of the table. To remove filter, press CTRL+SHIFT+L again. If table has empty columns, select all data or heading and hit this shortcut. If your data set has any empty column, the filter will apply to before that empty column. This command will apply filter to the data set.

When your curser is in the data, just press CTRL+SHIFT+L to apply filter. Shortcut to Apply Filter and Remove It (CTRL+SHIFT+L) When presss CTRL+AAA, entire sheet will be selected. CTRL+AA will select whole table, including headers.

In formatted table, CTRL+A, it will select table excluding headers. For example, if the curser in an empty cell which is that is not surrounded by any data, it will select whole sheet.īut when it is in a cell that is part of contiguous cells, then it will select whole set of cells. When you press CTRL+AA, it selects whole sheet.Īctually this command works different in different conditions. When you press it once, it only selects the table in which curser is right now.

Let me introduce, you with more excel hotkeys that reduce effort and time consumption. You know CTRL+C and CTRL+V hotkeys to copy and past. And when you know Keyboard shortcuts, you become a magician for others.Įxcel doesn’t only provides simple function to do complex tasks, It also has many useful excel keyboard shortcuts to fast forward the complex and lengthy tasks, and save time of other stuff. I personally, don’t like using the mouse and I prefer keyboard to do tasks.

How to do filter in excel shortcut keys