Blocking out cells not being used

  • Thread starter Thread starter Jim
  • Start date Start date
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.
 
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)
 
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.
 
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)
 
Back
Top