grinds

C

CW

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
 
J

JMB

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.
 
R

RWN

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!
 
Top