Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
set area in excel not giving me option to set print area? | Excel Discussion (Misc queries) | |||
Setting the print area in page set up to print 1 page wide by 2 pages tall | Excel Discussion (Misc queries) | |||
Print Area. 1st page Landscape 2nd page Portrait?? | Excel Worksheet Functions | |||
Active cell counting in particular print page (one sheet having different print area) | Excel Worksheet Functions | |||
How do you turn off a print area for a page? (no print area) | Excel Discussion (Misc queries) |