Naming the columns

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm so new to computers. I've entered my data and sorted it. Now I need to label each column. Take out the A,B,C, etc. and give them names like Last Name, First Name, Teacher, Grade, etc
Can someone help me, please!
 
You can't.
Put your headings in the first row(s).

--
Regards;
Rob
------------------------------------------------------------------------
TheresA said:
I'm so new to computers. I've entered my data and sorted it. Now I
Click to expand...
need to label each column. Take out the A,B,C, etc. and give them names
like Last Name, First Name, Teacher, Grade, etc.
 
Hi TheresA!

I'm afraid you can't do that.

Just put your headings in Row 1

You can select A2 and use Windows > Freeze to make sure that your
headings stay there when you scroll down.

You could use:
Tools > Options > View
Remove check from "Row and Column headers"

But I would leave them there as they are useful when constructing
formulas.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
TheresA said:
I'm so new to computers. I've entered my data and sorted it. Now I
Click to expand...
need to label each column. Take out the A,B,C, etc. and give them
names like Last Name, First Name, Teacher, Grade, etc.
 
You do not rename your columns heading because they do not appear when you print. You name columns below the column heading as in, cell a1, b1,c1, your heading or discriptions go there or anywhere on the spreadsheet you want them to go.
 
Hi

Others have advised you about using row 1 (or several top rows alike) as
header row, and about freezing them. There is another feature you may find
usefull - named ranges.
To define the named range, select from menu Insert.Name.Define, enter the
name for range, and the range or formula returning the range like INDEX() or
OFFSET().

An simple example:
You define 2 named ranges
FirstNum=Sheet1!$A$2:$A$10
SecondNum=Sheet1!$B$2:$B$10
Now you can enter anywhere p.e. in 3rd row a formula
=FirstNum+SecondNum
and sum of numbers from A3 and B3 is returned. You can copy the formula into
range from row 2 to row 10, and formlas are adjusted for every row


--
(When sending e-mail, use address (e-mail address removed))
Arvi Laanemets


TheresA said:
I'm so new to computers. I've entered my data and sorted it. Now I need
Click to expand...
to label each column. Take out the A,B,C, etc. and give them names like
Last Name, First Name, Teacher, Grade, etc.
 
Back
Top