Copying and pasting is a normal occurrence in Microsoft Excel and works the same way as in other programs. Most times, Excel users often copy the resulting figures of particular formulas as a value or text in another cell without copying the formula. There are different ways to copy and paste in Excel as text without having to copy formulas.
In this guide, we explain to you the steps to follow to paste into Excel as text. Here we go:
Method 1 copying and pasting cell as Text value not a formula
1. In an open Excel workbook, select all the cells you wish to copy.
2. Right-click on the cells.
3. Click on the option ‘Copy.’ You can also use the keyboard shortcut Ctrl + C.
4. Right-click on the location where you wish to paste your copied results. These should be blank cells.
5. Click on the ‘Paste Special’ option and select, Paste values only. You can also use the keyboard shortcut Ctrl + Shift + V.
Alternatively, you can paste Excel values as text using in-built features.
1. In an Excel workbook, select the range of cells you wish to copy as text value only.
2. Press on the keyboard keys Ctrl + C.
3. Select blank cells where you will place the copied cells.
4. Click on the Home tab of the main menu ribbon.
5. In the Clipboard section, click on the drop-down arrow next to the option ‘Paste.’
6. Under the Paste Values section, select the Values
Method 2: copying and pasting as text in Google Sheets
When working with Google Sheets, the Paste as Value option is a little bit different compared to Microsoft Excel. To successfully paste in Google Sheets as text, here is what to do:
1. Right-click on the cell or cells you want to copy and paste as text.
2. Click on the option ‘Copy.’ You can also use the keyboard shortcut Ctrl + C.
3. Right-click on the location where you want to paste your copied results.
4. Click on the ‘Paste Special’ option and select, Paste values only. You can also use the keyboard shortcut, Ctrl + Shift + V.
You will notice that the results in the destination cell are copied as text.
Method 3: pasting values as text in Microsoft Excel 2016, 2019 & 365
In Microsoft Excel 2016, 2019, and 365, you can copy your values as texts without having to include formulas.
1. In an open Excel workbook, click and select the cells you wish to copy and paste.
2. Go to the Home tab on the main menu ribbon.
3. In the Clipboard section, click on the ‘Copy’ option drop down arrow.
4. Select the cells where you want to paste your values.
5. In the clipboard section, click on the Paste button to display an extended menu list. Here, click on the option Values.
6. Click the OK You will have successfully pasted your values as text in your Excel worksheet without including the formulas.