![]() ![]() 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. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |