| View previous topic :: View next topic |
| Author |
Message |
jefffreeman
Newbie
Joined: 09 Jun 2012
Posts: 1
|
 Posted: Sat Jun 09, 2012 12:15 pm Post subject: Page Break Preview |
 |
|
(SOLVED!) Sorry  Here we go again. When I change to page break preview all the cells in the worksheet are highlighted in grey and there are no page breaks (blue lines).
Has anyone else run into this?
Last edited by jefffreeman on Mon Jun 11, 2012 4:36 am; edited 1 time in total |
|
| Back to top |
|
 |
ken johnson
Super User
Joined: 23 Apr 2009
Posts: 1851
Location: Sydney, Australia
|
| Posted: Sat Jun 09, 2012 3:58 pm Post subject: |
|
|
Only when all cells on the sheet are empty.
Ken Johnson
_________________
If your problem has been solved please add "[Solved]" to the beginning of your first post title (edit button). |
|
| Back to top |
|
|
ken johnson
Super User
Joined: 23 Apr 2009
Posts: 1851
Location: Sydney, Australia
|
| Posted: Sat Jun 09, 2012 4:11 pm Post subject: |
|
|
Sorry, tell a lie, a sheet with data and no pages showing in Page Break View doesn't have a defined print range.
Select your data then go Format|Print Ranges|Define and the shading will disappear and the blue page breaks will appear.
Ken Johnson
_________________
If your problem has been solved please add "[Solved]" to the beginning of your first post title (edit button). |
|
| Back to top |
|
|
|
