Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old September 12th 06, 04:21 PM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2006
Posts: 1
Default Format Worksheets in a Workbook

How do I set a global print format for many worksheets within workbook?

  #2   Report Post  
Old September 12th 06, 06:38 PM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 22,908
Default Format Worksheets in a Workbook

Most print setup functions will be available for grouped sheets.

Right-click on a sheet tab and "select all sheets"

Do your print setup on the active sheet and will be done to all sheets.

NOTE.............you cannot set print range or rows to repeat at top using this
method.

Those must be set using code.


Gord Dibben MS Excel MVP

On Tue, 12 Sep 2006 08:21:02 -0700, vjboaz
wrote:

How do I set a global print format for many worksheets within workbook?




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Is there a way to sort worksheets within a workbook Mim Excel Discussion (Misc queries) 6 October 23rd 07 03:48 PM
Excel should let its worksheets be arranged (tiled) in a workbook Stephen Flanders Excel Worksheet Functions 1 January 19th 06 07:20 PM
Viewing Worksheets withing One Workbook cagedbirdflies New Users to Excel 1 February 22nd 05 11:09 PM
How do I format all worksheets in a workbook at one time ? EBrock Excel Discussion (Misc queries) 3 February 9th 05 05:45 AM
Removing links to other worksheets from within a workbook rjb Excel Discussion (Misc queries) 2 December 9th 04 08:04 AM


All times are GMT +1. The time now is 04:27 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017