Results 1 to 4 of 4

Thread: Not able to adjust print area in Microsoft Excel

  1. #1
    Join Date
    Nov 2011
    Posts
    111

    Not able to adjust print area in Microsoft Excel

    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) then 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.

  2. #2
    Join Date
    May 2011
    Posts
    449

    Re: Not able to adjust print area in Microsoft Excel

    You can use the menu View option and choose Page Break view and see if you have a bunch of page breaks in the sheet.

  3. #3
    Join Date
    Jun 2011
    Posts
    804

    Re: Not able to adjust print area in Microsoft Excel

    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 not to large so as to reduce the sheet to a one-liner. Might search the forums for something like '1 cell' or 'one cell' or even Google for 'one cell per page'.

  4. #4
    Join Date
    Jun 2011
    Posts
    641

    Re: Not able to adjust print area in Microsoft Excel

    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 then I do not get the same problem.

Similar Threads

  1. Color print not working in Microsoft Excel
    By Ulrich in forum MS Office Support
    Replies: 2
    Last Post: 03-02-2012, 04:09 PM
  2. The print option in Microsoft Excel Grayed out
    By Rishon in forum MS Office Support
    Replies: 4
    Last Post: 27-01-2012, 06:06 PM
  3. How to fix Print Error Message in Microsoft Excel
    By The-Farmer in forum MS Office Support
    Replies: 3
    Last Post: 13-01-2012, 03:58 PM
  4. Replies: 5
    Last Post: 14-05-2011, 11:03 PM
  5. How to set print area in Microsoft Excel
    By Okies in forum Windows Software
    Replies: 3
    Last Post: 30-10-2009, 10:17 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •