How to Paste Formula as Text in Excel
How to Paste Formula as Text Value in Microsoft Excel
By default when you copy/cut and paste in Excel, everything in the source cell or data range, formatting, formulas, validation, comments is pasted to the destination cells. This is what happens when you press CTRL+V to paste. Since that might not be what you want, you have many other paste options, depending on what you copy.
For example, you might want to paste the contents of a cell, but not its formatting. Or maybe you want to transpose the pasted data from rows to columns. Or, you might need to paste the result of a formula instead of the formula itself.
Paste Special
To use options from the Paste Special box, select Home, select the clipboard icon (Paste), and select Paste Special.
Keyboard Shortcut: Press Ctrl+Alt+V.
In the Paste Special box, pick the attribute you want to paste.
Note: Depending on the type of data you copied and the Paste option you picked, some other options might be grayed out.
Watch video How to Paste Formula as Text in Excel online without registration, duration hours minute second in high quality. This video was added by user PDF Browser 12 July 2021, don't forget to share it with your friends and acquaintances, it has been viewed on our site 2,690 once and liked it 4 people.