How do I size a worksheet ? ( make smaller )
 

Hi,

I made a sheet that has a few simple calculators on it, and I would like to
limit the size of the excel sheet to only what needs to be viewed, say 20
columns and twenty rows.I would also like to be able to get rid of the column
and row numbers and letters. Any help will be appreciated, I realize these
may be simple tasks but I can't find the answers anywhere.

Thnak You,

How do I size a worksheet ? ( make smaller )
 

Select rows and columns you don't want to view and hide them.

To not see the row and column headers go to ToolsOptionsView and uncheck row
and column headers.


Gord Dibben MS Excel MVP

On Thu, 31 May 2007 09:55:00 -0700, MartyH
wrote:

Hi,

I made a sheet that has a few simple calculators on it, and I would like to
limit the size of the excel sheet to only what needs to be viewed, say 20
columns and twenty rows.I would also like to be able to get rid of the column
and row numbers and letters. Any help will be appreciated, I realize these
may be simple tasks but I can't find the answers anywhere.

Thnak You,

How do I size a worksheet ? ( make smaller )
 

To hide a column or row, highlight the letter or number header, right
click and choose "hide".

To hide the header letters and numbers go to ToolsOptionsView Tab
and uncheck "Row & column headers".

How do I size a worksheet ? ( make smaller )
 

Tools....options.....then uncheck ro and column headings.

If you want to make the sheet look cleaner, after hiding the data you don't
want you could put borders around the cells you want to see and then
tools...options...remove gridlines

"MartyH" wrote:

Hi,

I made a sheet that has a few simple calculators on it, and I would like to
limit the size of the excel sheet to only what needs to be viewed, say 20
columns and twenty rows.I would also like to be able to get rid of the column
and row numbers and letters. Any help will be appreciated, I realize these
may be simple tasks but I can't find the answers anywhere.

Thnak You,

How do I size a worksheet ? ( make smaller )
 

After you completely finished your worksheet, go to TOOLS OPTIONS VIEW
Uncheck: "Gridlines" and " Row & column headings"... will that work okay
for you?

"MartyH" wrote:

Hi,

I made a sheet that has a few simple calculators on it, and I would like to
limit the size of the excel sheet to only what needs to be viewed, say 20
columns and twenty rows.I would also like to be able to get rid of the column
and row numbers and letters. Any help will be appreciated, I realize these
may be simple tasks but I can't find the answers anywhere.

Thnak You,

How do I size a worksheet ? ( make smaller )
 

Thank you everyone, great advice! I appreciate it very much.