Showing only your work (no blank cells)

Posted by jason on October 12, 2001 6:02 AM

Does anyone know how to show only the cells that your have formatted? I would like to get rid of all the empty cells and the column headers if possible.

Thanks.
Jason

Posted by Dan on October 12, 2001 7:45 AM

Not sure what you mean by showing only formatted cells, but to get rid of column headers go to Tools->Options. On the View Tab uncheck Rows/Column Headers.

Posted by Josef Bozsik on October 13, 2001 1:18 PM

Select the rows you want to hide and go to Format>Row>Hide.
Do the same for the columns you want to hide.