After I create formulas in Excel, sometimes I want to lock in the results of those formulas, so I use the Paste Values command. For example, I might use the RAND function to create a set of random numbers. After creating them, I don't want them to change every time the sheet calculates. Here's how I'd use the Ribbon commands to replace formulas with values. • Select the cells that contain the formulas • On the Ribbon's Home tab, click the Copy command • On the Ribbon's Home tab, click the lower half of the Paste command, to open the list of options • Click Paste Values The steps are similar in earlier versions of Excel, but the commands are on the Standard toolbar, and the arrow is to the right of the Paste button. Ithmb viewer windows 10. Use a Shortcut Menu An even quicker way to paste values is by using a mouse shortcut: • Point to the border of the selected range, and the pointer should change to a four-headed arrow. • Press the right mouse button, and drag the cells slightly to the right. Fun free multiplayer games for mac and pc play.

• Keep pressing the right mouse button, and drag the cells back to their original location. • Release the right mouse button and a shortcut menu will appear. • Click on Copy Here as Values Only. The formulas are replaced by the values of their results.

Re: COPY/ PASTE VALUE keyboard shortcut If you press together cmd + shift + v you paste date without formatting (for mac users) and ctr + shift + v (for windows users). I didn't know this trick for a long time but it is really useful!

See the Steps In a Video This technique is a bit tough to explain, so if the written explanation didn't make sense, here's a very short video. Your browser can't show this frame. Here is a link to the page ____________________ Author Posted on Categories. I can't decide which is quicker: 1) Pressing CTRL+C, then move the mouse up to the paste icon in the toolbar, click the down arrow next to it, then click Values, -OR- 2) Pressing CTRL+C, then right-click the selected area, click Paste Special, click the Values radio button, then click OK. Moving the mouse all the way to the top toolbar seems to take too much time compared to using the Paste Special window that's next to my selected data.

You can tell I don't like moving the pointer all over the screen to do a paste values. Still, love the tips! If you use the mouse, then putting PasteValues on the right-click menu works well, (you can miss out the 'wiggle'). You can run the VBA code once and it stays in your menu.

(I don't know if this will work for Excel2007, it works in my Excel2000). I also have PasteSpecial and PasteFormats on that menu, but I can't remember the button IDs. Sub AddPasteValues() Application.CommandBars('Cell').Controls.Add Type:=msoControlButton, ID _:=370, Before:=5 Application.CommandBars('Row').Controls.Add Type:=msoControlButton, ID _:=370, Before:=5 Application.CommandBars('Column').Controls.Add Type:=msoControlButton, ID _:=370, Before:=5 End Sub I found this tip in a comment from 'James' on DDoE.