Feb 25, 2015 It's because Macs and PCs have different keys on the keyboard, and those modifier keys mean different things in the Operating System itself (Ctrl / Alt on a PC, Command, Option, and Control on a Mac). The Best Shortcut Keys in Microsoft Excel If you are using Microsoft Excel in your daily life, you can use excel shortcuts to save time. While preparing any report or dashboard, if we use shortcut keys then the task would be completed in less time than expected.
Many of the shortcuts that use the Ctrl key on a Windows keyboard also work with the Control key in Office 2016 for Mac. However, not all do. Note: If a shortcut requires pressing two or more keys at the same time, this topic separates the keys with a plus sign (+). 50 time-saving Excel shortcuts. Save time and conquer the spreadsheet with these 50 Excel keyboard shortcuts. Get the most out of Excel in Windows with these pro tips.
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 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.
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.
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.
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.
/ Tuesday, October 21 2014 / Published in Apple, Latest, Windows 7, Windows 8, Windows 8.1
Keyboard Shortcuts from Windows to Macs: Overview![]()
Many Windows users know familiar keyboard shortcuts for common tasks, like “Cut,” “Copy,” and “Paste,” for example. However, you may feel a bit lost if having to use a Mac computer or MacBook Pro, for example. In addition, even though the PC market is shrinking, Apple just announced one of its biggest quarters ever with a notable increase in the sales of its Mac computers. This means that some of you are clearly switching to Macs from PCs. In light of this, we thought that a blog post that shows how to perform some common tasks in both operating systems would be helpful to many of you, who may be using new Macs for the first time. In this blog post, we will cover switching keyboard shortcuts from Windows to Macs.
Why Dont Macs Have Alt Keyboard Shortcuts For Microsoft Excel 2013
When switching keyboard shortcuts from Windows to Macs, it is useful to note that many of the keyboard shortcuts remain the same, but simply use the “Command” and/or “Option” key on the Mac keyboard in place of the “Ctrl” key on the Windows keyboard. However, many other keyboard shortcuts are completely different. Below is a table, grouped by computing category, that lists commonly used keyboard shortcuts in each category, the Windows keyboard shortcut, and the corresponding Mac keyboard shortcut. We hope this list makes transitioning from one to the other easier for you.
Keyboard Shortcuts from Windows to Macs: Table
Why Don't Macs Have Alt Keyboard Shortcuts For Microsoft Excel Windows 10Keyboard Shortcuts from Windows to Macs: A picture of a glowing keyboard.Why Don't Macs Have Alt Keyboard Shortcuts For Microsoft Excel WordWhat you can read nextRotate a Photo in Lightroom Classic CC – InstructionsComments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |