Makeing a Spreadsheet

D

Dottie

I want to Put Titles on Top of the columns, but I don't want it to be showing
as column one, I want my input to be numbered starting at number 1
 
Z

Zygan

you cant change the column headers however put the names of your columns
in the top cell and put the numbers 1 - 2 - 3 etc down the side goto
TOOLS > OPTIONS > VIEW (TAB) > ROW AND COLUMN HEADERS (uncheck the box)
 
E

Elkar

Your Column Titles are going to have to occupy at least 1 Row. However, if
you want to see row numbers for your data, then use Column A and enter this
formula:

=ROW()-1

Copy this down as many rows as you need for your data.

HTH,
Elkar
 
Top