Results 1 to 6 of 6
  1. #1
    New Lounger
    Join Date
    Apr 2015
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    display column headers when viewing workbook

    Is there a way to have column headers in row 1 appear on each page when viewing (not printing) an excel 2013 workbook? When viewing a large spreadsheet, it is sometimes difficult to remember what the contents of a cell refer to once I cannot see the headings in row 1.

  2. #2
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,468
    Thanks
    30
    Thanked 61 Times in 57 Posts
    Welcome to the lounge.

    Try switching to page layout view once you've set the rows that will print on all pages.

  3. #3
    Silver Lounger
    Join Date
    Mar 2014
    Location
    Forever West
    Posts
    2,072
    Thanks
    0
    Thanked 259 Times in 248 Posts
    Check out Freeze Pane, keeps a selected number of rows on the screen while allowing scrolling through a sheet.
    https://www.google.com/search?site=&....0.wx_sU1PVCTI

  4. #4
    New Lounger
    Join Date
    Apr 2015
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by Berton View Post
    Check out Freeze Pane, keeps a selected number of rows on the screen while allowing scrolling through a sheet.
    https://www.google.com/search?site=&....0.wx_sU1PVCTI
    Perfect!! Thanks so much for solving this problem for me.

  5. #5
    New Lounger
    Join Date
    Apr 2015
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by kweaver View Post
    Welcome to the lounge.

    Try switching to page layout view once you've set the rows that will print on all pages.
    Thanks for the suggestion, kweaver... I'll give it a try.

  6. #6
    Silver Lounger
    Join Date
    Mar 2014
    Location
    Forever West
    Posts
    2,072
    Thanks
    0
    Thanked 259 Times in 248 Posts
    Quote Originally Posted by vertrev View Post
    Perfect!! Thanks so much for solving this problem for me.
    You're welcome, glad to help.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •