Moving Rows and Columns

In many cases, the data in your worksheets will have first been recorded on paper—for example, when you record times for a race or collect customer responses on survey forms. Sometimes it’s easier to type the information into your worksheet so that it looks the same way as it looked on paper. You can move rows and columns to new positions on the worksheet in order to present the information the way you want it to look.

Move One or More Rows

  1. Select the rows you want to move.

  2. Click the Home tab.

  3. In the Clipboard group, click the Cut button.

  4. Click the first cell in the row where you want the rows to be moved.

  5. In the Clipboard group, click the Paste button.

    Move One or More Rows

Move One or More Columns

  1. Select the columns you want to move.

  2. Click the Home tab.

  3. In the Clipboard group, click the Cut button.

  4. Click the first cell in the column where you want to move the columns.

  5. In the Clipboard group, click the Paste button.

    Move One or More Columns
..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
3.16.79.147