Tuesday, August 27, 2013

How to Show Numbered Columns


Microsoft Excel 2003
1. Click on the 'Tools' menu, and select 'Options.'
2. At the top of the window that appears, click the 'General' tab.
3. Under 'Settings,' click the 'R1C1 reference style' check box.
4. In the lower right-hand corner of the window, click the 'OK' button.
Microsoft Excel 2007
5. At the top left of the screen, click the round button that features the Microsoft Office logo.
6. Toward the bottom right of the information box that appears, click 'Excel Options.'
7. At the top of the window that appears, click the 'Formulas' tab.
8. In the 'Working with formulas' section, click the 'R1C1 reference style' check box.
9. In the lower right-hand corner of the window, click the 'OK' button.

Blogger news