To move one or more cells, place your cursor on the cell border (the cursor image should change to a four-way arrow ), and then click and drag the cell(s) to move them to the desired location. NOTE: If a filter has been applied to the sheet the rows may be non-consecutive.
Click and drag one of the row numbers to move them all to a new location. Hold down the Ctrl key (Windows)/Cmd key (Mac) and click the row numbers that you want to move to highlight them. Click and drag the row number of one of the highlighted cells to move them all to a new location. Hold down the Shift key, and then click on the bottom row number to highlight all of the rows in between. 
Click the row number for the top row in the collection that you want to move. Next, click on the row number where you want to move the row and press Ctrl + V (Windows) or Cmd + V (Mac) to paste it in. Click on the row's number and press Ctrl + X (Windows) or Cmd + X (Mac) to copy it. TIP: You can also cut and paste the row to move it within the sheet. Click the row number and drag it up or down the sheet.Ī dark horizontal line appears indicating where the row will be moved when you release your click. Move Content Within a Sheet To move a single row For more information about sheet maximums, see System Requirements and Guidelines for Using Smartsheet. Note that you'll receive a "This action could not be completed." error if the data you're attempting to move would cause the destination sheet to exceed maximum sheet size limits. If this occurs, you'll need to scroll all the way to the right to find the data, copy it, then paste it into the desired columns. If it doesn't, data from the row you copied or moved will be inserted into new columns to the right of existing columns. Before You Beginīefore you move or copy a row to another sheet, make sure the destination sheet includes identical column names and types. For more information about sharing permissions in Smartsheet, see Sharing Permission Levels. If you want to move data to a different sheet, you must have the same access level in the sheet where the row is being moved to complete the action. To make changes to columns, you must have Owner or Admin level sharing permissions to the sheet. You must have Owner, Admin, or Editor access to a sheet to make changes to rows and cells. For more information, see Automatically Move or Copy Rows Between Sheets. TIP: You can move rows automatically with an automated move row workflow. Here's a summary of what you can move and how you can move it. After you set up a sheet, you may find that some of the information-cells, rows, or columns-needs to be moved or reorganized.
0 kommentar(er)
