So I asked him, "Why? I am working really fast."
"Nope, you are not. You are using the mouse. In Excel, if you use the mouse then you will be very slow. Use keyboard shortcuts."
That advice changed my Excel life. In a few weeks I had memorized enough keyboard shortcuts that I could be on Excel making complex reports and switching between eight different Excel files without touching the mouse. I even close Excel files without clicking on anything, I use CTRL + W.
Today, I will be sharing with you my most used keyboard shortcuts.
I will start with a list of the ones we all know and move to less known ones.
- CTRL + C => Copy
- CTRL + V => Paste
- CTRL + X => Cut
- CTRL + F => Find and Replace
- CTRL + B => Make cell entry bold
- CTRL + U => Underline cell entry
- CTRL + I => Make cell entry italic
- CTRL + A => Select all (within current region). Do CTRL + A twice to select entire Excel sheet
- CTRL + O => Launch the file opening dialog box. To open an Excel file,
- CTRL + P => Print
- CTRL + S => Save
- CTRL + Z =>Undo
- CTRL + Y => Redo (more like undo undo)
- CTRL + T => Convert your cells records to a table. Tables are more colorful and formula friendly. Try it for any Excel list you have created.
- ALT, H, V, V => To paste what I copied as values
- ALT, H, K => To format number as comma style (10000 to display as 10,000.00)
- ALT, H, 9 => To remove decimal points (change the 10,000.00 to 10,000)
- ALT, H, E, A => To erase everything in the cells I selected, including borders and color formatting. The usual Delete only removes content not borders and colors. So I use this a lot.
- ALT, A, M => To remove duplicates
- ALT, N, V, T => To insert a Pivot Table. It's ALT, N, V for Excel 2013
- ALT, A, F, T => To import a text file into Excel
- ALT, H, V, S, V, D => To add one cell's value to another cell's. Equivalent of copy, paste special, paste as value and add to existing value.
- ALT, H, V, S, E = > Paste as transpose. I use this a lot too.
- ALT, H, V, S, V, M => To multiply a cell with the value of another cell. Same as copy paste special, paste as value and multiply. I use this to convert numbers stored as text to numbers by multiplying them all with a cell I typed 1 into.