ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)
-   -   column headings on page bottom (https://www.excelbanter.com/setting-up-configuration-excel/84543-column-headings-page-bottom.html)

Trebc

column headings on page bottom
 
I would like to print my worksheets so that the column letters appear on the
top of the page and again on the bottom of my page so when I am viewing a
hard copy I know what data belongs in the specific lettered column. I have
looked in footers and print options. Can this be done? I appreciate any help!

Pete_UK

column headings on page bottom
 
You could insert a row at the top of your spreadsheet and put "A", "B",
"C" etc in the columns. Then in File | Page Setup | Sheet (tab) you can
identify row(s) which you want to repeat at the top of each printed
page. There is not an option to repeat these at the bottom of each
page.

However, printing the gridlines, or just putting borders around each
column would help you to line the columns up more easily.

Hope this helps.

Pete


Dave Peterson

column headings on page bottom
 
On that same tab (File|Page Setup|Sheet tab), there's an option to print both
row and column headings. This won't print the column headings at the bottom
(column Footers???), but might be easier than populating an extra row.

Pete_UK wrote:

You could insert a row at the top of your spreadsheet and put "A", "B",
"C" etc in the columns. Then in File | Page Setup | Sheet (tab) you can
identify row(s) which you want to repeat at the top of each printed
page. There is not an option to repeat these at the bottom of each
page.

However, printing the gridlines, or just putting borders around each
column would help you to line the columns up more easily.

Hope this helps.

Pete


--

Dave Peterson


All times are GMT +1. The time now is 08:59 PM.

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