Sorry to bother you on a lame question. I created a work book in excel and
have rows & colums left over showing on the screen area. I want to fit the
excel document to the screen so their is no blank rows & colums showing can
this be done? . I have looked in Help but can't seem to find how to do this.
--
Thank-you and Happy Holidays
Carl R

Carl

Select the rows you don't want to see and FormatRowsHide

Same for columns.

Manipulate row heights and column widths of the remaining rows and columns so
the visible area uses the window viewing area if that's what you want to see.


Gord Dibben MS Excel MVP


On Sun, 17 Dec 2006 12:11:00 -0800, Carl R wrote:

Sorry to bother you on a lame question. I created a work book in excel and
have rows & colums left over showing on the screen area. I want to fit the
excel document to the screen so their is no blank rows & colums showing can
this be done? . I have looked in Help but can't seem to find how to do this.

Couple more options.

You can turn off gridlines by going to ToolsOptionsView and
unchecking 'gridlines'.

Or you can select the offending cells and set their fill colour to
white or whatever colour you like which will hide the gridlines.

HTH
Martin

You can choose the size of the screen view by selecting select Zoom... from
the View menu.
There is also a drop down menu button on the toolbar, which can also do the
same thing.