ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Losing my headers and footers when I copy the file (https://www.excelbanter.com/excel-discussion-misc-queries/2666-losing-my-headers-footers-when-i-copy-file.html)

StuThomson

Losing my headers and footers when I copy the file
 
When I copy an Excel file, the headers and footers are missing in the copy.
Is this a bug? Whats the fix?

IanRoy

Hello Stu,

Headers and footers are properties of each sheet. If you copied the file
(workbook) headers and footers would be copied also. If you copy a sheet (by
right-clicking a tab and choosing "Move or Copy") that info would likewise go
with it. If you are copying info from inside the sheet, even by selecting
all, the header/footer would not be copied.

Regards,

IanRoy

"StuThomson" wrote:

When I copy an Excel file, the headers and footers are missing in the copy.
Is this a bug? Whats the fix?



All times are GMT +1. The time now is 07:32 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com