Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

excel training course - shortcut

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training course - Shortcut

excel training course - Shortcut

ResolvedVersion Standard

Hazel has attended:
Excel Introduction course
Excel Intermediate course

Shortcut

What is the shortcut to swap two rows?

RE: Shortcut

Hi Hazel. Swapping two rows is as simple as cutting one row and pasting it as "Insert Copied Row" above another. If you need this as a shortcut, try creating a macro out of the performance and assigning it a shortcut key.

Excel tip:

Copying Values Without Formulas in Excel 2010

If you want to copy the contents of a cell but don't want to copy the formula with it then use the following simple method:

Press Ctrl+C to copy the values in the cell. On the Home tab, click Paste and then click Paste Values.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.