View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Suleman Peerzade[_2_] Suleman Peerzade[_2_] is offline
external usenet poster
 
Posts: 189
Default How do I change the size of a worksheet?

Hi,

The standard sized of excel is, columns from A to IV and there are 65536
rows by default.

You cannot alter them, you can probably set your worksheet to see as much as
you want.
Tools/Options/View/Uncheck gridline boxes the entire worksheet will hide the
gridlines and then you can select the number of rows and columns and in the
menubar highlight them with gridlines.

This will help you to see rows and columns that you have highlighted.

Excel 2003
--
Thanks
Suleman Peerzade


"Bamini" wrote:

I want to set the size of a worksheet to 20 rows and 10 columns. How do I do
this? Every time the sheet is opened, only these cells should be displayed.

I hope there is an option to set different sizes for different worksheets
within the same workbook.

Regards
Bamini