如何在Excel中设置特殊的默认粘贴特殊功能以仅粘贴值 [英] How do I set the default paste special in excel to paste only values

问题描述

我excel中的一个单元格用作用户输入框...如果用户在此单元格中粘贴了某些内容，则我只希望粘贴值而不是格式.有没有一种方法可以将默认的粘贴选项设置为仅粘贴值?

One of the cells in my excel is used as a user entry box... IF users paste something in this cell I want only the values to be pasted and not the format. Is there a way to set the default of paste option to paste only values?

推荐答案

我使用键盘快捷键来粘贴值.如果您按下 Alt ， E ， S ， V ， Enter ，它将过去价值.(按顺序击键，请不要按住 Alt 键.)

I use a keyboard shortcut to past the values. If you hit Alt, E, S, V, Enter it will past the values. (hit keys in sequence, don't hold down the Alt key.)

Alt ， E ， S 将打开粘贴特殊对话框， V 将选择值，然后按 Enter 即可实现.这对于从excel复制的任何内容都适用.

Alt, E, S will open the paste special dialog box, V will select Values and then Enter will make it happen. This works well for anything copied from excel.

如果要从excel外部复制某些内容，它将为您提供一些特殊的粘贴选项，但 Alt ， E ， S 会带你去那里.

If you are copying something from outside excel, it will give you some different options for paste special, but Alt, E, S will get you there.

如@jeeped所述，另一个选项是您可以在快速访问工具栏上添加一个按钮，然后可以单击它们或使用键盘快捷键.这些项目在快速访问工具栏上编号.假设您具有默认的保存，撤消和重做功能，则添加粘贴值将使您可以按 Alt + 4 (或按 Alt时出现的任何数字))，然后选择该操作.

Another option, as @jeeped mentioned, is you can add a button to your quick access toolbar and then you can either click them, or use a keyboard shortcut for those. The items are numbered on the quick access toolbar. Assuming you have the default save, undo, and redo, adding paste values will allow you to hit Alt+4 (or whatever number comes up when you hit Alt) and select that action.

这篇关于如何在Excel中设置特殊的默认粘贴特殊功能以仅粘贴值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！