So you thought you knew every goddam’ Excel shortcut out there? Thought that you were the quickest draw around the office block. Not so fast sunny boy … not so fast ! You’ve just ventured into the mean and vicious badlands of the Bison.
You have two choices – stop reading this here …
… stay back and take up the challenge ….
So before I have your ego blown off, I will give you 7 chances to salvage it.
Excel Shortcut to Copy Contents of Cell onto Cells Below It
So how do you copy the contents of a given cell onto the cells below it?
I know what you are thinking – something like CTRL + C, then select the range using the SHIFT key and then CTRL + V. Right? Not quite.
Simply select the (vertical) range in which the first cell is the one you would like to copy down. Press CTRL + D.
Excel Shortcut to Enter a New Value into a Cell and Copy To Others
You have been sent over a partially filled worksheet with some data which unfortunately has some blank cells in it. From your experience you know some of the values and would like to quickly punch in those values and be done with it as fast as possible.
Stop right there!!! No entering a value and then copy pasting it over a range is not the quickest way around. Simply select the entire range (even a two dimensional one) and in the first cell, type in the value you would like to copy to all cells of the range. Press CTRL + ENTER.
Excel Shortcut To Hide All Objects (Including Charts) in the Worksheet
You finally managed to get that dashboard done with a gazillion charts and shapes. However you would like to rework the formulas and formatting. So there go another few hours in moving the charts and other shapes (one by one) around the spreadsheet and then editing the formulas underneath (you were smart, you hid the formulas under a chart so that nobody could see it 8) ). So anything you can do about it?
Simple. Press CTRL + 6 to hide all the objects and work directly with the cells underneath those objects. How do you turn them right back on. Simple again. Press CTRL + 6.
Excel Shortcut to Format as Date
You imported a ton of data from Oracle or MS-SQL or one of those wired applications that the IT people in your organization use nowadays. The morons sent you the data fine but the date columns come out having values something like 40179, 40180 etc. How do you convert them to date.
I know what you are thinking. You are thinking, hey that’s simple – Select the column, then right click and open the ‘Format Cell’ option and then format them as dates.
Here’s the better option – Press CTRL + SHIFT + #. That does it. One can also use :
Ctrl + Shift + $ to convert a value to currency and
Ctrl + Shift + % to convert to percent format.
Excel Shortcuts to Change Font Family and Font Size
You have a sentimental attachment to Calibri. You use Calibri when you draft your emails, use them in all your spreadsheets and even say goodnight to your wife in Calibri But that newly recruited analyst has an equally strong affinity for Arial. (He comes from the Arial gene pool). As a result, you spend a good amount of your time converting your spreadsheets to Calibri from Arial.
Any shortcuts you remember? Well I have one. Use CTRL + SHIFT + F. That opens up the Font family format option box. Another shortcut that works only with Excel 2003 is CTRL + SHIFT + P which let’s you change the font size (increase / decrease using the arrow key). While at it, any shortcuts to change the fill color of the cell? Again use CTRL + 1 to open the format cell option box and then (after releasing all keys) press ‘F’ (or ‘P’ if you’re using Excel 2003).
Excel Shortcuts to Draw Borders around Cells
Think what if I asked you to draw a border around a cell.
1. You take your hand off the keyboard.
2. Place it firmly on the mouse and then aim it precisely over the draw border option.
3. Take another split second choosing the correct border option and then press the trigger.
And that’s it. Yup you got me there. Fast. Neat work.
Not quite. I would use CTRL + SHIFT + &. Go back and check your spreadsheet, I just made two more smoking holes in it
Excel Shortcut to Add Comment or Edit It
This one – this one right here is a single handed trick (and a dirty left handed one at that). How do you enter a comment (or edit an existing one) in a spreadsheet? Before you say – Right click and Add / Edit Comment – Zip it. Pressing SHIFT + F2 does it as well. Works for both editing an existing one as well as adding a new comment.
Good that you made it this far cause I sure am done with this post.
I know what you’re asking yourself: Do I feel lucky.
Well, do ya, punk?
(In case you didn’t catch it, the dialog adaptation was from “Dirty Harry”, Released: 1971)