| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
Why does EXCEL insert bace breaks on every cell of some worksheets
On some old worksheets, EXCEL is setting page breaks at every cell.
Specifying a smaller group of cells as the print area restores the desired single page, but dragging the page break over or down one more cell causes the breaks to appear at every cell ans a message that the margin doesen't fit. It seems that the page size is suddenly reduced to less than 1inch x 1 inch. Resetting the margins to .05 allows the page to be displayed, but adding a row or column again trips back to one cellper page? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I insert multiple page breaks simultaneously in Excel? | Excel Discussion (Misc queries) | |||
| Excel: how to insert page breaks between all the rows at once? | Excel Discussion (Misc queries) | |||
| How do I insert page breaks in a huge EXCEL file? | Excel Discussion (Misc queries) | |||
| How do I insert page breaks in .txt for use in excel? | Excel Discussion (Misc queries) | |||
| How do I insert manual line breaks in excel? | Excel Worksheet Functions | |||
![Mr Chips[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
