Need to know how

[cgw]

Need to know how to lock text in an excel work sheet?
Like Name: Add: Phone:
Becasue when you type the name in the add and phone move
these are the type of things I need to lock in place so
that I can use the form over and over with out things
moving.

 

[Dave R.]

How about just using a column heading with name: and typing the names
underneath it?

 

[Norman Harker]

Hi cgw!

I think that what you want is Window > Freeze Panes

Select the row beneath your headings and this will retain the headings
as you continue to enter data.

--
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.

 

[cgw]

Sorry guys neither one worked. Text still moves thanks for
the help.