ExcelBanter - Footer in Excel

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Footer in Excel (https://www.excelbanter.com/excel-worksheet-functions/71660-footer-excel.html)

Carol

Footer in Excel

How do you copy a footer from one worksheet to another. I don't want to have
to re-type the footer on each page.

Dave Peterson

Footer in Excel

Group the sheets you want to have the same footer.
click on the first worksheet tab.
ctrl-click on the subsequent.

Change the footer

Ungroup the sheets (rightclick on any and choose ungroup sheets)

Carol wrote:

How do you copy a footer from one worksheet to another. I don't want to have
to re-type the footer on each page.

--

Dave Peterson

Carol

Footer in Excel

Wonderful, it worked. Thank you so much for your help.

"Dave Peterson" wrote:

Group the sheets you want to have the same footer.
click on the first worksheet tab.
ctrl-click on the subsequent.

Change the footer

Ungroup the sheets (rightclick on any and choose ungroup sheets)

Carol wrote:

How do you copy a footer from one worksheet to another. I don't want to have
to re-type the footer on each page.

--

Dave Peterson

All times are GMT +1. The time now is 07:05 PM.