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,570
    Thanks
    44
    Thanked 73 Times in 69 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,156
    Thanks
    0
    Thanked 268 Times in 257 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,156
    Thanks
    0
    Thanked 268 Times in 257 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
  •