ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Can I change line numer or column name (https://www.excelbanter.com/excel-discussion-misc-queries/53141-can-i-change-line-numer-column-name.html)

Dave Bonneville

Can I change line numer or column name
 
I'd like to change my line numbers to specific salespeople and column names
to specific months. Does anyone know if thats possible and how to do it?

Thanks

Paul B

Can I change line numer or column name
 
Dave, you can't change the ones in excel but you can put your own in row 1
and column A, then you can hide the row and column headers if you want,
tools options, view, uncheck row and column headers
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Dave Bonneville" <Dave wrote in
message ...
I'd like to change my line numbers to specific salespeople and column
names
to specific months. Does anyone know if thats possible and how to do it?

Thanks




Roger Govier

Can I change line numer or column name
 
Maybe, in addition to Paul's suggestion, put your cursor in cell C3 and
WindowsFreeze Panes to keep the column and row headers visible.

Regards

Roger Govier


Paul B wrote:
Dave, you can't change the ones in excel but you can put your own in row 1
and column A, then you can hide the row and column headers if you want,
tools options, view, uncheck row and column headers



All times are GMT +1. The time now is 03:48 PM.

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