Question about Microsoft Excel for PC
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.
Posted on Jan 10, 2008
Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
Here's a link to this great service
Posted on Jan 02, 2017
Tips for a great answer:
Apr 09, 2014 | Microsoft Excel for PC
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.
Mar 18, 2011 | Computers & Internet
Nov 15, 2010 | Microsoft Windows XP Professional
Oct 01, 2010 | Microsoft Office Excel 2007 Upgrade:...
May 14, 2009 | Microsoft Office Excel 2007
Sep 29, 2008 | Microsoft Computers & Internet
Aug 08, 2008 | Microsoft Excel for PC
Dec 19, 2007 | Computers & Internet
Jan 28, 2016 | Microsoft Excel for PC
Dec 12, 2013 | Microsoft Excel for PC
117 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: