By default, Excel uses the "A1" format when referring to cells. This means that the "A" is the Column and the "1" is the Row that is being referred to. Most Excel users understand this; but some spreadsheet programs do not use this referencing.
Instead, other programs use the "R1C1" format when referencing cells. Excel allows for this format as well.
To specify the format you want to use, follow these steps.
Click on the "Office" button and select the "Excel Options" button.
Select the "Formulas" tab on the left menu.
Check the "R1C1 reference style" checkbox in the "Working with Formulas" section and click the "OK" button to save the changes.
Click on the "Tools" menu and select the "Options" menu item. Follow the above instructions from here.
Click on the "File" tab and select the "Excel Options" button. Follow the above instructions from here.
Notice the Column Headers are now numbers instead of letters.
NOTE: If you prefer the "A1" formatting and need to change Excel back to this preference, simply follow the above steps and uncheck the "R1C1" checkbox.
I often hear people say "I no longer see the Forward, Reply, and Reply to All buttons on my emails. How do I get this information back?...
This is the text version of a YouTube Live session of Go Ask Debbie: How to Delete Blank Rows in Excel. I thought I'd just do a quick ...
Since 1998, Google has been giving us Google Doodles. The first Google Doodle was in honor of the Burning Man Festival . It wa...