Tip & How-To about Microsoft Computers & Internet

20 Most important shortcuts in MS Excel

  1. Cut, copy, paste - Ctrl X, C, V (Mac: you can also use Command). I guess this is expected, since other applications share the same shortcuts. And, of course, these are shortcuts you'll use every day.
  2. Extend selection - Control Shift arrow keys (Mac: you can also use Command). These are absolutely critical shortcuts when you're working with a large set of data and want to extend your selection to the bottom, or any edge.
  3. Paste Special - Control + Alt + V (Mac: Control + Command + V). Paste Special is extremely powerful. You can paste values, paste formulas, paste formatting, and even paste column widths!
  4. Fill down - Control D. An excellent way to copy values from the cell above without copy paste. Several people also mentioned Fill right, Control + R
  5. Toggle formula references - F4 (Mac: Command Shift T). Who likes to type $ signs in a formula? No one. Use this shortcut to quickly rotate through all absolute and relative formula reference options (i.e. A1, $A$1, $A1, A$1).
  6. Autosum - Alt = (Mac: Command + T). A classic "magic" shortcut to automatically insert a sum function. You can use autosum to sum rows, columns, or even an entire table in one step (more details here; autosum demo here).
  7. Toggle filters - Control + Shift + L (Mac: Command + Shift + F). An excellent shortcut to apply and clear all filters. It's a very handy way to "reset" a table with many filters applied...just use it twice.
  8. Current date and time - Control + ; (date) Control + Shift + : (time). If you need a date or time stamp, it's magic.
  9. Select all - Control A (Mac: you can also use Command). This shortcut will select all data in the "same region". Use it whenever you want to select an entire table.
  10. Go to first cell / last cell - Control + Home, Control + End. (Mac: fn + Control + left arrow, fn + Control + right arrow. Very satisfying when you want to go instantly to the first cell or last cell of a worksheet, no matter where you are. Bonus: add the shift key to select everything on the way.
  11. Repeat last action - F4 or Control Y (Mac: Command + Y). Did you know that many commands can be repeated? You can use this for things like applying the same borders, format, or even to insert a worksheet again. (Note: on Macs up to 2011, this shortcut is not as robust).
  12. Data navigation - Control + arrow key(s) (Mac: you can also use Command). These shortcuts are "must know" if you work with large sets of data. They let you move to the edges of the data instantly, without tedious scrolling.
  13. Fill handle - double click that little square at the bottom right of any selection. While not a keyboard shortcut, it's still one of the most powerful features in Excel, because it will copy a formula (or a pattern) down a column to the bottom of a table in one click.
  14. Insert / delete columns and rows - To insert: with an entire row or column selected, use Control+ Shift ++ (Mac: Control + I, but in 2016, same as Win) . To delete: with an entire row or column selected, use Control + - .
  15. Edit cell - F2 (Mac: control + U) to enter "edit mode" for the active cell without taking your hands off the keyboard.
  16. Enter multiple cells - Control + Enter. Whenever you want to enter the same value or formula in more than one cell at a time. You'll be surprised how often you use it once you understand how it works.
  17. Format cells - Control + 1 (Command + 1). Most people know this as the shortcut for the Format Cells dialog, but you can also use it to format almost anything in Excel, without care about the state of the ribbon. Try it.
  18. Select visible cells only - Alt + ; (Mac: command + shift + Z). The trick to copying only what you see. Priceless when you're manually hiding rows and columns.
  19. New Table - Control + T. Very handy when you want to convert a set of data to a "proper" Excel table with filters and formatting. Tables are a powerful and convenient way to handle lots of data easily.
  20. Toggle formulas on and off - Control + `. A very fast way to (temporarily) reveal all formulas in a worksheet. Use it again to turn formulas off again.

Posted by on

Computers & Internet Logo

Related Topics:

Related Questions:

1 Answer

How do I cut and paste?


Windows: Hold down the CTRL key then click
  • C to copy
    or
  • X to cut
  • V to paste
Mac: Hold down the Command key. Then, as with Windows, click:
  • C to copy
    or
  • X to cut
  • V to paste


How to Copy Cut and Paste for Beginners

Aug 19, 2014 | HP Computers & Internet

1 Answer

copy and paste instructions


Press the "Copy" keyboard shortcut. This will copy everything that you have selected. The original file(s) or text will stay in the original location. You can only copy one selection at a time; if you copy something else before pasting, it will overwrite the first copy. The "Copy" shortcut for each operating system is:
  • Windows and Linux: ^ Ctrl+C
  • Mac OS X: Command+C

Jul 31, 2014 | Gateway Computers & Internet

1 Answer

How do I cut and paste via a shortcut in Adobe Photoshop


First of all, make sure you know what you want to select: command + a selects the whole document. selection a section is easy too, but you have to make sure that the right layer (on the right) is selected.

command + c = copy
command + v = paste

Here is a handy list of all of mac's shortcuts: OS keyboard shortcuts

Jan 08, 2014 | Adobe Photoshop 7.0 for Mac

3 Answers

Where is my Dell computers Command key?


The Command Key is only found in Mac computers. It gives shortcuts to common commands by using the keyboard. The Control Key (CTRL) gives the same function in Windows computers. Therefore, the Command Key on Dell computers or any other windows-based computer is the Control Key (CTRL).
For Example...
  1. CTRL + C = Copy
  2. CTRL + V = Paste
  3. CTRL + S = Save
  4. CTRL + X = Cut
  5. CTRL + Shift Key + S = Save As

Mar 06, 2011 | Computers & Internet

2 Answers

pasteing and how it works


If you mean pasting in relation to cut / copy & pasting

How it works
When you cut or copy something, for example text, it is saved into the clipboard. Then when you paste, the text that is in the clipboard gets pasted. You can paste that same text more than once, it stays in the clipboard until it is over written (by cutting ot copying something else) or you restart your PC.

How to use it
There is a couple of ways to cut / copy & paste

1. Use right clicking menu
you can select something, some text for example, then right click on it with your mouse and select Cut or Copy. To paste right click where you want the text to be pasted and select Paste

2. Use application's Edit drop down menu
you can select something, some text for example, then select the application's Edit drop down menu and select Cut or Copy. To paste click where you want the text to be pasted select the application's Edit drop down menu and select Paste

3. Use keyboard shortcuts
you can select something, some text for example, then press Ctrl + X to Cut or Ctrl + C to Copy. To paste click where you want the text to be pasted then press Ctrl + V to Paste

Hope this helps

-Magnon

May 10, 2008 | Computers & Internet

Not finding what you are looking for?

436 people viewed this tip

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2888 Answers

Piyal Perera
Piyal Perera

Level 3 Expert

528 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18409 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Loading...