+ Reply to Thread
Results 1 to 3 of 3

Thread: Checkboxes and repeat headers

  1. #1
    Registered User
    Join Date
    10-12-2011
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    1

    Checkboxes and repeat headers

    Hello,

    What I am trying to accomplish is I have a multi page spreadsheet with columns and in each row of these columns a checkbox. The column headers I want at the top of each printer page so I went to

    Page Set-up>Sheet tab>and using the Rows to repeat at top: select which ones I want to print on each page.

    My problem is when the second page prints the checkboxes are showing up overlapped on the column header. They are still aligned in my rows as well there just seems like an extra appears. I've change all the checkboxes to 'Don't move or size with cells', but it is still occurring. Anyone have any ideas. Or possibly know how to lock the checkboxes within the cell so they don't float if the rows change? Thanks.

  2. #2
    Registered User
    Join Date
    11-25-2010
    Location
    Glasgow
    MS-Off Ver
    Excel 2007
    Posts
    71

    Re: Checkboxes and repeat headers

    Hi there,

    Check boxes aren't very good to work with, I've had problems with them in the past and in fact have since avoided them where possible. If you post an example of what you have them we can have a look. Perhaps there is an alternative or a work around.

    lifesigns
    A day with nothing new achieved or learned, albeit however small, is a day lost forever…

    Constant Never Ending Improvement

  3. #3
    Registered User
    Join Date
    08-26-2009
    Location
    Iceland
    MS-Off Ver
    Excel 2003
    Posts
    19

    Re: Checkboxes and repeat headers

    Im not quite sure but can't you right click and choose either,
    move but don't size with cells or don't move or size with cells.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.2.0