Page Setup


A

azutjw

I have an excel file with many workbooks (sheets? Tabs. not sure of precise
nomenclature) that I view in read-only mode. I need to print it. Is there a
way to apply one page setup (page orientation, fit to, header/footer,
margins) to all sheets/books (Tabs)? There are 10, and I really don't want
to go through this for each.
 
Ad

Advertisements

J

Jim Thomlinson

First off you need to group the sheets together. Hold down the control key
and select the sheets that you want to format (you can also use the shift
key). Once you have selected all of the sheets then select File-> Page Setup
and make your changes.
 
Ad

Advertisements

A

azutjw

Works good!! Many thanks!jw

Jim Thomlinson said:
First off you need to group the sheets together. Hold down the control key
and select the sheets that you want to format (you can also use the shift
key). Once you have selected all of the sheets then select File-> Page Setup
and make your changes.
 

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

Top