7 Short cuts to Save you Time in Excel

Do you know that you could save 47 hours a year using shortcuts instead of doing things manually with the mouse?
According to our figures, you could be 4.5 times more productive!

Microsoft Excel is used widely for many purposes. It is a powerful and versatile tool especially if you use it to its full potential.

One of the best ways to improve your efficiency using Excel is to reduce your dependence on your mouse and learn some keyboard shortcuts!

Here are some shortcuts that  will save you time.
If you can master these, then you will see a big difference, especially when working on large data sets.

Navigate to the Last Populated Record on a Column

Let’s say you are working on a large data set and have no idea how long it’s going to take to scroll down using your mouse to the last record.
Use the following shortcut instead:

Save time in excel by using the ctrl, plus and arrow down shortcut keys excel users will be taken to the last populated row

This shortcut takes you to the last populated cell. If you have some empty cells in the middle of your spreadsheet, it will stop at these (for the column you are in), making it great for finding data gaps. You can repeat the shortcut to navigate to the next populated cell until you reach the end of your spreadsheet.

What’s really cool is you can use this mode of navigation in every direction using the four different arrows.

Save time in excel by using the shift, ctrl and arrow down key excel users can move quickly around the spreadsheet

Select a Column Partially

The following shortcut is also helpful when you’re working with large data sets but only need to select a specific piece of it.

Let’s imagine you have a few empty cells and a label on top of your column and you want to exclude these rows from your selection.
Place your cursor on any cell and use this keyboard combination to select your column data to the last populated cell.
Just like the last populated shortcut, this can be applied in any direction, with the four different arrows.
Other common commands used in Excel include the inserting of rows and columns. Again, you could use the menu but the keyboard is so much quicker. I use these shortcuts below to quickly add rows and columns.

Select the Entire Row

Save time in excel by selecting an entire row using shift plus space bar

Select the entire column

To save time in excel select an entire column ctrl key plus space bar

I find the above really useful when using Excel. But there are other cool simple shortcuts available to insert data; date and time are classic examples.

Insert Current Time

Save time when wanting to insert the time in excel hit the ctrl key plus shift key and semi colon

Insert Current Date

To save time when insert current date in excel use the control key plus semi colon key

 

Finally, if you are working with formulas a lot, sometimes it’s nice to see what the formula is rather than the value.

Show/Hide a Formula

Save time in excel and show a hidden formula in a cell by hitting the control plus exclamation key

Once you master these shortcut options, you’ll find yourself flying around your Excel spreadsheet at a pace you didn’t think was possible.

About the Author:
Lily Mazieres – Pre-Sales Consultant USA

Lily is a presales product strategist at More4Apps. Read more about here.

Lily Mazieres
Lily Mazieres

Pre-Sales Consultant

Categories
Share
Share on facebook
Share on twitter
Share on linkedin
Share on email
We'd love to hear from you!​
If you have any questions, suggestions or just want to say hi, please contact us.