How to make only the cells i need active

D

debs1389

I have always seen this on spreadsheets (making only cells in us
active), the cells in active are normally grey. I need your help
Thanks

Debbie:confused

--
debs138

I am a past student of University of Technology Jamaica, majored i
Production. One of my favourite program in Microsoft is excel and I a
willing to learn anything about it
 
A

Ardus Petus

Select unwanted Columns
Format>Column>Hide

Select unwanted Rows
Format>Row>Hide

HTH
 
D

debs1389

I don't want to hide columns or row, i want to make the cells becom
inactive. You cant click or anything and the area becomes grey.

Thanks for your reply thoug

--
debs138

I am a past student of University of Technology Jamaica, majored i
Production. One of my favourite program in Microsoft is excel and I a
willing to learn anything about it
 
H

HEK

Do you mean with "making inactive" that users cannot click/change the cells,
i.e. protecting them? If so, lock cells in Format / Cells/ Protection Tab
and if you later protect yr worksheet (Tools/Protection/Protect sheet...) the
locked cells cannot be changed until you unprotect the sheet. Note: cells
are locked by default and usually the trick is to UNLOCK the ones that may be
changed by the user.
GL,
Henk
 
Top