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 » Moving all cells
Moving all cells
Resolved · Low Priority · Version 2007
Fri 21 Jan 2011, 16:08Delegate Deborah said...
Deborah has attended:
Excel Introduction course
Moving all cells
i have for gotten how to move all cells
Mon 24 Jan 2011, 16:19Trainer Anthony said...
RE: moving all cells
Hi Deborah, thanks for your query. You can move cells in several different ways. You could select all of the cells you wish to move then click and drag on the thick black border of the selection, dragging the cells to where you want them to be. You could also cut and paste the select to where you'd prefer it, although watch out if you have any formulas when you do that!
Hope this helps,
Anthony
Mon 31 Jan 2011: Automatically marked as resolved.
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. |
