Skip to main content

TIP - 49 : Open second Window for excel - So work in different place at a time

Open second Window for excel

In excel, we can open a second window so that we can work in different worksheets at a time (This will be mostly useful when we have dual monitor). 

And we can arrange the windows as well based on the requirement like Horizontal or vertical etc.

Step 1: Please click on New Window from View tab

A new window of excel file will be opened with book name along with number

Comments

Popular posts from this blog

Report Publishing via Pivot Table in different sheets

Report Publishing via Pivot Table in different sheets This feature is mostly helpful to publish the data in sheet wise Step 1: Create pivot table with Report filter , go to analysis tab or Options tab from "PivotTable options" Step 2: Click on options drop down Step 3: Then click on  “Show report filter pages” Now we can see the new excel sheet tabs names along with data, published based on the report filtered data.