How do you gray out the remander of the sheet

[lilhotch14]

I want to gray out or delete the rest of a sheet that im not using, so that it wont scroll down past the end of the info i have in and so that it wont show the extra cells. how do i do this?

i would like to do it on columns and rows

 

[Derek]

Hi there

Select all the rows you wish "greyed out" and hide them (Format/Rows/Hide). Do the same with the columns.

regards
Derek