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 » Numbered Cells
Numbered Cells
Resolved · Medium Priority · Version 2007
Wed 31 Mar 2010, 10:31Delegate Mark said...
Mark has attended:
Excel Intermediate course
Numbered Cells
I have a spreadsheet in which i have labelled a number of cells with the same text (B&W & Colour).
After the first cell, the following cells insist on being numbered (B&W2, B&W3, B&W4, Colour2, Colour3, Colour4).
I have tried formatting the cell to text as well as typing over the suggested text, but it reverts back to a numbered cell everytime.
Can you help?
Tue 6 Apr 2010, 11:20Trainer Simon said...
RE: Numbered Cells
Hi Mark,
Thank you for your question.
Sorry for the delay in responding.
If possible can you please send me a copy of the workbook to sk@stl-training.co.uk
Regards
Simon
Tue 6 Apr 2010, 13:49Trainer Simon said...
RE: Numbered Cells
Hi Mark,
Thank you for the attachment.
The problem you are having is due to the fact the data and headings have been formatted as a table in which the headings have to be unique.
Select a cell within the table and go to the Design tab of the yellow Table Tools menu which will appear above the ribbon.
Go to the Tools tab and click Convert to Range and say yes to convert the table to a range. Then you can rename the cells so they are the same across.
I hope this works.
Let me know.
Regards
Simon
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:Hide data in Excel WorksheetsLet's say you have some data in cell 'C5' you would like to hide from the casual viewer. |
