G
Guest
How do I designate an entry as the column head/label/name vs. data entry?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
C
Chip Pearson
In what context?
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
G
Guest
I am creating an elementary spreadsheet, and I want to place headings at the
top of each column.
top of each column.
J
JulieD
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.
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.
G
Guest
Thanx . . . I did it.
JulieD said: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
J