ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   How do I give a column a name in Excel? One would think this coul. (https://www.excelbanter.com/new-users-excel/4707-how-do-i-give-column-name-excel-one-would-think-coul.html)

astute1

How do I give a column a name in Excel? One would think this coul.
 
This should be easy to find in Excel Help but then again I guess we are
talking about MS here so all bets are off.

Frank Kabel

Hi
do you want to change the column heading (from A.....IV to something else)?.
If yes: not possible in Excel. You may use the first row as column header
and then use 'Windows - Freeze Panes' to always show this first row

--
Regards
Frank Kabel
Frankfurt, Germany

astute1 wrote:
This should be easy to find in Excel Help but then again I guess we
are talking about MS here so all bets are off.




Peo Sjoblom

Select the range/column and do insertnamedefine
Under name in help (excel 2000)

Regards,

Peo Sjoblom

"astute1" wrote:

This should be easy to find in Excel Help but then again I guess we are
talking about MS here so all bets are off.


JE McGimpsey

Select the column. Type the name in the Name box (at the left of the
formula bar). Press Enter.


In article ,
"astute1" wrote:

This should be easy to find in Excel Help but then again I guess we are
talking about MS here so all bets are off.



All times are GMT +1. The time now is 05:30 PM.

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