Microsoft Excel Shortcuts

logo_microsoft_excel-580x250

In our month of November Excel tips, I wanted to add some shortcuts for you.  As we get busier and busier in our workdays, shortcuts become a necessary part of our life.  Therefore, I want to let you know, or remind you if you already know, how easy it is to open, close or create a new workbook in Excel.

Ready for it?  Here goes:

To Open an existing workbook, just hit CTRL + O.  You will see a list of your workbooks.

To Close an existing workbook, just hit CTRL + F4.   If there have been changes, Excel will ask you if you would like to save them.

To Create a new workbook, just hit CTRL + N.  A new, blank workbook will open for you.

If you want to completely close out of Excel, use the ALT + F4 shortcut.  Again, you will be prompted on whether you would like to save any changes.

If you have two or more workbooks open, which is pretty common if you work on or update multiple sheets during the day, simply hit CTRL + TAB to switch back and forth between workbooks.

To move between sheets in a multi-sheet workbook, the keyboard shortcut is either CTRL + PgUp or CTRL + PgDn.  This shortcut easily navigates around the workbook for you.

I hope these shortcuts are of some help to you.  Have any that you use and would like to contribute to this list (which is certainly not conclusive)?  Please let me know if these are shortcuts you typically use, or if you have learned something that might make your day easier, if even in a slight way.  I’d love to hear from you!

Advertisements
This entry was posted in Tuesday Tech Tip and tagged , , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s