ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to change text in first row or first column? (https://www.excelbanter.com/excel-discussion-misc-queries/93818-how-change-text-first-row-first-column.html)

wwwrabbit

How to change text in first row or first column?
 

How to change text in first row or first column?
I don't like excel default style to show first fixed row as A, B, C...
and first column as 1, 2, 3... :mad:
How can I change them or hide them? I have seen a sample of that, but
don't know how to realize it. :confused:


--
wwwrabbit
------------------------------------------------------------------------
wwwrabbit's Profile: http://www.excelforum.com/member.php...o&userid=35397
View this thread: http://www.excelforum.com/showthread...hreadid=551701


Ron Coderre

How to change text in first row or first column?
 

Here's how to hide them

From the Excel Main Menu
<tools<options<view tab
UN-check: Row & Column Headers

Is that what you're looking for?

Regards,
Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=551701


Don Guillett

How to change text in first row or first column?
 
cant change
toolsoptionsviewrow & column

--
Don Guillett
SalesAid Software

"wwwrabbit" wrote
in message ...

How to change text in first row or first column?
I don't like excel default style to show first fixed row as A, B, C...
and first column as 1, 2, 3... :mad:
How can I change them or hide them? I have seen a sample of that, but
don't know how to realize it. :confused:


--
wwwrabbit
------------------------------------------------------------------------
wwwrabbit's Profile:
http://www.excelforum.com/member.php...o&userid=35397
View this thread: http://www.excelforum.com/showthread...hreadid=551701




wwwrabbit

How to change text in first row or first column?
 

Is there a way to chang them? instead of hide them?:)


Ron Coderre Wrote:
Here's how to hide them

From the Excel Main Menu
<tools<options<view tab
UN-check: Row & Column Headers

Is that what you're looking for?

Regards,
Ron



--
wwwrabbit
------------------------------------------------------------------------
wwwrabbit's Profile: http://www.excelforum.com/member.php...o&userid=35397
View this thread: http://www.excelforum.com/showthread...hreadid=551701


Dave Peterson

How to change text in first row or first column?
 
You can use letters or numbers for the column headings--or you can hide them.

But you can't change them.

You can hide them and use row 1 for your own headers--if it's really important
to you.

wwwrabbit wrote:

How to change text in first row or first column?
I don't like excel default style to show first fixed row as A, B, C...
and first column as 1, 2, 3... :mad:
How can I change them or hide them? I have seen a sample of that, but
don't know how to realize it. :confused:

--
wwwrabbit
------------------------------------------------------------------------
wwwrabbit's Profile: http://www.excelforum.com/member.php...o&userid=35397
View this thread: http://www.excelforum.com/showthread...hreadid=551701


--

Dave Peterson


All times are GMT +1. The time now is 05:36 AM.

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