How can I apply "Page Setup" settings to all currently open Excel workbooks?

Question

I have just created a file in Excel and I have set it so that there are 10 different "workbooks" (the tab thingies at the bottom) and I'd like each workbook to print the gridlines. Is there any way for me to do this without having to individually set it 10 times? I'd also like to print all the workbooks at the same time, if this is possible?

Answer 1

Yes it is possible but using a macro (both for copying the page setup properties to the other workbooks and for printing). You can find such marcos on the web...

Answer 2

you can set up a template, check in HELP, this should allow you use those settings as a default. I pasted the below notes from Excel help - templates. Hope this helps.







Settings you can save in a template

Show All

Hide All

Formatting

Cell and sheet formats. Set by using the commands on the Format menu.

Page formats and print area (print area: One or more ranges of cells that you designate to print when you don't want to print the entire worksheet. If a worksheet includes a print area, only the print area is printed.) settings for each sheet.

Cell styles (style: A combination of formatting characteristics, such as font, font size, and indentation, that you name and store as a set. When you apply a style, all of the formatting instructions in that style are applied at one time.).

The number and type of sheets in a workbook.

Protected and hidden areas of the workbook. You can hide sheets, rows, and columns and prevent changes to worksheet cells.

Text, data, graphics, and formulas

Text you want to repeat, such as page headers and row and column labels.

Data, graphics, formulas, charts, and other information.

Data validation settings.

Toolbars, automation, and Option settings

Custom toolbars, macros (macro: An action or a set of actions you can use to automate tasks. Macros are recorded in the Visual Basic for Applications programming language.), hyperlinks (hyperlink: Colored and underlined text or a graphic that you click to go to a file, a location in a file, a Web page on the World Wide Web, or a Web page on an intranet. Hyperlinks can also go to newsgroups and to Gopher, Telnet, and FTP sites.), and ActiveX controls (ActiveX control: A control, such as a check box or button that offers options to users or runs macros or scripts that automate a task. You can write macros for the control in Microsoft Visual Basic for Applications or scripts in Microsoft Script Editor.) on forms. To make a custom toolbar available, attach the toolbar to the template.

Workbook calculation options and window view options. Set with the Options command (Tools menu).



to have default fonts, borders

Answer 3

I am not sure if this will help but if you go to the worksheet that you want to come up the next time you open this workbook just go to the worksheet then save the file. For instance; click the SHEET 3 tab then do a FILE/SAVE then close this workbook. When you next open that workbook it will open at SHEET 3.