ArtsAutosBooksBusinessEducationEntertainmentFamilyFashionFoodGamesGenderHealthHolidaysHomeHubPagesPersonal FinancePetsPoliticsReligionSportsTechnologyTravel
  • »
  • Technology»
  • Computers & Software»
  • Computer Software»
  • Office Software Suites»
  • Microsoft Office

How to View Multiple Excel Worksheets at Once

Updated on July 2, 2013
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.

Comments

    0 of 8192 characters used
    Post Comment

    No comments yet.

    Click to Rate This Article