ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   NAMING THE COLUMNS AND ROWS OF A WORKSHEET? (https://www.excelbanter.com/excel-discussion-misc-queries/95842-naming-columns-rows-worksheet.html)

Api

NAMING THE COLUMNS AND ROWS OF A WORKSHEET?
 
I know that it is possible to name columns.
How do I name columns in a worksheet?


Bob Phillips

NAMING THE COLUMNS AND ROWS OF A WORKSHEET?
 
select the column, InsertNameDefine...

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Api" wrote in message
...
I know that it is possible to name columns.
How do I name columns in a worksheet?




Gord Dibben

NAMING THE COLUMNS AND ROWS OF A WORKSHEET?
 
If you mean change the A, B, C to something else, this cannot be done.

You can place titles in row 1 and through ToolsOptionsView, remove the row and
column headers.


Gord Dibben MS Excel MVP

On Sat, 24 Jun 2006 01:21:02 -0700, Api wrote:

I know that it is possible to name columns.
How do I name columns in a worksheet?




All times are GMT +1. The time now is 12:31 AM.

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