98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Coloumns
Coloumns
Resolved · Medium Priority · Version 2003
Mon 30 Jun 2008, 15:17Delegate Susie said...
Susie has attended:
Excel Introduction course
Coloumns
How do i name the colomns i.e. i dont want it to be called "A 1" i want it to be called sales/monjth
Tue 1 Jul 2008, 11:03
Edited on Tue 1 Jul 2008, 11:03Trainer Carlos said...
RE: coloumns
Hi Susie
If you want to label the information in a column you click the first cell of the column and enter the label
However what you seem to be asking is to change the name of the cell from "A1" to "Sales/Month"
To rename a cell or range of cells you do the following:
1. Select the cell (s) you want to name
2. Enter the name with no spaces in the Name box.
NB This is the left most box on the formula toolbar where the Cell name appears
3. Press Enter
Hope this helps
Carlos
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Sorting List SubtotalsIf you find that you would prefer to show the items in a subtotalled list in a different order, eg ascending rather than descending, you can sort your list. To sort a subtotalled list, hide the detail rows and then sort the subtotal rows. When you sort a subtotalled list, the hidden detail rows are automatically moved with the subtotal rows. |
