On my excel 2007 spreadsheets iam getting numbers for my columns headings instead of letters which is very confusing when using formulas why is this happening ?
The most likely problem is that you (or somebody) has R1C1 reference style turned on.
In the TOOLS menu, choose OPTIONS and switch to the GENERAL tab. Look for the checkbox labeled R1C1 reference style. If it is checked, this will cause your symptoms.
Just uncheck the box and click OK.
I'm not sure what happens to existing formulas. If you (or somebody) has written formulas that rely on the R1C1 style, I don't know if they automatically get updated to the regular style or not, but that should be easy to discover.
Start off by doing one of the following: Select the range of cells that you want to make into a table within your worksheet then proceed to Step 2 OR Start immediately with Step 2.
Click on the "Insert" tab at the top of the document.
Find the "Tables" group, then click on "Table." The "Create Table" dialog box will appear.
Type in a range for your table if you did not select a range in Step 1. If you did already select a range then that range will automatically appear in the dialog box.
Check the "My Table Has Headers" box if the data set you selected already contains the headers you want to use. If you don't check this box, the table will display default header names, which you can then go in and change.
Hit the "OK" button at the bottom of the Create Table dialog box to create your table.
141 views
Usually answered in minutes!
same as above
what is DATA BASE
I would like to do some research on Excel formulas that use more than one spreadsheet, I am doing this for my class assignment. Can you help me?
×