Problems Setting Columns to Print

  • Thread starter Thread starter Kristen
  • Start date Start date
K

Kristen

I have a speadsheet (Excel 2000) that consists of a range
of cells (A1:AV44) - I want to print columns A thru Y on
page one and columns Z thru AV on page 2. I cannot figure
this out. The margins are all set at 1" all the way
around. I changed the scaling, margins, fit to 2 pages by
1 page. I don't know what else to do. Does anyone have
any suggestions?

Thank you
 
Hi
one workaround:
- start recording a macro
- select columns A:Y and goto 'File - Printarea
- set the printarea and print this range (one one single
sheet)
- now select the other range, set the printarea and print
this part of your sheet

After this stop recording a macro and use this macro for
the future :-)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

wrap columns to print in rows 1
Can I print page numbers on every other page only? 1
How to set up Excel to print wrapped columns on a page. 1
Setting print area 1
rows and columns on worksheet 1
Append multiple columns 2
append multiple columns 2
How can I expand print area to whole page? 8

Back
Top