How do I designate an entry as the column head/label/name vs. data entry?

In what context?


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"4most" wrote in message
...
How do I designate an entry as the column head/label/name vs.
data entry?

I am creating an elementary spreadsheet, and I want to place headings at the
top of each column.

"Chip Pearson" wrote:

In what context?


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"4most" wrote in message
...
How do I designate an entry as the column head/label/name vs.
data entry?

Hi

generally, you just type them in the first row and format them differently
from your data, if you want them visible when you scroll down the worksheet
click in cell A2 and choose window / freeze panes.

you could select the whole worksheet, choose format / cell - go to the
protection tab and untick locked, then select the first row (after you've
typed your headings), choose format / cell - protection tab, tick locked and
then choose tools / protection / protect sheet - to stop people changing
this row of headings, but personally i would think this was a bit of
overkill.

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"4most" wrote in message
...
I am creating an elementary spreadsheet, and I want to place headings at
the
top of each column.

"Chip Pearson" wrote:

In what context?


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"4most" wrote in message
...
How do I designate an entry as the column head/label/name vs.
data entry?

Thanx . . . I did it.

"JulieD" wrote:

Hi

generally, you just type them in the first row and format them differently
from your data, if you want them visible when you scroll down the worksheet
click in cell A2 and choose window / freeze panes.

you could select the whole worksheet, choose format / cell - go to the
protection tab and untick locked, then select the first row (after you've
typed your headings), choose format / cell - protection tab, tick locked and
then choose tools / protection / protect sheet - to stop people changing
this row of headings, but personally i would think this was a bit of
overkill.

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"4most" wrote in message
...
I am creating an elementary spreadsheet, and I want to place headings at
the
top of each column.

"Chip Pearson" wrote:

In what context?


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"4most" wrote in message
...
How do I designate an entry as the column head/label/name vs.
data entry?

you're welcome

--
Cheers
JulieD

"4most" wrote in message
...
Thanx . . . I did it.

"JulieD" wrote:

Hi

generally, you just type them in the first row and format them
differently
from your data, if you want them visible when you scroll down the
worksheet
click in cell A2 and choose window / freeze panes.

you could select the whole worksheet, choose format / cell - go to the
protection tab and untick locked, then select the first row (after you've
typed your headings), choose format / cell - protection tab, tick locked
and
then choose tools / protection / protect sheet - to stop people changing
this row of headings, but personally i would think this was a bit of
overkill.

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"4most" wrote in message
...
I am creating an elementary spreadsheet, and I want to place headings at
the
top of each column.

"Chip Pearson" wrote:

In what context?


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"4most" wrote in message
...
How do I designate an entry as the column head/label/name vs.
data entry?