Print area giving me 1 page per cell
Hi,
When I try to adjust my spreadsheet to one page both manually (through print layout view) and automatically (by adjusting to 1 page tall by 1 page wide) I get a print layout that is 1 page per cell. Any idea what is causing this error and what I can do to fix it? Thanks |
Print area giving me 1 page per cell
Use the menu View option and choose Page Break view and see if you have a
bunch of page breaks in the sheet? "Coop" wrote: Hi, When I try to adjust my spreadsheet to one page both manually (through print layout view) and automatically (by adjusting to 1 page tall by 1 page wide) I get a print layout that is 1 page per cell. Any idea what is causing this error and what I can do to fix it? Thanks |
Print area giving me 1 page per cell
I do. The page break view does not help, and I can not adjust it any
differently from that view. Any other ideas? Thanks for the thought. "JLatham" wrote: Use the menu View option and choose Page Break view and see if you have a bunch of page breaks in the sheet? "Coop" wrote: Hi, When I try to adjust my spreadsheet to one page both manually (through print layout view) and automatically (by adjusting to 1 page tall by 1 page wide) I get a print layout that is 1 page per cell. Any idea what is causing this error and what I can do to fix it? Thanks |
Print area giving me 1 page per cell
Check the usual suspects - make sure your paper size is set to letter and
hasn't gotten set to an envelope or something, also check the margins and make sure they aren't so large as to reduce the sheet to a one-liner. I swear someone else had the same problem in the past and it got fixed, but I don't recall the specific fix. Might search the forums for something like '1 cell' or 'one cell' or even Google for 'one cell per page'. "Coop" wrote: I do. The page break view does not help, and I can not adjust it any differently from that view. Any other ideas? Thanks for the thought. "JLatham" wrote: Use the menu View option and choose Page Break view and see if you have a bunch of page breaks in the sheet? "Coop" wrote: Hi, When I try to adjust my spreadsheet to one page both manually (through print layout view) and automatically (by adjusting to 1 page tall by 1 page wide) I get a print layout that is 1 page per cell. Any idea what is causing this error and what I can do to fix it? Thanks |
Print area giving me 1 page per cell
Thanks. However, my guess is that it has something to do with virtual memory
or ram or something like that. Reason is that this used to happen to me on my old computer only when operating very large (i.e., 20MB) spreadsheets, although on my new computer, it is happening on much smaller spreadsheets (< 1 MB). If I send the file to another computer though I do not get the same problem. Thanks, Jon "JLatham" wrote: Check the usual suspects - make sure your paper size is set to letter and hasn't gotten set to an envelope or something, also check the margins and make sure they aren't so large as to reduce the sheet to a one-liner. I swear someone else had the same problem in the past and it got fixed, but I don't recall the specific fix. Might search the forums for something like '1 cell' or 'one cell' or even Google for 'one cell per page'. "Coop" wrote: I do. The page break view does not help, and I can not adjust it any differently from that view. Any other ideas? Thanks for the thought. "JLatham" wrote: Use the menu View option and choose Page Break view and see if you have a bunch of page breaks in the sheet? "Coop" wrote: Hi, When I try to adjust my spreadsheet to one page both manually (through print layout view) and automatically (by adjusting to 1 page tall by 1 page wide) I get a print layout that is 1 page per cell. Any idea what is causing this error and what I can do to fix it? Thanks |
All times are GMT +1. The time now is 06:09 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com