98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Excel 2003
Excel 2003
Resolved · Low Priority · Version 2003
James has attended:
Excel Intermediate course
Excel 2003
Sometimes when I copy down lines which have a number at the end the number goes up by one and I don't usually want it to.
RE: Excel 2003
Hi James
Sorry for the delay in answering this question.
In Excel when you enter a Word/number combination (e.g. Week1) and copy this down by dragging, as a default, the system does a Series copy.
This automatically increases the number in the statement by 1.
To be able to copy only the value with no numeric increase:
After the copy a Auto Fill Options box appears next to the last cell of the copy range.
Click the box
You should find Fill Series selected
Select Copy Cells.
The data should lose the number increments and revert to the value in the original cell
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:Use the SUBTOTAL function in ExcelYou can create subtotals in your spreadsheet using the SUBTOTAL function, which looks like this: |