+ 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,603
    Thank Post
    3,541
    Thanked 295 Times in 223 Posts
    Blog Entries
    3
    Rep Power
    117

    <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 04:38 PM. Reason: Solved

  2. #2

    elsiegee40's Avatar
    Join Date
    Jan 2007
    Location
    Kent
    Posts
    10,057
    Thank Post
    1,896
    Thanked 2,375 Times in 1,745 Posts
    Rep Power
    833
    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,603
    Thank Post
    3,541
    Thanked 295 Times in 223 Posts
    Blog Entries
    3
    Rep Power
    117
    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
    10,057
    Thank Post
    1,896
    Thanked 2,375 Times in 1,745 Posts
    Rep Power
    833
    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,985
    Thank Post
    3,535
    Thanked 1,107 Times in 1,014 Posts
    Rep Power
    374
    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
    10,057
    Thank Post
    1,896
    Thanked 2,375 Times in 1,745 Posts
    Rep Power
    833
    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,603
    Thank Post
    3,541
    Thanked 295 Times in 223 Posts
    Blog Entries
    3
    Rep Power
    117
    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, 10:23 PM
  2. [MS Office - 2003] Excel printing issue - try it....
    By kennysarmy in forum Office Software
    Replies: 0
    Last Post: 5th May 2010, 10:03 AM
  3. [MS Office - 2003] Excel printing documents twice!
    By TheFopp in forum Office Software
    Replies: 6
    Last Post: 25th February 2009, 11:04 PM
  4. Printing Preferences - Excel
    By Psymon in forum Office Software
    Replies: 0
    Last Post: 12th January 2009, 04:18 PM
  5. Replies: 2
    Last Post: 11th December 2008, 01: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
  •