Moving Data with the Cut and Paste Commands


Google Spreadsheets lets you move data from one place to another in your worksheet by cutting and pasting the data. The cut and paste procedure is similar to that used in most Windows-based applications.

To cut and paste data in your spreadsheet, follow these steps:

1.

Select the cell or range of cells to move. (You can cut individual cells, entire rows and columns, or marked cell ranges. Use your mouse or the keyboard to select the range.)

Tip

To select an entire column, click the column header (A, B, C, and so on). To select an entire row, click the row header (1, 2, 3, and so on).

2.

With the selection highlighted, click the Cut button.

3.

Move the cursor to the first cell where you want to move your data. There is no need to select the entire range, just the first (upper-left) cell of the range.

4.

Click the Paste button.

Google now moves the highlighted data to the new location.

Caution

Be careful when cutting and pasting data! When you use the Paste command, Google will paste the copied data over any data that previously existed in the target range. Be sure no important data resides in the target range.


Tip

You can also use the following keyboard shortcuts when cutting and pasting data: CutCtrl+X or Shift+Delete; PasteCtrl+V.





Using Google Spreadsheets
Using Google Spreadsheets
ISBN: B000P28WL2
EAN: N/A
Year: 2007
Pages: 78

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net