ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Can we have custom Column headers instead of default (https://www.excelbanter.com/excel-worksheet-functions/44255-can-we-have-custom-column-headers-instead-default.html)

Srini

Can we have custom Column headers instead of default
 
Can we set the column names to what we want in an
Excel Spreadsheet rather than that default A, B, C... ??

Also can we either hide or delete Sheet names appearing
at the bottom of the sheet??

Thanks for the help
Srini

Dave Peterson

You can change the column headers to numbers (1, 2, 3,..., 255) or you can hide
them.

But you can't change them to something else.

But you could put your headers in Row 1 and
then select A2
and windows|freeze panes

so that row 1 is always visible.

And you can delete the whole worksheet by rightclicking on the worksheet tab and
choosing delete--you'll lose the data on that sheet, too.

You can hide all the worksheet tabs if you want.

Tools|Options|view tab
is where you'd hide the sheet tabs and row/column headers.

(Ctrl-pgup, ctrl-pgdn will swap between worksheets--nice if you've hidden the
tabs.)

Srini wrote:

Can we set the column names to what we want in an
Excel Spreadsheet rather than that default A, B, C... ??

Also can we either hide or delete Sheet names appearing
at the bottom of the sheet??

Thanks for the help
Srini


--

Dave Peterson


All times are GMT +1. The time now is 10:29 PM.

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