When you take time to size columns in Google Sheets the exact sizes you want, you may want to carry those sizes elsewhere in your sheet. This option helps you avoid reformatting your borders when moving data around. It pastes everything you copy including data and formatting except cell borders. Paste All Except Borders does exactly what the name implies. You may have data with borders, formulas, and other formatting. This is an alternative to the Paint Format tool because it will not change any data and only paste formatting. If it’s not the data you want to paste but the formatting instead, Paste Format Only is the action you want. If the data you’re copying includes a formula, Paste Values Only will paste only the result of the formula. This action pastes only the text without formatting. You can think of Paste Values Only as the plain text paste you’d use in Microsoft Excel. Let’s look at each of the eight paste special options currently available and what they do. And whether you’re copying data, formulas, or formatting, it’s important to know the correct paste option to select. While some of the paste special options in Google Sheets seem clear enough, others may not. Select the paste option from the pop-out menu. Select the cell(s) and go to Edit > Paste Special in the menu.Right-click the cell(s) and move to Paste Special in the shortcut menu.Press Ctrl+C on Windows or Command+C on Mac.Select the cell(s) and click Edit > Copy in the menu.Right-click the cell(s) and select “Copy” in the shortcut menu.Once you do, you’ll then access Paste Special. Access Paste Special in Google Sheets Paste Special Options in Google Sheets Paste Values Only Paste Format Only Paste All Except Borders Paste Column Widths Only Paste Formula Only Paste Data Validation Only Paste Conditional Formatting Only Paste Transposed Access Paste Special in Google SheetsĪs a refresher, you can copy data in Google Sheets in a few easy ways.

Google sheets copy formatting shortcut