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.
Смотрите видео How to Paste Formula as Text in Excel онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь PDF Browser 12 Июль 2021, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 2,690 раз и оно понравилось 4 людям.