The paste special feature is undoubtedly a very useful option in Excel. It helps us control what we want to copy from the source and what we don't. I often refer to this option for various tasks, and here the shortcut of paste special in excel comes in handy.
Paste from Clipboard on Mac When you hold down the Command/⌘ key and click on the V key, your Mac automatically pastes the content of the clipboard into the new destination. If after the Command+V operation, you don’t see the newly copied content, check your Clipboard. You may have deleted the clipboard content by mistake. Method 2of 4:Mac 1. Highlight the text or image. Using your mouse, place your cursor in front of the text or image that you’d like to. Press ⌘ Cmd + C on your keyboard. Using 2 fingers, press this button and the “C” button at the same time to copy. Navigate to the area you’d like to.
Paste Special Shortcut in Windows
In windows, the keyboard shortcut for paste special is CTRL+Alt+V. Once you press this key combination, the paste special dialog box will open. Here you will many choices for pasting your data. Choices like All, Value, Format, etc. Each choice has a letter underlined that you can press on the keyboard to paste that property of copied cell/range.
Paste Special Shortcut in Mac
In mac, we use CTRL+COMMAND+V key combination to open the paste special dialog. To select an option from the list, we use the COMMAND+letter key in mac.
Let's have some examples to see the paste special shortcuts in action.
Excel Paste Special Example
Here I have an excel table that is formatted and has formulas in it.
Now press the shortcut CTRL+ALT+V in windows to open the paste special shortcut. On Mac use the above mentioned shortcut.
I want to just paste the values. I hit the V key (V is underlined on Value option). The value option is selected. When I hit the Enter button, I get naked values. It does not have any formatting or formulas.
Omnifocus pro 2 3 download free. On Mac, we use the command+V key to select Value.
To paste just formatting, press the T key (T is underlined for Formats). It pastes the formatting of the copied range to the selected range.
On Mac, use the command+T key to select Value.
![Copy paste on mac shortcut Copy paste on mac shortcut](https://billymarkblog.files.wordpress.com/2019/01/how-to-copy-and-paste-text-by-using-keyboard-shortcuts-on-mac-copy.jpg)
Similarly, we can do all of the tasks in using just the keyboard with the paste special shortcuts options.
Paste Special from non-Excel source
Many times we copy data from other sources, like the internet or any other application. In those cases, if you directly paste using CTRL+V, excel will most likely paste all the components of source like formatting, checkboxes, radio buttons, etc. which is undesirable (in most cases). You would probably like to paste values only. In that case, you will use paste special. When using the paste special, here you will get only three options; HTML, Unicode Text, and Text.
The default is an HTML option, which will paste everything you copied. Others are Unicode Text and Text (press T for selecting Text). These two options will paste plain text, that we desire most of the time.
The difference in Text and Unicode Text is that Unicode Text uses Unicode to convert ASCII values into text and symbols. The ASCII Text is useful when we work with multinational data or Mathematical and Scientific data.
The Sequential Shortcut For Paste Special
This one is old but I frequently use it. If you hit the keys ALT--> E-->S, one by one, it will open the Paste Special menu. This is an old command that was used in Excel 2003 but it is still compatible. Afterward, the process is the same.
I hope it is helpful. If you have any Excel/VBA related query, ask it in the comments section below.
Related Articles:
50 Excel Shortcut’s to Increase Your Productivity | The Excel shortcuts enhance the efficiency of work a lot. These 50 shortcuts can increase your productivity exceptionally on Excel
Excel Insert Row Shortcut | These shortcuts will help you insert single and multiple rows quickly.
![Keyboard Keyboard](https://www.cleverfiles.com/help/wp-content/uploads/2017/10/macbook-keyboard.jpg)
Excel Shortcut Keys for Merge and Center | This Merge and Center shortcut helps you quickly merge and unmerge cells.
Popular Articles:
The VLOOKUP Function in Excel | This is one of the most used and popular functions of excel that is used to lookup value from different ranges and sheets.
COUNTIF in Excel 2016 | Count values with conditions using this amazing function. You don't need filter your data to count specific value. Countif function is essential to prepare your dashboard.
How to Use SUMIF Function in Excel| This is another dashboard essential function. This helps you sum up values on specific conditions.
Anyone who has had to type up huge chunks of text will agree that the copy and paste functions are probably two of the best things ever invented. And it’s not only good for editing lengthy lines of text, it’s also quite handy for people who have trouble remembering complex combinations like PIN codes, serial numbers and the like. It’s such a frequently used function that one of the first things new Mac users ask our Mac Experts is how to use this function.
How to Copy and Paste on a Mac Using a Keyboard Shortcut
If you’ve been a long-time Windows user and have just recently started using a Mac, pressing CTRL + C and CTRL + V for copy and paste respectively is already thoroughly ingrained — so much so that you probably tried using the same key combinations on your Mac until you realized the CTRL key has been replaced with a key labeled “control.”
Don’t panic. While the Control key doesn’t have the same function on Macs as it does on Windows, there’s an equally quick way to perform copy and paste on a Mac and that is by pressing Command + C (⌘ + C) and Command + V (⌘ + V).
If you don’t want to be bothered with constantly pausing and reminding your fingers to use Command instead of the Control key, or if you want to use a Windows-based keyboard that doesn’t have a Command key to begin with, you can remap your Mac keys so that you can assign a different key for performing copy and paste on your Mac.
To remap your Mac keys:
- Go to the Apple Menu
- Open “System Preferences”
- Click on “Keyboard”
- Select “Shortcuts”
- Click on “Modifier Keys”
- Go to the “Command” field
- Click on the drop-down menu
- Select “Control”
- Click “OK”
Please note that while remapping your Mac keys this way will apply the changes to the whole system, there are certain applications where it may not work. To ensure that your preferred keyboard shortcut for copy and paste on your Mac will also work on your frequently used applications:
- Go to the Apple Menu
- Open “System Preferences”
- Click on “Keyboard”
- Select “Shortcuts”
- Select “App Shortcuts”
- Click the “Add” button (the one with the + sign)
- Select the app or apps for which you want your preferred keyboard shortcuts to be used.
- If you can’t find your favorite application on the list, click “Other” then use the “Open” dialog box to search for it.
- If you want your preferred shortcut for copy and paste to apply to all applications, just click on “All Applications.”
- In the “Menu Title,” type in the command for which you want your shortcut to work (for example, type “Copy” if you want to assign a keyboard shortcut for copying and “Paste” if you want a keyboard shortcut for pasting things). Please make sure that you write the menu title exactly the same way the command is written on your favorite application’s menu (including capitalization and spaces).
- Next, go to the “Keyboard Shortcut” field, then press the key combination that you want to use for the keyboard shortcut while you’re in the empty box beside it.
- Click on “Add”
How to Copy and Paste on a Mac Using a Apple Magic Mouse
Many Windows users, employing a two-button mouse, know to right click in order to copy and paste. However, mice that come with Macs have only one button. The easiest way to copy and paste using a Magic Mouse is as follows:
- Highlight the text that you want to copy
- Hold down the Control button
- Click the mouse button
- Select “Copy” from contextual menu
- Go to the place where you want to paste the text
- Hold down the Control button
- Click the mouse button
- Select “Paste” from contextual menu
How to Copy and Paste on a Mac Using Your Trackpad
Copy And Paste On Mac
Aside from using a keyboard shortcut and your mouse, you can also use your trackpad to perform copy and paste on your Mac.
On Windows-based PCs, you usually do this by highlighting the text that you want to copy, pressing on the lower right corner of your trackpad which is equivalent to performing a right-click with your mouse, then selecting “Paste” from the menu.
On Macs, the process is similar: highlight the text that you want to copy, use two fingers to lightly tap around the center of your trackpad to bring up the contextual menu (the popup menu that appears when you initiate a “Control + mouse click), then selecting “Paste” from there.
Now, go and try to practice them so that you can get used to performing copy and paste on your Mac before you work on projects that require a lot of copying and pasting.
Good luck!
Copy And Paste On Mac Keyboard
Keep checking back at the PowerMax blog for all kinds of news, tips, tricks, how tos and more!