USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Zoom to Selection
|
|
|
New Window
|
|
|
Arrange All
|
|
|
Freeze Panes
|
Detailed explanation-1: -On the View tab, in the Window group, click Arrange All. Under Arrange, click the option that you want. If the sheets that you want to view are all located in the active workbook, select the Windows of active workbook check box.
Detailed explanation-2: -Select View > View Side by Side. If you scroll up or down, the other scrolls as well. If you want them to scroll separately, select Synchronous Scrolling to turn it off.
Detailed explanation-3: -Open your first worksheet as you normally would. Press CTRL + N to open a new Excel window. In the new window, click File > Open and select your second file. Click the View Side by Side button.
Detailed explanation-4: -Generally, when 4 workbooks are opened and go to View tab > Arrange All > select “Tiled", they will be displayed tiled on the screen at the same time.