+ Post New Thread
Results 1 to 7 of 7
How do you do....it? Thread, <Solved> Excel question - printing - second sheet not picking up column heads in Technical; I'm trying to print a 2 page athletics club register out of MS Excel 2007. The first page is fine ...
  1. #1
    speckytecky's Avatar
    Join Date
    May 2006
    Location
    UK
    Posts
    2,533
    Thank Post
    3,417
    Thanked 261 Times in 213 Posts
    Blog Entries
    3
    Rep Power
    110

    <Solved> Excel question - printing - second sheet not picking up column heads

    I'm trying to print a 2 page athletics club register out of MS Excel 2007. The first page is fine - has, header, the column heads and all expected records but the 2nd page has the header the colums heads are missing and for some reason the details from line 4 is repeated as the first row.

    When I go to Page Setup / Sheet /

    Print Area, Print Tiles Rows to Repeat at Top and Columns to Repeat to the Left are not accessible?
    Last edited by speckytecky; 23rd December 2010 at 03:38 PM. Reason: Solved

  2. #2

    elsiegee40's Avatar
    Join Date
    Jan 2007
    Location
    Kent
    Posts
    9,780
    Thank Post
    1,813
    Thanked 2,229 Times in 1,645 Posts
    Rep Power
    801
    Try going into print preview and then going to setup from there.

    I've never used 2007 - but sometimes have found in 2003 that you can do different things in setup depending on how you access it.

  3. Thanks to elsiegee40 from:

    speckytecky (23rd December 2010)

  4. #3
    speckytecky's Avatar
    Join Date
    May 2006
    Location
    UK
    Posts
    2,533
    Thank Post
    3,417
    Thanked 261 Times in 213 Posts
    Blog Entries
    3
    Rep Power
    110
    Yep that was sort of it - thanks elsiegood. I was accessing it from Print Preview but looking at your reply got me to thinking there must be another way.

    Page layout / Print Tiles gave me the same as from Print Preview but this time allowing me to select the row to be repeated.

    Quote Originally Posted by elsiegee40 View Post
    Try going into print preview and then going to setup from there.

    I've never used 2007 - but sometimes have found in 2003 that you can do different things in setup depending on how you access it.

  5. #4

    elsiegee40's Avatar
    Join Date
    Jan 2007
    Location
    Kent
    Posts
    9,780
    Thank Post
    1,813
    Thanked 2,229 Times in 1,645 Posts
    Rep Power
    801
    Quote Originally Posted by speckytecky View Post
    Yep that was sort of it - thanks elsiegood. I was accessing it from Print Preview but looking at your reply got me to thinking there must be another way.

    Page layout / Print Tiles gave me the same as from Print Preview but this time allowing me to select the row to be repeated.
    You'd have thought they'd have sorted this by now. It shouldn't matter how you get to the Page Setup, you should always get the same options... I know, I'm being naive * sigh *

  6. #5

    mac_shinobi's Avatar
    Join Date
    Aug 2005
    Posts
    9,828
    Thank Post
    3,340
    Thanked 1,057 Times in 978 Posts
    Rep Power
    365
    Quote Originally Posted by elsiegee40 View Post
    You'd have thought they'd have sorted this by now. It shouldn't matter how you get to the Page Setup, you should always get the same options... I know, I'm being naive * sigh *
    This is Microsoft we are talking about, right ?

  7. #6

    elsiegee40's Avatar
    Join Date
    Jan 2007
    Location
    Kent
    Posts
    9,780
    Thank Post
    1,813
    Thanked 2,229 Times in 1,645 Posts
    Rep Power
    801
    Quote Originally Posted by mac_shinobi View Post
    This is Microsoft we are talking about, right ?
    I know, I have moments of complete idiocy when I forget the bloomin' obvious.

    Like when the wireless on son's xbox wouldn't work; I should have realised that I needed to connect with a wire and download every single update going before trying to use the darn thing. It's M$; why would it work straight out of the box?!

  8. #7
    speckytecky's Avatar
    Join Date
    May 2006
    Location
    UK
    Posts
    2,533
    Thank Post
    3,417
    Thanked 261 Times in 213 Posts
    Blog Entries
    3
    Rep Power
    110
    Them was greyed out in print preview my old beauty, when it's something you don't regularly encounter and the little grey cells are toward the older end help is more often needed.

    Quote Originally Posted by elsiegee40 View Post
    You'd have thought they'd have sorted this by now. It shouldn't matter how you get to the Page Setup, you should always get the same options... I know, I'm being naive * sigh *

SHARE:
+ Post New Thread

Similar Threads

  1. Replies: 1
    Last Post: 11th June 2010, 09:23 PM
  2. [MS Office - 2003] Excel printing issue - try it....
    By kennysarmy in forum Office Software
    Replies: 0
    Last Post: 5th May 2010, 09:03 AM
  3. [MS Office - 2003] Excel printing documents twice!
    By TheFopp in forum Office Software
    Replies: 6
    Last Post: 25th February 2009, 10:04 PM
  4. Printing Preferences - Excel
    By Psymon in forum Office Software
    Replies: 0
    Last Post: 12th January 2009, 03:18 PM
  5. Replies: 2
    Last Post: 11th December 2008, 12:04 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

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