<div>
File-&gt;Page Setup. Goto the Header/Footers tab.
</div>


File->Page Setup. Goto the Header/Footers tab.

<div>
In my original Q I was asking how to put the same H&amp;F ON ALL of the Worksheets in one Workbook in one go.<br />
<br />
Your answer doesn't give a solution to this at all!
</div>


In my original Q I was asking how to put the same H&F ON ALL of the Worksheets in one Workbook in one go.

Your answer doesn't give a solution to this at all!

<div>
You can just select all of the worksheets by click on the first, holding shift and clicking on the last. Then you goto File-&gt;page setup
</div>


You can just select all of the worksheets by click on the first, holding shift and clicking on the last. Then you goto File->page setup

<div>
Sorry I misunderstood the first time but hope the second is what you were looking for.
</div>


Sorry I misunderstood the first time but hope the second is what you were looking for.

<div>
BTW, when I say click on the first page and then the last, I mean the bottom tab of each page.
</div>


BTW, when I say click on the first page and then the last, I mean the bottom tab of each page.

<div>
<div class="content wysiwyg-content">
I know that there is a way to put in one go the same H&amp;F on all the sheets in one Excel Workbook. &nbsp;i read it somewhere but I can not recall where.<br />
<br />
Please can you help?
</div>
</div>


I know that there is a way to put in one go the same H&F on all the sheets in one Excel Workbook.  i read it somewhere but I can not recall where.

Please can you help?

Headers and Footers in Excel

Hardware includes cell phones and other digital living devices, tablets, computers, servers, peripherals and components, printers and scanners, gaming consoles, networking hardware such as routers, hubs, switches and modems, storage devices and security equipment such as firewalls and other appliances.