ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   How do I chage/eliminate the names of the columns and rows (https://www.excelbanter.com/charts-charting-excel/66879-how-do-i-chage-eliminate-names-columns-rows.html)

Diader

How do I chage/eliminate the names of the columns and rows
 
How do I chage/eliminate the names of the columns and rows

Bernard Liengme

How do I chage/eliminate the names of the columns and rows
 
If I understand you correctly:

To remove headers: Tools |Options; open View tab; look in lower Window
section and uncheck "Row & Column Headers"

The column headers can be changed to numbers (but then you must type
formulas differently) with Tools |Options; open General tab and check the
box "RC reference style"


You cannot give headers custom names
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Diader" wrote in message
...
How do I chage/eliminate the names of the columns and rows





All times are GMT +1. The time now is 08:59 PM.

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