excel 复制粘贴技巧
How long is your attention span? It's a short work week, so let's start it off with a couple of quick Excel tips. And when I say "Quick," I mean, "Don't blink, or you'll miss them."
您的注意力跨度多长时间? 这是一个短暂的工作周,所以让我们从几个快速的Excel技巧开始。 当我说“快速”时,我的意思是“不要眨眼,否则您会想念它们的。”
I recorded a few quick Excel tips, and posted them in the Excel Quick Tips playlist on my Contextures YouTube channel. If you can't sit still through a lengthy 2 minute video, this might be the solution!
我记录了一些快速的Excel技巧,并将它们发布到了我的Contextures YouTube频道上的“ Excel快速技巧”播放列表中。 如果您无法通过冗长的2分钟视频静下来,这可能是解决方案!
选择一个随机名称 (Select a Random Name)
The first video shows you how to select a random name from a list. Enter the RAND function in the column adjacent to the list of name.
第一个视频向您展示了如何从列表中选择一个随机名称。 在名称列表旁边的列中输入RAND函数。
Then, sort the column with the RAND function, and the name at the top is the winner.
然后,使用RAND函数对列进行排序,最上面的名称是获胜者。
This is the same technique that I used to select winners in my Excel Summer Giveaway and Excel Fall Giveaway contests.
这与在Excel夏季赠品和Excel秋季赠品竞赛中选择获奖者时使用的技术相同。
You can see the RAND function being used in the Excel random name draw video.
您可以看到Excel随机名称绘制视频中正在使用RAND函数。
将公式粘贴为值 (Paste Formulas as Values)
In the second video, you can see how to use the mouse to copy cells that contain formulas, and paste the results as values.
在第二个视频中,您可以看到如何使用鼠标复制包含公式的单元格并将结果粘贴为值。
If that was too quick for you, there's a longer version of this video that shows the Paste Values in Excel with a Mouse Shortcut technique. _____________
翻译自: https://contexturesblog.com/archives/2009/12/21/quick-excel-tips-paste-values-and-sort/
excel 复制粘贴技巧