training ms excel advanced - Swapping data from one row to another

Resolved · Low Priority · Version Standard

Mon 12 Mar 2007, 16:17 Delegate Asger said...

Asger has attended:
Excel Introduction course
Excel Intermediate course

Swapping data from one row to another

How do I safely swap data from say rows 1 and 2.

Thanks

Mon 12 Mar 2007, 16:28 Trainer Richard said...

RE: Swapping data from one row to another

There can be several ways.

Highlight and cut the row you want, then right click and INSERT CUT CELLS into the row you want it to end up in.

Excel tip:

Find cells that match a format

In Excel you may wish to find cells that contain a specific formatting such s colour.

Select Edit > Find, click on Options and then Format...choose the formatting that you want found and click on OK

Choose one of the Find buttons to find.

View all Excel hints and tips

training ms excel advanced - Swapping data from one row to another

Swapping data from one row to another

RE: Swapping data from one row to another

Excel articles

Excel tip:

Find cells that match a format