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?

2 Answers

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. You can then click the menu or press Ctrl to open it and select options.

excel paste example

0

Method 1: Press F2 on the cell then select the content of the cell and then ctrl+c.

Method 2: Just go to new blank cell and then use the "=FORMULATEXT(A1)". This will convert the cell content to text format. Now copy this new cell.

1

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password

Post as a guest

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy