Blocking out cells not being used

J

Jim

I'm using Excel as part of Office 2000 premium and I have
a number of sheets that I use for data entry that are
cross-referenced to other sheets for a financial plan
merge doc. in Word. My question is, can I some how block
or lock or make invisible all the cells in the data entry
sheets so that all I see are the cells that I use?

Thanks for the help.
 
N

Nick Hodge

Jim

You cannot really hide cells only rows or columns, but if you select the
cells you do use (Ctrl+click) and then go to Format>Cells.>Protection and
uncheck 'Locked'. Now protect the rest of the worksheet
(Tools>Protection>Protect worksheet...). Pressing the Tab key will take you
only to the unlocked cells.

Makes data entry easier

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
 
J

Jim

Nick,
That's great help, thank you. But, I think I misphrased
my question and you hit on what I really want. Can I hide
columns and rows that I'm not using?

Thanks again.
 
N

Nick Hodge

Jim

Certainly (Before protecting sheet). Right click on any column or row header
and select 'Hide' or 'Unhide'. This is also available under the
Format>Column (or row) menu options. You can select multiple columns/rows
before taking the action to hide many.

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top