![]() “Paste all except borders” to copy the sheet into another workbook without borders.“Paste column widths only” to resize the columns to match the original sheet.“Paste format only” to paste just the cell formatting from the original sheet.“Paste values only” to paste just the text within the cells from the original sheet.Open the “Edit” menu again and tap “Paste Special.”.Choose “Open spreadsheet” in the pop-up window.Right-click on the sheet name at the bottom of the document, select “Copy to” from the menu and select “New spreadsheet”.Click “Edit” (top right of the screen).Follow these steps to change the format from a PC using Paste Special: This feature is useful to copy and recycle customized reports or budgets, but it can utilize different formatting. However, you can change the formatting and other options on the new Google Sheet using Paste Special. ![]()
0 Comments
Leave a Reply. |