| Article Index |
|---|
| Microsoft Excel Problems and Solutions |
| Why do my scrollbars go to row 500 -- my data ends in cell E50 |
| Password and Protection |
| Entering and Saving Data |
| All Pages |
Page 1 of 4
Source: Contexture
The article below lists some of the most frequently faced problems of Microsoft Excel and provides reasonable solutions for them. Its in a questions and answers format.
Why do the column headers show numbers instead of letters? How do I change my column headings so they are back to letters instead of numbers?
- Choose Tools > Options and select the General tab.
- Remove the check mark from 'R1C1 reference style'
How can I change the color of the sheet tabs?
In Excel 2002, and later versions, you can colour the sheet tabs. Right-click on a sheet tab, and choose Tab Color...
Note: When the sheet is selected, the colour will show in a thin strip at the bottom of the sheet tab. The full tab is coloured for non-selected sheets.
| < Prev | Next > |
|---|
