Prev: stop view and lock columns
Next: Is there a formlula to replace cell shade color with another color
From: MAX on 8 Feb 2010 17:32
I have a file with 31 sheets and every sheet has a footer ABC 6/1. How can I
arrange this footer in all sheets to ABC 6/0.

Thanks in advance.
From: OssieMac on 8 Feb 2010 17:47
Hi Max,

Select all sheets. To do this, select the first sheet then hold the Shift
key down and select the last sheet.
Note: Selecting the first sheet and holding Shift before clicking another
sheet selects all sheets in between. Holding Ctrl key, you can individually
select additional sheets.

Open Page Setup and edit the footer and it will apply to all selected sheets.



--
Regards,

OssieMac


"MAX" wrote:

> I have a file with 31 sheets and every sheet has a footer ABC 6/1. How can I
> arrange this footer in all sheets to ABC 6/0.
>
> Thanks in advance.
From: Gord Dibben on 8 Feb 2010 18:56
Please note that grouping the sheets will change most elements of the page
setup to that of first sheet selected.

Print Range and Rows to Repeat are exceptions.

So...........if you have custom margins or such that you don't want to
change...........don't group the sheets.

You may want a macro that changes the footer only.

Sub Change_Footer()
Dim wkSht As Worksheet
For Each wkSht In ThisWorkbook.Worksheets
wkSht.PageSetup.RightFooter = "ABC 6/0"
Next wkSht
End Sub



Gord Dibben MS Excel MVP

On Mon, 8 Feb 2010 14:32:09 -0800, MAX <MAX(a)discussions.microsoft.com>
wrote:

>I have a file with 31 sheets and every sheet has a footer ABC 6/1. How can I
>arrange this footer in all sheets to ABC 6/0.
>
>Thanks in advance.

 | 
Pages: 1
Prev: stop view and lock columns
Next: Is there a formlula to replace cell shade color with another color