Course Content

Course Content

Navigation in MS Excel

How do you Open the Navigation Panel


Now we will see about Navigation in MS Excel.


Whenever we want to navigate in our Excel sheet, we usually prefer our arrow keys or mouse pointer to navigate.


We have our mouse pointer as a 3D 'plus' sign, and as we navigate it to the left side of our sheet where different numbers are shown and select any number, are mouse pointer will turn into an 'arrow' sign, and as soon as we click on it will select the whole particular row.


If we navigate our mouse pointer between two digits, it will turn into a 'two way up down arrow' sign. Similarly if we navigate date between our columns then it will turn into 'two way left right arrow' sign.


So like this our mouse pointer works differently on different parts of our Excel sheet.


We can also navigate between number of sheets by using 'Ctrl+Page Up' and 'Ctrl+Page Down'.


If we want to switch from one particular worksheet into different worksheet, we can go into our VIEW tab, and can do that with 'Switch Windows' icon.


Press Ctrl+F6 (forward) and Ctrl+Shift+F6 (reverse) to travel between the main areas in Excel for the web (backward).

Select the View tab, then the Navigation button to open the pane (or use the keyboard shortcuts Alt > W > K to access the Navigation pane). Select a section name in the Navigation pane to view that sheet; expand it to see its contents, which include tables, named ranges, and images.

You can view different worksheets in a workbook by navigating worksheets in Excel. To switch between worksheets, click the worksheet name tab of the one you want to see. The worksheet name tabs are located in the workbook's lower-left corner. In Excel, you may easily navigate worksheets using keyboard shortcuts.

There are 4 different types of pivot tables:

  • Pivot table with cross-tabs:
  • Pivot table with totals:
  • Pivot table with subtotals:
  • Data model

Pivot tables are a powerful tool that can help you summarize and analyze large amounts of data. A pivot table is created by dragging fields from the data source to the “Rows” or “Columns” area of the PivotTable Fields task pane.

Recommended Courses

Share With Friend

Have a friend to whom you would want to share this course?

Download LearnVern App

App Preview Image
App QR Code Image
Code Scan or Download the app
Google Play Store
Apple App Store
598K+ Downloads
App Download Section Circle 1
4.57 Avg. Ratings
App Download Section Circle 2
15K+ Reviews
App Download Section Circle 3
  • Learn anywhere on the go
  • Get regular updates about your enrolled or new courses
  • Share content with your friends
  • Evaluate your progress through practice tests
  • No internet connection needed
  • Enroll for the webinar and join at the time of the webinar from anywhere