Skip to playerSkip to main content
  • 6 months ago
Discover how to paste without formatting in Excel. How do you paste and paste without formatting, and what is the shortcut for paste without formatting in Excel Mac, as well as how do I remove formatting from copy and paste, and why does paste without formatting not work?

These are the steps outline on the video.

Method 1: SLOW
Paste Without Formatting (slow)
1) Ctrl + A
2) Ctrl + C
3) Select an empty cell.
4) Right-click cell
5) Select Paste Values icon

Method 2: FAST
Paste Without Formatting (fast)
1) Ctrl + A
2) Ctrl + C
3) Select an empty cell.
4) Ctrl + Shift + V

🔗🔗 LINKS TO SIMILIAR VIDEOS 🔗🔗
Google Sheet Shortcut: How to Paste Without Formatting - Excel Tips and Tricks
https://youtube.com/shorts/KUBuaXaqCpk?feature=share


How do you paste and paste without formatting?,What is the shortcut for paste without formatting in Excel Mac?,How do I remove formatting from copy and paste?,Why does paste without formatting not work?,
Transcript
00:00Let's say for example if you have a really complicated formatted data table like this here
00:04and you want to copy only the data from this table here to another worksheet. How do you do it?
00:10Let's copy the clipboard to start off with. Ctrl A to highlight the whole data set table. Ctrl C
00:14to copy the clipboard. You go to a new cell. There's two ways to do it. Right click on it
00:19and press this icon here and you can see that only copy the data from the table here. But the
00:24fastest way of course is to use a hotkey. Select the cell like this and press Ctrl Shift V and you
00:31will do the same thing but much faster.
Comments

Recommended