How to Copy & Paste Without Borders in Excel & Google Sheets
Written by
Reviewed by
This tutorial demonstrates how to copy cells and paste without borders in Excel and Google Sheets.
Copy and Paste Without Borders
If you copy one cell to another in Excel using basic copy-paste, you copy all cell attributes. This includes: background color, font type and color, borders, etc. Say you have the cell format shown in B2 below (red font, yellow cell background, and thick outside border).
If you just copy-paste this cell to B4, all attributes are copied along with the content.
To copy a cell without copying its borders, follow these steps:
- Right-click the cell you want to copy (here, B2), and choose Copy (or use the keyboard shortcut CTRL + C).
- Right-click the cell where you want to paste (B4), and choose Paste Special.
- In the Paste Special window, check All except borders, and click OK.
As a result, cell B2 is copied to B4 with all formatting except borders.
Tip: You can also use the Paste Special VBA functionality.
Copy and Paste Without Borders in Google Sheets
You can also copy and paste cells without borders in Google Sheets.
- Right-click the cell you want to copy (here, B2), and choose Copy (or use the keyboard shortcut CTRL + C).
- Right-click the cell where you want to paste (B4). Then go to Paste special > Paste all except borders.
Finally, cell B2 is copied to B4 without borders.
