Hide rows of data

[lastingimprint02]

I have an excel spreadsheet where there is some data I don't want others to see when I share it b/c it will confuse them. How can I hide rows from view?

 

[pedie]

I have an excel spreadsheet where there is some data I don't want others to see when I share it b/c it will confuse them. How can I hide rows from view?

select the whole row by clicking on header side bar then right click and click on hide.

Or click anywhere on the cell for the row to hide and hit
ctrl + (

to unhide again latter select area where hiddin rows are located and hit
ctrl + shift + (

 

[hutchisd]

Highlight the entire row and click hide or filter the list using autofilter.

 

[Rasm]

ActiveSheet.Range(Rangeval).EntireRow.Hidden = True