![]() |
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 |
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