Excel Keyboard Shortcuts Learn about the many Excel keyboard shortcuts & discover a lot of hidden gems here! CTRL + SHIFT + ARROWS: Move / Highlight Cells If you want to quickly move to the last cell of your table/data you can press CTRL + ↔ ↕ . If you want to quickly highlight up to the last cell of your table/data you can press CTRL + SHIFT + ↔ ↕ . CTRL + SHIFT + L: Insert a Filter in Excel To insert a filter in Excel using a keyboard shortcut you need to click in a column heading and press CTRL+SHIFT+L To un-filter, you need to press this shortcut again. I use this shortcut all the time :) F4: Repeat Last Action If you want to repeat a previous action, like inserting a column/row, formatting cells, copy & pasting etc , then you can use the F4 keyboard shortcut which will repeat your last action (in most cases).
Comments
Post a Comment