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.

Change row to column in excel