Quick question on sheet format

  • Thread starter Thread starter Del
  • Start date Start date
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
 
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.
 
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.
 
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...
 
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
 
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.
 
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
 
Back
Top