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