Reminders associated with the row in the original sheet will not be included in the destination sheet.The history for cells in the moved row will be available (right click a cell and click View Cell History-you'll see an item "Row was moved from another sheet"). The row will be placed at the bottom of the destination sheet and can then be dragged up or down to a different location. Any attachments or comments on the row will be moved automatically to the destination sheet. Select the destination sheet from the list or type part of the sheet name to find the sheet, select the destination sheet name, and click OK.You can then click the drop-down arrow to the right of any highlighted row and select Move to Another Sheet. TIP: You can move multiple rows at the same time by using the instructions above to highlight them first. Hover over the row number and then click More to access the Row Menu.You can then click and drag any highlighted column's header to move them all to a new location. You can move multiple columns at the same time by holding down Shift or Ctrl on your keyboard and then clicking on the column headers that you want to move.Columns cannot be moved to other sheets.You must be the sheet owner or a licensed collaborator with Admin access to the sheet to move a column.Release your mouse when the new placement is valid to successfully move the column to a new location.Watch your cursor as you drag the column-if the icon turns into a red circle, the new column placement is not valid and the column won't be moved. TIP: A dark vertical line indicates where the column will be placed when you release your click. Click on the column header and drag it to the left or right within the sheet.Press Ctrl + Z (Windows)/Cmd + Z (Mac) to undo the move action. NOTE: Moved cells overwrite the cells where they are placed. 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)
