F2 – Edit a cellįor simple workbooks I do not use names. But whos got the time to carefully navigate between A and 2 and then type SHIFT+4? So I use F4 key and Excel changes the referencing style for me. You must pay it a couple of $s if you want to change the reference style from relative (A2) to absolute ($A$2). 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. 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.
0 kommentar(er)
