This is an essential shortcut when you’re working with a large set of data and want to extend your selection to the bottom, or any edge it can be activated by pressing Ctrl + Shift + Direction arrows.

Extended selection

  • Paste Special

It is a powerful shortcut. It works more than a typical paste option. One can paste values, formulas, formatting, and even column widths by pressing  Ctrl + Alt + V.

Paste Special

  • Formula references

Typing $ again and again for each formula seems like a ton of work. By using the F4 shortcut one can quickly rotate through all absolute and relative formula reference option.

Formula references

  • Fill down

An excellent way to copy values from the cell above without the hassle of copy-paste. It can be toggled by pressing Ctrl + D also fill column by pressing Ctrl + R 

Fill down

  • Auto sum

You can use this option to sum rows, columns, or even an entire table in one step. Pressing Alt+ = will automatically insert a sum function.

Auto sum

Read Also: 15 Microsoft Excel keyboard shortcuts every beginner

  • Current Date and Time

Want to fill the current date and time but does typing it, again and again, seem like a hassle? Microsoft got you covered for this, users can press control + ; for the current date and Control + Shift + : for the current time.

Current Date and Time

  • Go to first cell / last cell

It’s easy to traverse from one cell to another without hitting your keyboard multiple times. Ctrl + Home is used to go to the first cell whereas Ctrl + End is used to go to the last cell.

Go to first cell / last cell 

  • Repeat the last action

Many commands can be repeated in MS Excel like applying the same borders, format, or even inserting a worksheet again. It can be activated by either pressing F4 or Ctrl + Y.

Repeat the last action

Read Also: Top 5 laptop stands to keep your laptop cool 

  • Data navigation

This option lets you move to the edges of the data instantly, without tediously scrolling. It comes in handy when the data sets are large in number. Using Ctrl + Navigation keys will help in this case.

Data navigation 

  • Insert/delete columns and rows

To insert an entire row or column selected, use Ctrl + Shift + + and if you wish to delete, select an entire row or column and use Ctrl + -.

Insert/delete columns and rows

  • Enter in multiple cells

Whenever you want to enter the same value or formula in more than one cell at a time press Ctrl + Enter and multiple cells selected will be auto-filled.

Enter in multiple cells

  • Format cells

This option is often used by many people but, the traditional way is quite a time taking process. It can be easily done by pressing  Ctrl + 1. It will open a Format Cell dialogue box. Though one can use it to format anything in MS Excel.

Format cells

  • New Table

Ctrl + T can be used and is very handy when you want to convert a set of data to a proper Excel table with filters and formatting.

New Table

  • Reveal Formulas

 A very fast way to temporarily reveal all formulas in a worksheet. It can be achieved by pressing Ctrl + `. Use the shortcut again to turn formulas back to invisible.

Reveal Formulas

  • Toggle Filters

This option is used to clear all the filters applied in a table. This option comes in handy when one user wants to reset a table with many filters. Users can press Ctrl + Shift + L to use this feature.

Toggle Filters

These shortcuts are very easy to use, remember and will come in handy in making proper Excel sheets in no time. These will not only save a lot of time but will also increase your productivity.

For the latest gadget and tech news, and gadget reviews, follow us on Twitter, Facebook and Instagram. For newest tech & gadget videos subscribe to our YouTube Channel. You can also stay up to date using the Gadget Bridge Android App. You can find the latest car and bike news here.