+ Reply to Thread
Results 1 to 4 of 4

How to Print Landscape From Beginning?

  1. #1
    Registered User
    Join Date
    06-13-2005
    Posts
    27

    How to Print Landscape From Beginning?

    What I mean by this question is that the only way I ( a blundering novice) have found to print landscape is to alter things a little way down the track at which time the system thinks the print job is already a two-page job with the columns spread across two sheets.

    So then when I say print landscape it prints one sheet landscape and still prints the remainder of the columns on a second sheet - uselessly in landscape.

    I'm thinking I should be able to define a range or have a selection and then go 'print' and then tell it right there I want it landscape - because only with landscape will it fit an A4 page.

    See the problem I'm having?

    The tiny sheet I have is only about 1" or one column longer than the width of an A4 and I've spent an hour and about 20 sheets of paper trying to get it right already...

    Can someone please help?

  2. #2
    Registered User
    Join Date
    12-17-2016
    Location
    South Wales
    MS-Off Ver
    Excel 2007, 2016
    Posts
    68

    Re: How to Print Landscape From Beginning?

    Assuming you have Excel 2007 or later, there should be a section in the "ribbon" at the top of the page, containing options such as landscape/portrait, allowing you to set print areas, etc. Some of the options bring up a print setup window containing other options ... one of which allows you to zoom the print. So you could set to print as one sheet wide, and excel will automatically scale the print down to fit the paper.

  3. #3
    Registered User
    Join Date
    06-13-2005
    Posts
    27

    Re: How to Print Landscape From Beginning?

    That's exactly what I think. There should be.

    But I don't find it.

    Actually I'm using Open Office Calc. Perhaps that's the reason?

  4. #4
    Registered User
    Join Date
    12-17-2016
    Location
    South Wales
    MS-Off Ver
    Excel 2007, 2016
    Posts
    68

    Re: How to Print Landscape From Beginning?

    Probably. Whilst other spreadsheet packages may be able to open Excel files, they won't necessarily have the full range of functionality...

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] print chart in landscape
    By wayneg in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-10-2013, 09:23 AM
  2. Can't display or Print in Landscape
    By Gill Gamesh in forum Excel General
    Replies: 0
    Last Post: 08-08-2012, 12:34 PM
  3. Excel 2007 : Can't print landscape mode
    By jlfg in forum Excel General
    Replies: 0
    Last Post: 11-07-2011, 07:21 PM
  4. Excel 2007 : Print Problem in landscape
    By Tiarella in forum Excel General
    Replies: 1
    Last Post: 08-31-2010, 06:16 PM
  5. Print Landscape
    By z0rpia in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-11-2009, 11:52 PM
  6. VBA to make print landscape
    By sparx in forum Excel General
    Replies: 0
    Last Post: 08-02-2006, 02:23 AM
  7. [SOLVED] won't print in landscape
    By mike in forum Excel General
    Replies: 1
    Last Post: 01-09-2006, 02:30 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1