How do I size a worksheet ? ( make smaller )

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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,
 
Select rows and columns you don't want to view and hide them.

To not see the row and column headers go to Tools>Options>View and uncheck row
and column headers.


Gord Dibben MS Excel MVP
 
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 Tools>Options>View Tab
and uncheck "Row & column headers".
 
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
 
After you completely finished your worksheet, go to TOOLS OPTIONS VIEW
Uncheck: "Gridlines" and " Row & column headings"... will that work okay
for you?
 
Back
Top