how to applythe page setup setings to allsheets in afile in excel

A

Asif

iI want to apply the page setup settings to all sheets in an excel work book.
How can I do it without having to go to each sheet and then doing it
individually?
Cn any one help?
 
M

Mike Middleton

Asif -

One method: Right-click a worksheet tab (at the bottom of the display), and
choose Select All Sheets. Then choose File | Page Setup ... and make any
other format changes that you want to apply to all sheets. Finally,
right-click a worksheet tab, and choose Ungroup Sheets.

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel
 

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

Page Setup 2
page setup 3
setting page setup/print area for multiple sheets 6
Page Setup 1
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Can I apply page settings to all sheets in Excel? 4
Printing Sheets in a Workbook 3
RE: can you print format multiple sheets in excel at once? 6

Top