How to name a column?

Question

Level 1

0 points

How to name a column?

How do i *name the columns* in numbers? eg currently they are just a, b, c, d, e, etc and i want them to be reciepts, content, blah blah, etc

Can someone please help? Thanks in advance^^

Posted on Jan 17, 2010 10:32 PM

Reply

Answer 1

KOENIG Yvan

Level 8

41,807 points

Jan 17, 2010 11:07 PM in response to Axelay

Welcome to the club.

Every user may download from the Help menu the PDF "Numbers User Guide" and the PDF named "iWork Formulas and Functions User Guide".

These resources give the wanted responce :

When you type a cell reference that includes the name of a header cell (all applications), table (Numbers only), or sheet (Numbers only), after typing 3 characters a list of suggestions pops up if the characters you typed match one or more names in your spreadsheet. You can select from the list or continue typing. To disable name suggestions in Numbers, choose Numbers > Preferences and deselect “Use header cell names as references” in the General pane.

Yvan KOENIG (VALLAURIS, France) lundi 18 janvier 2010 08:07:24

Reply

Answer 2

Axelay Author

Level 1

0 points

Jan 18, 2010 12:17 AM in response to KOENIG Yvan

Hi again, thanks for attempting to help and i have downloaded the pdf's u mentioned but i am still havent figured it out.

The problem is i dont even understand what you mean by "when u type a cell reference that includes the name of a header cell"

I have a spreadsheet open in numbers that im entering information from reciepts in and at the moment the collumns look a little like this:
|---A---|-----B---|----C----|----D---|---E----|
|-------|---------|---------|--------|--------|
|-------|---------|---------|--------|--------|
|-------|---------|---------|--------|--------|
|-------|---------|---------|--------|--------|
|-------|---------|---------|--------|--------|
|-------|---------|---------|--------|--------|

I want it to look a little like this:

|-NAME-|--BLAH---|--DATE---|--BLAH--|--ETC---|
|-------|---------|---------|--------|--------|
|-------|---------|---------|--------|--------|
|-------|---------|---------|--------|--------|
|-------|---------|---------|--------|--------|
|-------|---------|---------|--------|--------|
|-------|---------|---------|--------|--------|

I already have entered the information in all of the cells beneath so i dont want to have to start the entire doc from scratch, surely there is some way to rename the columns?

Message was edited by: Axelay

Reply

Answer 3

KOENIG Yvan

Level 8

41,807 points

Jan 18, 2010 3:14 AM in response to Axelay

If you download the User Guides but don't read them carefully, the result is the same.

I took time to extract the meaningful lines :

*To disable name suggestions in Numbers, choose Numbers > Preferences and deselect “Use header cell names as references” in the General pane.*

It's difficult to help someone which doesn't read carefully what we write.

You remind me this sentence :

*you can lead a horse to water but you can't make him drink*

Yvan KOENIG (VALLAURIS, France) lundi 18 janvier 2010 12:14:29

Reply

Answer 4

Badunit

Level 7

25,610 points

Jan 18, 2010 6:52 AM in response to Axelay

When you have the table selected you will always have the ABC's across the top and numbers down the left side. There is no way to disable that, it is core to the application to be able to reference cells by a column letter and row number. When you click off of the table, these letters and numbers don't show. If you want to give your columns names, type the names in a header row. The names you type in a header row will be there even when the table is not selected.

With "use header cell names as references" checked, if a cell has a name in the header row and a name in the header column, the cell can be referenced by those names instead of a letter-number combination.

Reply

Answer 5

nafs

Level 1

8 points

Jan 19, 2010 3:29 AM in response to Badunit

I have found out the hard way to disable "use header names as references".

Sometimes it just doesn't work, e.g. when you have periods in the header names.

Reply

Answer 6

KOENIG Yvan

Level 8

41,807 points

Jan 19, 2010 3:38 AM in response to nafs

Surprising.

Here, it behaves flawlessly.

Yvan KOENIG (VALLAURIS, France) mardi 19 janvier 2010 12:38:00

Reply

Answer 7

jacuzzi

Level 1

0 points

Jan 20, 2010 2:19 PM in response to Axelay

I am creating a very long of 110 rows and counting with 9 columns. The problem is, that when I scroll down to, say, row 40 I am not able to see my column headers any longer. This is obviously frustrating when I have to keep scrolling back up to check which category I am looking at.
I understand that you cannot rename the program's headers (A, B, C, D, etc).

So the question is, is there anyway have my column headers scroll with me (the way that the program's column labels do)? If this isn't possible, is there another way to get around this problem?

Thanks!
Jacqueline

Reply

Answer 8

Badunit

Level 7

25,610 points

Jan 20, 2010 2:26 PM in response to jacuzzi

Go to the menu item Table/Freeze Header Rows

Reply

Answer 9

jacuzzi

Level 1

0 points

Jan 20, 2010 2:34 PM in response to Badunit

Genius! Thank you.

Reply

Answer 10

KOENIG Yvan

Level 8

41,807 points

Jan 20, 2010 10:11 PM in response to jacuzzi

Do you know that every user may download well done User Guides thru the Help menu ?

*Numbers User Guide* and *iWork Formulas and Functions User Guide* respond to questions like yours.

Yvan KOENIG (VALLAURIS, France) jeudi 21 janvier 2010 07:11:44

Reply