Sunday, June 21, 2020

VIEW MULTIPLE WORK SHEET IN A FILE

We always open two or more work sheet in a file when we work in excel, if we want to view multiple Excel worksheets at the same time, follow the following steps - 
Open a workbook.
Next click on the View tab, 
Now on the View tab, in the Window group, click on New Window-
Now click on Arrange All. Here we get following window
Further Click on Horizontal & windows of active workwook.
Result - we wii get following screen in which sheet of sales & purchase find in one screen as follows -
















No comments: