How to Use Excel Shortcuts for Navigation

 

In this post, we will learn how to use keyboard shortcuts for navigation purpose. We will cover some of the very basic shortcuts in excel, most of which we are already aware of plus a few more keys for navigation.

Excel shortcuts to navigate through individual cells

– Cut : Ctrl+X

Copy: Ctrl+C

Paste: Ctrl+V

– Delete Cell Contents : Del

Note : DO NOT use Backspace key to delete the cell contents

– Undo : Ctrl+Z

– Redo : Ctrl+Y 

Select All : Ctrl+A

– Open a file : Ctrl+O

– Create a new file (new workbook) : Ctrl+N

– Print a file : Ctrl P

– Press Escape key ESC to exit from anything in excel (eg. To exit from print window after pressing Ctrl+P, to exit from a formula etc.)

–  Close a file : Ctrl+F4

–  Close excel : Alt+F4

–  Save File : Ctrl + S

–  Find : Ctrl+F

–  Replace : Ctrl+H. Use Alt+R to actually perform the replace action.

–  Switch Windows : Alt+Tab

These were some basic shortcut keys, now we will move to some more excel shortcuts used for smooth navigation.

Some more excel shortcuts

– Ctrl+Arrow keys : Jump to boundaries (eg. Ctrl+Right Arrow key will take you to right boundary)

Excel Shortcuts
Excel Shortcuts

– Shift+Arrow Keys : Allows you to select Multiple Cells (Eg: Shift+Right,Shift+bottom etc.)

Excel Shortcuts
Excel Shortcuts

– Ctrl+Shift+Arrow keys : Allows to select entire block

– Shift+F8 key: Allows you to select multiple sections.

To use this, select multiple sections using any of the above mentioned keys like say Ctrl+Shift+Arrow keys, press Shift+F8, to keep that area selected and then move on to select another section.

Excel Shortcuts
Excel Shortcuts

Ctrl+Spacebar : Select entire column

Excel Shortcuts
Excel Shortcuts

– Shift+Spacebar : Select entire row

Excel Shortcuts
Excel Shortcuts

 

So these were some of the very basic excel shortcuts used for navigation purpose. Using these, you can easily do away with mouse usage.

What you can do now to practice this. (Try doing it with the excel shortcuts mentioned above)

1. Open a new workbook. Create some data. Copy some data from the workbook and paste this data in new workbook.

2. Close the newly created workbook.

3. Open our workbook. Select multiple areas in the sheet.

4. Close the current workbook.

Become an Excel expert.

Special Bonus on BIWS Programs from FinanceWalk
Here's an offer on Breaking Into Wall Street (BIWS) programs:

All FinanceWalk readers will get FREE $97 Bonus - FinanceWalk's Equity Research Program.

If you want to build a long-term career in Financial Modeling, Investment Banking, and Private Equity, I’m confident these are the only courses you’ll need. ( Because Brian (BIWS) has created world-class online financial modeling training programs that will be with you FOREVER).

If you purchase BIWS courses through FinanceWalk links, I’ll give you a FREE Bonus of FinanceWalk's online Equity Research Program ($97 Value).

I see FinanceWalk's Equity Research Program as a pretty perfect compliment to BIWS courses – BIWS helps you build financial modeling and investment banking skills and then I will help you build equity research and report writing skills.

To get the FREE $97 Bonus, please purchase from the following links.

Excel and Financial Modeling Fundamentals – Free $97 Bonus

Advanced Financial Modeling - Free $97 Bonus

Bank & Financial Institution Modeling – Free $97 Bonus

Oil & Gas Modeling – Free $97 Bonus

Real Estate & REIT Modeling – Free $97 Bonus

Investment Banking Networking Toolkit – Free $97 Bonus

Investment Banking Interview Guide – Free $97 Bonus

IB Networking Toolkit + IB Interview Guide $144 ( Save $50)

BIWS Platinum – Save $632 ( Save 35%) + Free $97 Bonus : The most comprehensive IB package on the market today. Includes the NEW and Improved BIWS Premium Financial Modeling Course (RRP: $497) PLUS access to the above 6 complementary courses designed to make you into an even more well-rounded IB Professional:

BIWS Premium – Excel & Modeling Fundamentals and Advanced Financial Modeling programs together – save $97 ( Save 20% ) + Free $97 Bonus

Industry Specific Course Bundle – get Bank Modeling + Oil and Gas Modeling + Real Estate Modeling for just $697 and save $344 + Free $97 Bonus

In order to get your FREE Bonus, you must:

  1. Purchase the course through FinanceWalk links.
  2. Send me an email along-with your full name and best email address to avadhut@financewalk.com so I can send you the course login details.
Click Here to Check All BIWS Programs – Free $97 Bonus

Next Batch Starts on 8th September, 2015
Our Full Time Financial Modeling Investment Banking Course (6 Weeks) starts on 8th September, 2015 and 10 Day Weekend Workshop starts on 5th September, 2015 in New Delhi, India.

Only few seats remain. Interested candidates can contact me

Free Download: Financial Modeling Videos

Learn the best tools, get Discount Coupon Codes and Bonus to build a powerful career in finance.

Leave a Reply

Your email address will not be published. Required fields are marked *