How to View Multiple Excel Worksheets at Once

Source

© 2013 by Aurelio Locsin.

Using different worksheets in Excel 2013 is an excellent way to organize related information for one workbook. For example, you can use one worksheet for each month to record income and expenses, or use each sheet to represent budget items. In such cases, it’s sometimes useful to show two or more worksheets at the same time, such as when you’re transferring items among sheets.

  1. Click the View tab and then click “New Window” in the Window group for each worksheet you want to view.
  2. Click “View Side by Side” in the Window group to view the current tab in all windows.
  3. Click the tab of the worksheet you want to display in each window.
  4. Change how the windows are arranged by clicking “Arrange All” in the Window group to display the Arrange Windows dialog box. Click a check mark into the box labeled “Windows of Active Workbook.” Then choose how you want to arrange the windows, such as “Vertical” or “Horizontal.” Cick the “OK” button to save your changes, close the dialog box and arrange the windows.

More by this Author


Comments

No comments yet.

    Sign in or sign up and post using a HubPages Network account.

    0 of 8192 characters used
    Post Comment

    No HTML is allowed in comments, but URLs will be hyperlinked. Comments are not for promoting your articles or other sites.


    Click to Rate This Article
    working