Keyboard shortcut for paste special values
F4 – Change cell reference style while editing formulasĮxcel runs a pretty tight mafia when it comes to cell references. So I use ALT+ES (press E then leave the key and press S) to paste special. Often, I have to get data from other workbooks or clean the formatting of existing tables. ALT+ES – Paste Special > ValuesĬopying and Pasting is another must if you deal with data. Also, I use CTRL+SHIFT+arrow keys to select a group of cells 4. So I rely on CTRL+arrow key combinations all the time. When it comes to dealing with data, navigate, you must. CTRL+Arrow keys – Navigate around the workbook So I just turn-off and turn-on the filters, by pressing CTRL+SHIFT+L twice.
#KEYBOARD SHORTCUT FOR PASTE SPECIAL VALUES FULL#
So, Once I set a couple of filters, If I want to revert back to full data, I find clearing each filter a pain. Most of the time, I use filters to do ad-hoc analysis of my data. I use this all the time, to format cells, charts, text boxes – you name it. Oh CTRL+1, if I get an ear, every-time I press you, I would be a millionear by now. In this post, I am sharing 10 such shortcuts that I can’t live without, especially, when I am analyzing data, making charts and formatting my workbooks. So, it all boils down to memorizing the few shortcuts that you use all the time. While it may be a good idea to know a 97 different shortcuts for everything in Excel, the fact is, you don’t use them all the time.
Everyone and their colleague knows the importance of Excel keyboard shortcuts.