If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)

Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

Excel Question

Pigman · 2002-12-01 11:17:17

Is there any way in EXCEL to change the titles of the columns from the default 'A' , 'B' , 'C' etc to more meaningful titles?

01-12-2002 12:17pm

#1

Pigman

Closed Accounts Posts: 1,092 ✭✭✭

Join Date: April 2002

Posts: 953

Is there any way in EXCEL to change the titles of the columns from the default 'A' , 'B' , 'C' etc to more meaningful titles?

0

Comments

#2 02-12-2002 6:51pm

GUI

Registered Users, Registered Users 2 Posts: 1,237 ✭✭✭

Join Date: July 2000

Posts: 1093

not that im aware of..
cause u can name cells whatever u want

would that do for u?
just highlight a cell
and in the toolbar where it says
A2(A2 been the selected cell)
delete that text and name it something more meaningful

0
#3 02-12-2002 7:24pm

Mercury_Tilt

Closed Accounts Posts: 5,500 ✭✭✭

Join Date: December 2000

Posts: 5273

This post has been deleted.

0
#4 02-12-2002 7:25pm

Kali

Closed Accounts Posts: 6,601 ✭✭✭

Join Date: February 1998

Posts: 6297

It's a spreadsheet not a database

0
#5 02-12-2002 7:34pm

Victor

Registered Users, Registered Users 2 Posts: 78,511 ✭✭✭✭

Join Date: December 2000

Posts: 68873

I think it is bad policy to rename columns (you can do it in Corel Quattro Pro). It is much better to use row 1 for a title and if it is a large spreadsheet, then use Window > Freeze Pane (this can be used in both directions).

However, there appears to be a "Names in workbook" function in Excel, where you say "Price" = cell "A21" or something similar.

0
#6 04-12-2002 6:51pm

Mercury_Tilt

Closed Accounts Posts: 5,500 ✭✭✭

Join Date: December 2000

Posts: 5273

This post has been deleted.

0
Advertisement