New Posts
Home / Computer 4 Beginners / Adjusting Microsoft Excel Worksheet Views

Adjusting Microsoft Excel Worksheet Views

Adjusting Microsoft Excel Worksheet Views.

It is very important to understand Adjusting Microsoft Excel Worksheet Views. So, In this article, we will show you how to work the Adjusting worksheets views. Where we will learn topics like Freezing and unfreezing panes, Splitting screens horizontally and vertically, Collapsing and expanding data views with outlining,  Displaying multiple worksheets and workbooks.

Excel-Worksheet-Views

Freezing and unfreezing panes.

Like many lists in excel. Suppose you open any large list when you scroll down the with the keyboard or with the mouse. You notice that you lose top rows. The title you have used at top rows also they going to be hidden during the time of navigation of rows. I mean when you scroll down.

If you want to tick your titles or rows then you have to use Freeze Panes.

View.

Freeze Panes.

Freeze panes

 Free panes example

Note: Freeze Panes can be used both for the Rows and Columns.

For removing  Rows and columns Panes.

View.

Freeze Panes.

Un-Freeze panes.

Un-Freeze panes

Freeze as the column.

Freeze as column

Splitting screens horizontally and vertically.

When you have created a list, and see it sometime advantages to see the table different parts of list same time there is a way to see the feature is called split rather than clicking on the right away. you can insert split everywhere in the list. For doing this do the following steps.

View.

Split.

Split

Row and Column both can be spilled.

 Row and Column both can be spilt

Also, row and column both can be spilled.

Collapsing and expanding data views with outlining.

Data.

Group.

Auto Outline.

 Auto Outline

To hide the menus.

Double click on any menu name like data.

display ribbon options

auto hide

show outlining

Clear the outline.

Data.

Ungroup.

Clear the outline.

Displaying multiple worksheets and workbooks.

If you have more than one workbook open. Sometimes advantages to see. The portion of each workbook and other time. When you focusing on single workbook it might be your advantages to be able to see worksheet of that same work. You can get little confusion time if you do have multiple workbooks to open.

View.

 Displaying multiple worksheets and workbooks

Displaying multiple worksheets and workbooks 2

Displaying multiple worksheets and workbooks 3

If you add switch windows command in quick access toolbar that command will be used easily.

View.

 arrange all

arrange windows

About imran

My Name Mohammad Ramzan Bhutto. Live in District Jacobabad, Sindh, Pakistan. I have started blogging on Information Technology, my selected areas are Online Business, Digital Marketing, Make Money Online.

Check Also

Microsoft Excel Data Analysis Tools

Microsoft Excel Data Analysis Tools

Learning Microsoft Excel Data Analysis Tools. This article illustrates the Microsoft Excel Data Analysis Tools. …