ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   how do make a row non numbered? (https://www.excelbanter.com/new-users-excel/73729-how-do-make-row-non-numbered.html)

Removing number value from a row

how do make a row non numbered?
 
Trying to make a row not have a numbered value on the left side.

Ron Coderre

how do make a row non numbered?
 
I don't know where you're goinng with this, but....

Those numbers are used for reference purposes by excel.

If you'd like to display something different, maybe this will work for you:
Use Col_A to display the "row numbers" you'd prefer.
Then, Tools|Options|View tab|Uncheck: Row & Column Headers

If you need to display the Column Headers, you'll could put them in Row_1.

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"Removing number value from a row" wrote:

Trying to make a row not have a numbered value on the left side.


Sloth

how do make a row non numbered?
 
Tools-Options-View-"Row & column headers"

You can only hide the numbers, you can't remove them.



"Removing number value from a row" wrote:

Trying to make a row not have a numbered value on the left side.



All times are GMT +1. The time now is 11:13 AM.

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