how to change print area on whole workbook in excel for mac

Change Print Area On Whole Workbook In Excel How To Attach It

My System: I am on a MacbookPro OSX Version 10.9.2, 2.8GHz Intel Core i7 Processor.

The Problem: Although each individual Worksheet is setup and prints correctly on 1 page (including the columnsrows, layout, and scaling), when I click Print Entire Workbook, the settings do not maintain.

Thus, I have to go through and print each individual worksheet separately rather than 1 batch Print Entire Workbook job.

What Ive tried: 1) I have tried selecting all of the tabs, applying the same settings, but then some pages are scaled strangely and print very small.

I have tried setting up each Page Setup individually and then Print Entire Workbook.

Change Print Area On Whole Workbook In Excel How To Attach It

I have a sample Workbook so you can see my problem, I wasnt sure how to attach it on this forum.

Thanks for the help I might send you a candy bar if you help me solve this problem.

In cell A2 if the value A then allow both positive and negative integers.

I have attached sample data, i need someone to help me convert the left side to how the data looks on the right.

At that point, you can use Scale To Fit option to adjust your entire data into a single page.

Im sure these tips will help print your data more professionally.

It has been a part of my life from last 6 years and I love everything about it.

Oh yes, the one thing which I dont like to do in Excel is printing data.

But that doesnt mean excel is not capable of printing data effectively.

You can print your worksheets and workbooks in a flash just using some printing options.

Printing Tips for Excel users Print Titles Page Orders Printing Comments Scale to Fit Custom Header Footer Center on Page Select Print Area Custom Margins Change Cell Error Values Start Page Number with a Custom Number Table of Contents Formatting an Excel Worksheet for Printing 1.

Start Page Number with a Custom Number Conclusion Read More Formatting an Excel Worksheet for Printing 1.

Print Titles This is one of the most useful printing options in excel.

Lets say you a have heading row in your data and you want to print that heading row on every page you print.

Here are the steps.

Go to Page Layout Tab - Page Set Up - Click on Print Titles.

Now in your page setup window go to sheet tab and specify following things.

Rows to repeat at the top: Heading row(s) which you want to repeat on every page.

Columns to repeat at the left: Column(s) which you want to repeat at the left side of every page if you have any.

Click OK. Now, when you print your data, the heading row and left column will be print on every page.

Page Order Page order option is useful when you have a large number of pages to print.

Read More: Dialog Box launcher of Excel Ribbon Using page order option is quite simple.

Go to File Tab - Print - Print Setup - Sheets Tab.

Now here, you have two options: The first option, if you want to print your pages using vertical order.

The Second option, if you want to print your pages using horizontal order.

As I said its quite useful to use page order option when you have a large number of pages to print, you can decide which page order you want to use.

Printing Comments You can print your comments in a smart way.

Sometimes when you have comments in your worksheet, its hard to print those comments in the same manner they have.

So, the better option is to print all those comments at the end of pages.

In print section, select At the end of the sheet using comment drop down.

Just like below format.

Scale To Fit This is also a quick fix to print data in excel.

Im sure you have faced this problem in excel that sometimes its hard to print your data on a single page.

How To Change Print Area On Whole Workbook In Excel For Mac