💻 Software
How to copy the contents only of an Excel cell minus the formatting?
Fresh5 days ago
Mar 15, 202625975 viewsConfidence Score0%
0%
Problem
When I copy a cell using Ctrl + Insert and paste it elsewhere in the worksheet, the formatting is also carried along (such as the cell borders, etc). Is there a shortcut to copy only the contents minus any formatting?
Unverified for your environment
Select your OS to check compatibility.
1 Fix
Canonical Fix
Unverified Fix
New Fix – Awaiting Verification
Fix for: How to copy the contents only of an Excel cell minus the formatting?
Low Risk
You can use Paste Special (in the edit menu) to specify exactly what should and should not be pasted. If you have Excel 2007 or later, pasting normally (Ctrl+V) also works; a dropdown box then appears with options to paste without formatting, etc. Y…
Awaiting Verification
Be the first to verify this fix
Sign in to verify this fix