ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Headings and Row Numbering (https://www.excelbanter.com/excel-discussion-misc-queries/101668-headings-row-numbering.html)

billykiller05

Headings and Row Numbering
 

Is there any way to chane the Column Headings from A, B, C,... to a name
or is there a way to change the Row numbering to begin with zero?


--
billykiller05
------------------------------------------------------------------------
billykiller05's Profile: http://www.excelforum.com/member.php...o&userid=36813
View this thread: http://www.excelforum.com/showthread...hreadid=565640



Headings and Row Numbering
 
Hi Billy

AFAIK there is no way to change them. You could set up your own, hide the
existing (from Tools/Options/View tab) and use Window/Freeze Panes so that
they appear to be built-in.

Andy.

"billykiller05"
wrote in message
news:billykiller05.2bm0zf_1154013605.5923@excelfor um-nospam.com...

Is there any way to chane the Column Headings from A, B, C,... to a name
or is there a way to change the Row numbering to begin with zero?


--
billykiller05
------------------------------------------------------------------------
billykiller05's Profile:
http://www.excelforum.com/member.php...o&userid=36813
View this thread: http://www.excelforum.com/showthread...hreadid=565640




Dave Peterson

Headings and Row Numbering
 
Nope.

You can see numbers or letters or nothing.

But you can put all your header information in row 1 and then with A1 visible,
select A2 and window|Freeze panes so that row 1 is always visible.



billykiller05 wrote:

Is there any way to chane the Column Headings from A, B, C,... to a name
or is there a way to change the Row numbering to begin with zero?

--
billykiller05
------------------------------------------------------------------------
billykiller05's Profile: http://www.excelforum.com/member.php...o&userid=36813
View this thread: http://www.excelforum.com/showthread...hreadid=565640


--

Dave Peterson


All times are GMT +1. The time now is 02:28 AM.

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