Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old September 17th 07, 01:36 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 5
Default 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   Report Post  
Old September 17th 07, 04:34 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2006
Posts: 3,365
Default 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   Report Post  
Old September 17th 07, 04:38 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 5
Default 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   Report Post  
Old September 17th 07, 12:56 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2006
Posts: 3,365
Default 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   Report Post  
Old September 19th 07, 05:36 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 5
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Setting the print area in page set up to print 1 page wide by 2 pages tall EA[_2_] Excel Discussion (Misc queries) 2 July 12th 07 08:39 PM
set area in excel not giving me option to set print area? J Littlebear Excel Discussion (Misc queries) 3 May 30th 07 12:49 AM
Print Area. 1st page Landscape 2nd page Portrait?? Corey Excel Worksheet Functions 1 June 23rd 06 08:18 AM
Active cell counting in particular print page (one sheet having different print area) ananthmca2004 Excel Worksheet Functions 1 November 24th 05 11:29 AM
How do you turn off a print area for a page? (no print area) Grunen Excel Discussion (Misc queries) 4 October 8th 05 07:46 PM


All times are GMT +1. The time now is 01:15 AM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017