Microsoft Office Online
Sign in to My Office Online (What's this?) | Sign in

Warning: You are viewing this page with an unsupported Web browser. This Web site works best with Microsoft Internet Explorer 6.0 or later, Firefox 1.5, or Netscape Navigator 8.0 or later. Learn more about supported browsers.

Email this linkEmail this link Printer-Friendly VersionPrinter-Friendly Version Bookmark and ShareShare
Move or copy items in a table
 
  1. Select the cells (cell: A box formed by the intersection of a row and column in a worksheet or a table, in which you enter information.), rows, or columns you want to move or copy.

    ShowHow?

    Some parts of a table (table: One or more rows of cells commonly used to display numbers and other items for quick reference and analysis. Items in a table are organized into rows and columns.) can only be seen if you display all formatting marks by clicking Show/Hide Paragraph mark Button image on the Standard toolbar (toolbar: A bar with buttons and options that you use to carry out commands. To display a toolbar, click Customize on the Tools menu, and then click the Toolbars tab.).

    To select:

    A cell
    Click the left edge of the cell (cell: A box formed by the intersection of a row and column in a worksheet or a table, in which you enter information.).
    Select table cell
    A row
    Click to the left of the row.

    Select table row

    A column
    Click the column's top gridline or border.

    Select table column

    Multiple cells, rows, or columns
    Drag across the cell, row, or column.
    Or select multiple items that are not necessarily in order. Click the first cell, row, or column you want, press CTRL, and then click the next cells, rows, or columns you want.
    Text in the next cell
    Press TAB.
    Text in the previous cell
    Press SHIFT+TAB
    The entire table
    In print layout view (print layout view: A view of a document or other object as it will appear when you print it. For example, items such as headers, footnotes, columns, and text boxes appear in their actual positions.), click the table move handle Four-headed arrow handle, or drag over the entire table.

    Note  You can also select rows, columns, or the entire table by clicking in the table and then using the Select commands on the Table menu, or by using keyboard shortcuts.

    • To move or copy text to a new location without changing the text that is already there, select only the text within a cell, and not the end-of-cell mark.

    End-of-cell mark

    Callout 1 End-of-cell mark

    • To replace the existing text and formatting in the new location, select the text you want to move or copy and select the end-of-cell mark.

  2. Do one of the following:
    • To move the selection, drag it to the new location.

    • To copy the selection, hold down CTRL while you drag the selection to the new location.

© 2009 Microsoft Corporation. All rights reserved.