Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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, |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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, |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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". |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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, |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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, |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I size a worksheet ? ( make smaller )
Thank you everyone, great advice! I appreciate it very much. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Font size smaller and bigger in a formula | Excel Worksheet Functions | |||
How to split worksheet to make smaller | Excel Worksheet Functions | |||
My tabs' font size is smaller - how do I restore default size? | Excel Discussion (Misc queries) | |||
How do I break a csv file into smaller size for export? | New Users to Excel | |||
Make Values Smaller Q | Excel Worksheet Functions |