excel粘贴无格式快捷键_Excel的粘贴值快捷方式

excel粘贴无格式快捷键

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.

在Excel中创建公式后，有时我想锁定这些公式的结果，因此我使用“粘贴值”命令。 例如，我可能使用RAND函数创建一组随机数。 创建它们之后，我不希望它们在每次计算表时都进行更改。

Here's how I'd use the Ribbon commands to replace formulas with values.

这是我将使用功能区命令将公式替换为值的方法。

1. Select the cells that contain the formulas
   选择包含公式的单元格
2. On the Ribbon's Home tab, click the Copy command
   在功能区的“主页”选项卡上，单击“复制”命令
3. On the Ribbon's Home tab, click the lower half of the Paste command, to open the list of options
   在功能区的“主页”选项卡上，单击“粘贴”命令的下半部分，以打开选项列表
4. 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.

步骤与早期版本的Excel中的步骤类似，但是命令在“标准”工具栏上，并且箭头位于“粘贴”按钮的右侧。

使用快捷菜单 (Use a Shortcut Menu)

An even quicker way to paste values is by using a mouse shortcut:

粘贴值的更快方法是使用鼠标快捷键：

1. Point to the border of the selected range, and the pointer should change to a four-headed arrow.
   指向所选范围的边界，并且指针应更改为四头箭头。

2. Press the right mouse button, and drag the cells slightly to the right.

   按鼠标右键，然后将单元格稍微向右拖动。

   
3. Keep pressing the right mouse button, and drag the cells back to their original location.
   继续按下鼠标右键，然后将单元格拖回其原始位置。
4. Release the right mouse button and a shortcut menu will appear.
   释放鼠标右键，将出现一个快捷菜单。
5. Click on Copy Here as Values Only.
   单击“仅在此处复制为值”。

The formulas are replaced by the values of their results.

公式将替换为其结果的值。

观看视频中的步骤 (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.

这项技术很难解释，所以如果书面解释没有意义，那么这是一段很短的视频。

演示地址

翻译自: https://contexturesblog.com/archives/2009/02/04/paste-values-shortcut-for-excel/

excel粘贴无格式快捷键