Linked Picture pastes a live picture of the copied range.When the original range changes, this picture does not change. This picture might include cells, SmartArt, charts, and so on. Static Picture pastes a picture of the copied range.Paste Link will create formulas in the pasted range that point back to the source range.Values & Formatting converts formulas to values, but brings along the cell formatting, too.Values & Number Format converts formulas to values, but brings along any numeric formatting applied to the source range.Values eliminates the formulas and paste their current values.Merge Conditional Formatting allows you to mix two different conditional formats.Column Widths copies the column widths from the source range.No Borders pastes everything except for the borders.Keep Source Formatting is similar to a regular paste.Borders, comments, and fills are not pasted. Formulas & Formatting will paste the formulas and any numeric formatting.The following list describes each of the 15 items in the Paste Options menu: Photocopy Fig 84 and hang it up by your desk. The one complaint that I have heard about the Paste Options menu is that it is tough to figure out what the icons mean. The paste dropdown in Excel 2010 offers the icons.If you need to paste values and formats, the Right-Click, E keys will do it. Use Ctrl+C, Right-Click Key, V to paste as values. To paste values and formats, you now use the new Ctrl+V, Ctrl, E to paste values and number formatting. In the new place, I have to do Alt+E+S+V, Enter, Alt+E+S+T+Enter.Īs mentioned previously, you can use Ctrl+C, Ctrl+V, Ctrl, V to change formulas to value. Sometimes, I need to copy values and formats to a new place. Many times each day, I convert formulas to values by using Ctrl+C, Alt+E+S+V, Enter. You can access those commands by using the Paste Special menu item at the bottom of this figure. There are still some options in Paste Special that are not available in the icons. If you regularly use the Paste icon in the Home tab, the dropdown at the bottom of the tab now leads to a menu with the 15 icons. If you hover over Paste Special in the right-click menu, the menu will disappear and you have access to all 15 icons. When you hover over one of those icons, the rest of the context menu disappears so that you can see the effect of the paste in Live Preview. When you release the mouse, choose Copy Here as Values Only from the menu that appears.Īdditional Details: If you usually paste by using the right-click menu, you will see that the right-click menu includes icons for Paste, Paste Values, Paste Formulas, Transpose, Paste Formats, and Create Links. If you prefer to use the mouse, try this amazing trick: hold down the shift key while you drag the border of a selection. So, if you are a keyboard person, you might find yourself doing the following:įor keyboard-centric people, this is a pretty fast way to convert formulas to values. For example, you could click the first icon in the third row to paste as values.įurthermore, if you hover over that icon, you will learn that pressing V is the shortcut key for pasting values. #EXCEL 2010 KEYBOARD SHORTCUT FOR PASTE VALUES SERIES#When you press Ctrl again, you see a series of icons that let you change the type of paste that you just performed. In Excel 2010, the little Clipboard icon also indicates that you can open the dropdown by pressing the Ctrl key one more time. Press Ctrl after doing a paste to open this menu.This Clipboard has been in Excel for a while, but because I had to grab the mouse to open the dropdown, I never used that menu. As in Excel 2003, a little Clipboard appears on screen. #EXCEL 2010 KEYBOARD SHORTCUT FOR PASTE VALUES PRO#Yes, Paste seems simple enough, but there are myriad Paste Special options, and many people were confused about which elements of the copied cells would get pasted.Įven if you are an absolute pro at using Paste Special, you are going to love the new Paste Options menu because it will let you perform tasks that you perform several times an hour with far fewer keystrokes.ĭo a normal copy and paste. Microsoft took a look at data to see which command is the most frequently undone command. Strategy: The new Paste Options menu could be one of the biggest time savers in your hour-to-hour use of Excel. Problem: What's up with the paste command? What do all of those icons mean?
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |