grinds
 

How do I get rid of the grides (A, B,C... and 1,2,3...) in excel. How do I
set the spread sheet to a certain size for example if I wanted it to go from
A-J and 1-50 only

grinds
 

Tools/Options/View - Uncheck Row and Column Headers. Also, can uncheck
gridlines if desired.

Second Question - the easiest way is to hide the rows/columns you don't
want. Alternatively, you can set the ScrollArea of the worksheet, but it
always seems to reset on me every time the workbook is saved and reopened
later - so this solution would likely require some VBA to set the ScrollArea
every time the workbook is opened.




"CW" wrote:

How do I get rid of the grides (A, B,C... and 1,2,3...) in excel. How do I
set the spread sheet to a certain size for example if I wanted it to go from
A-J and 1-50 only

grinds
 

xl2k
"Tools-Options-View" - Window Options - Uncheck "Row and Column Headers".

I don't believe you can set the size-(don't know why you'd want to)-but I've been wrong
before!

--
Regards;
Rob
------------------------------------------------------------------------
"CW" wrote in message
...
How do I get rid of the grides (A, B,C... and 1,2,3...) in excel. How do I
set the spread sheet to a certain size for example if I wanted it to go from
A-J and 1-50 only