You use the following shortcuts to select an entire row or column that contains the active cell. CONTROL DĪlso read: How to use Fill Handle in Excel #4 Select Entire Row/Column Note that this would copy the contents, formulas, and formatting as well. Use it to copy the cell right above the active cell. This one would help you while entering data in Excel. How to Multiply in Excel using Paste Special.Five Paste Special Shortcuts that will save you a lot of time.If you only want to copy the values, use the following keyboard shortcut. When you copy and paste a cell or a range of cells, it also copies the value, the formula in it, and the formatting. If you have numbers in a column/row, you can quickly get the sum by using this Excel keyboard shortcut. CONTROL T would mean hold the Control key and press the T key. How to use interpret keyboard shortcuts: CONTROL + T would mean press the Control key and then press the T key. In this tutorial, I am sharing my top 20 Excel Keyboard shortcuts that can help you speed up your work and save a lot of time. I took his advice and knowing Excel keyboard shortcuts has helped me tremendously in my work (especially in impressing my boss). Just master the ones you need regularly and you’ll do awesome”. He always seemed to have a keyboard shortcut for everything. When I started my career as an analyst, I was completely in awe with one of my colleagues who was super-fast while working with Excel.

If you work with Excel day in and day out, Excel Keyboard Shortcuts can help you shorten your workday and save a lot of time.Īdditionally, it also has the power to enchant your co-workers and boss into thinking you’re an Excel Wizard. These are Command (or Cmd) ⌘, Shift ⇧, Option (or Alt) ⌥, Control (or Ctrl) ⌃, and Fn.Watch Video – 25 AWESOME Excel Keyboard Shortcuts (You Should Know)! If you are using a Mac, you should be aware of the Mac keyboard symbols i.e modifier keys. You can also create an Excel shortcuts PDF by going to print settings and saving the page as a PDF. Of course, we don’t expect you to remember up all the Excel shortcuts, so feel free to bookmark thispage for later use. The MS Excel shortcut list includes shortcuts for simple as well as advanced functions. 50+ MS Word Shortcut Keys for Windows and macOS Laptops

Excel shortcut keys