Quick question on sheet format

D

Del

I want to confine a sheet in my workbook to just one page. Basically, when
the workbook is opened, it is a coversheet of sorts, and I only want it to be
one page. How do I "remove" all of the columns and rows that I don't want
seen? (Not "hide", but rather there is my information in the white area, and
then there is all the grey space that isn't going to be used around it.)

I've seen it done, but can't recall how to do it.

Excel 2007
 
S

Sean Timmons

Sounds like you are in Page Break View? Go to View > Normal.

Also, for what may be a sharper look, go to Tools > Options > Remove
Gridlines.
 
D

Del

I'm in normal view and gridlines are not a problem. Imagine taking to
borders of the sheet and bringing them to the edge of an 8.5x11 view. It's
literally like shrinking a worksheet down to just one page - even if it's
just visually.
 
S

Sean Timmons

So, Print Preview, Fit to 1 page by 1 page? or are you looking to merely zoom
it for view? Use the Zoom drop-down to select the magnification...
 
O

Otto Moehrbach

What you describe is the simple hiding of all rows and columns outside of
your "page" area. Why do you say you don't want to "hide"? HTH Otto
 
D

Del

Well, I'm assuming that there is an easier way to "hide" all of these rows
and columns without having to select several thousand of them and select
"hide." That is what I'm looking for.
 
O

Otto Moehrbach

Del
Say your "page" that you want visible is A1:F50. Click on row number
51. The row number itself, not a cell in that row. Now do Shift-Ctrl-Down
Arrow. This selects all the rows from 51 down. Click on Format-Row-Hide.
Now click on the column letter G. Do Shift-Ctrl-right arrow. Click on
Format-Column-Hide. Done. HTH Otto
 
Top