![]() |
#1
|
|||
|
|||
![]() I have a speadsheet and when printing i want to show columns A & B 1 to 32 but also A to G 1 to 5 on every sheet with C to AA 6 to 32 i know how to repeat A & B 1 to 32 but cant repeat the top rows again hope you understand what i am trying to do but hard to explain its a form that i am trying to make. |
#2
|
|||
|
|||
![]()
Hi
You could do this using vba but you cannot do it with standard functionality. Why do you need to do this? Tony |
#3
|
|||
|
|||
![]()
I need it for printing a register of equipment
|
#4
|
|||
|
|||
![]()
solved just copied the c to g ,1 to 5 along top of sheet as these dont change so they appear on each print with a to b 1 to 32
|
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
In Excel 2007-After Selecting Visibe Cells-How do I "Copy to Visible cells" Only | mag | Excel | 0 | 10-28-2012 08:04 PM |
![]() |
lostsoul62 | Excel | 5 | 10-17-2012 08:33 AM |
![]() |
zanat0s | Excel | 1 | 07-03-2012 04:27 AM |
![]() |
DrDOS | Excel | 2 | 03-27-2012 02:53 PM |
Count range cells eliminating merge cells | danbenedek | Excel | 0 | 06-15-2010 12:40 AM |