course bg
EduPristine>Blog>10 Time Saving Excel Shortcuts

10 Time Saving Excel Shortcuts

February 12, 2015

They say there are no shortcuts to success but this is not entirely true, not when it comes to your excel spreadsheets. When you are working on Excel then your success entirely depends upon the shortcuts you use. Why waste 5 minutes when you can perform a task in some seconds. If you haven’t started using excel shortcuts yet then start now, here are some Excel Shortcuts which will make your life easy.

Shortcuts and Tips

1.  To Open New Worksheet – Generally when you want to open a new sheet you drag your mouse to the bottom of the sheet to add a new sheet but instead of this you can easily use a shortcut.

Use Shift + F11 and the sheet shall be added

Navigate between the sheets easily.

Use Ctrl+ Page up or Ctrl+ Page Down to navigate easily.

Excel shortcut to open a new worksheet

2.  Selecting, Adding and deleting an entire column – Why give stress to your mouse when you can easily use your keyboard to select a column, add a column, delete a column.

To Select a column use Ctrl + Spacebar

To Add a column use Ctrl + +

To Delete Column use Ctrl + –

how to select, add and delete a column in excel

3.  Repeat Action – Want to carry out the same function again in the excel sheet??? Well no need to perform it again.

UseF4 and your actions shall be repeated.

how to perform same function again in excel

4.  Insert a Comment – Now your expert comments are just key away.

Use Shift + F2 and you can type and edit your comments in the comment box.

Use Shift + F10 + M and you can delete your comment.

shortcut to add and delete comment in excel

5.  Hyperlink – Hyper linking is now a few seconds job.

Use Ctrl + K and add the link of the desired location and your data shall be hyperlinked.

Excel shortcut for adding a hyperlink

6.  Navigating Within sheets – Navigating within sheets can be a tedious task if you have a lot of data

Use Ctrl + arrow keys and you can easily navigate within the sheets.

How to navigate within sheets in Excel

7. Format Cells – Why search for format cell option in ribbons tab and waste time.

Use Ctrl + 1. This will launch the dialog box of format cells and you can format the cells accordingly

Excel shortcut for formatting cells

8.  In cell spell check – If you think that you have made a spelling error while inputting the data then you can use the in cell spell check.

Use F7 which will help you to find the error and shall provide you with the right spelling suggestions.

Spell check shortcut in excel

9.  Hide or unhide ribbon menu – Don’t get worried when you are not able to see the ribbon menu on the top of Excel sheet.

Use Ctrl + F1 and the ribbon menu shall re-appear and incase you want to hide it then do the same.

how to hide/unhide ribbon in excel

10.  Create new workbook – Stop using the long way to create a new workbook.

Use Ctrl + N and the new worksheet shall appear.

Excel is a vast and one of the best programs and hence there is something new to learn everyday. We shall come up with some new and important tips and tricks in our new blog and till then if you find something interesting then do share with us in the comments section.

About Author

avatar EduPristine

Trusted by Fortune 500 Companies and 10,000 Students from 40+ countries across the globe, it is one of the leading International Training providers for Finance Certifications like FRM®, CFA®, PRM®, Business Analytics, HR Analytics, Financial Modeling, and Operational Risk Modeling. EduPristine has conducted more than 500,000 man-hours of quality training in finance.

Comments

Interested in this topic?

Our counsellors will get in touch with you with more information about this topic.

* Mandatory Field

`````````````````````````````````````````````````` Post ID = 71192