Hey Joe,
Sounds like you want a "named range"
Select a range, eg by clicking on the "A" to select the entire column
click in the box at the top left just above the grid where it says "A1"
Delete that and type Si
now you can use "Si" as your address
=B2*Si
will just work.
OR
Go for the "Insert" drop down menu, and select "Name..."
Then fill in the details.
This is all much the same as Excel. Google "named ranges" to find out
all the details.
All the best,
Hal
On 6/Aug/11 2:19 AM, Joseph Boesenberg wrote:
Hi,
Can anyone tell how (if possible) I can change the physical column
names (A, B, C) in Gnumeric so that when I write equations I can use
the actual label instead of the default column name (which is really
annoying and one of the reasons I don't like Excel). A 20 year old
program I had called Axum could do this, but it is a 16 bit program.
I work with chemical data and it would be nice to be able to use the
actual chemical element symbols (Si, Al, Fe) instead of the column labels.
Thanks.
Joe
_______________________________________________
gnumeric-list mailing list
gnumeric-list@gnome.org
http://mail.gnome.org/mailman/listinfo/gnumeric-list
_______________________________________________
gnumeric-list mailing list
gnumeric-list@gnome.org
http://mail.gnome.org/mailman/listinfo/gnumeric-list
