![]() The formulas are replaced by the values of their results. Release the right mouse button and a shortcut menu will appear.Keep pressing the right mouse button, and drag the cells back to their original location. ![]() Press the right mouse button, and drag the cells slightly to the right.Point to the border of the selected range, and the pointer should change to a four-headed arrow.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.Īn even quicker way to paste values is by using a mouse shortcut: On the Ribbon’s Home tab, click the lower half of the Paste command, to open the list of options.On the Ribbon’s Home tab, click the Copy command.Select the cells that contain the formulas.Here’s how I’d use the Ribbon commands to replace formulas with values. After creating them, I don’t want them to change every time the sheet calculates. For example, I might use the RAND function to create a set of random numbers. ![]() ![]() After I create formulas in Excel, sometimes I want to lock in the results of those formulas, so I use the Paste Values command. ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |