[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 249
  • Last Modified:

Printing in Excel

Printing Many columns in Excel
 

Hi,

I have an example of an excel sheet (attached).  

I want to be able to print these on columns out but i would like to print the PAGE 2 preview below Page 1 (rather than on the next page to save on white space and also the number of sheets. (i.e 2 rows of data instead of one)

I am dealing with data in few rows but many columns.

Can anyone assist?

regards

 Book1.xls Book1.xls
0
forever7
Asked:
forever7
  • 2
  • 2
1 Solution
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Hello,

you will need to find the corresponding setting in your printer properties dialogue. All modern printers should have a setting to print n pages per sheet. Set this to 2 pages per sheet and print. Where exactly this setting is in your printer properties dialogue will depend on the type of printer you use. They all come with different dialogues.

cheers, teylyn
0
 
forever7Author Commented:
Hi,

i need to be able to print to PDF. I need to format the data to see in print preview. This spreadsheet gets emailed to someone else and all they need to do is print it.

I need to show headers and footers.

thanks
0
 
forever7Author Commented:
the header and footer is printed twice
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
In that case, you will need to arrange the table on an Excel sheet to show as you want to see it printed. Excel is not very sophisticated when it comes to printing and does not provide the functionality you describe out of the box.

You may want to set up a helper sheet where you reference the cells from the original sheet and arrange that according to your printing needs.

cheers, teylyn

0

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now