Thread: Arrange Footer
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
OssieMac OssieMac is offline
external usenet poster
 
Posts: 2,510
Default Arrange Footer

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.