ADM-201 dump PMP dumps pdf SSCP exam materials CBAP exam sample questions

如何在Excel中用快捷键打开菜单 – 译学馆
未登录,请登录后再发表信息
最新评论 (0)
播放视频

如何在Excel中用快捷键打开菜单

Excel Keyboard Shortcuts to Convert Numbers to Text, Ignore Errors, and Paste Values

欢迎来到excel校园
Welcome to Excel Campus.
我的名字叫乔恩
My name’s Jon, and
在这个视频中 我要告诉你一些有用的键盘快捷键
in this video I’m gonna show you some useful keyboard shortcuts
将文本格式转为为数字格式
for converting text to numbers,
忽略错误
ignoring errors,
选择性粘贴 比如粘贴数值
and paste options such as paste values.
所有这些键盘快捷键
All of these keyboard shortcuts
都是以键盘上的菜单按键作为核心
are centered around the Menu Key on the keyboard.
通常这个菜单键位于
Typically the Menu Key is located
Alt与Ctrl键之间
between the “Alt” and “Ctrl” keys
在键盘的右侧
on the right side of the keyboard.
如果你的键盘没有菜单键
If your keyboard does not have the Menu Key,
你也可以用Shift+F10
you can also use “Shift+F10” as an option.
在第一个例子中
So in this first example,
我将要教你们把数字存储从文本型转为数字型的快捷键
I’m gonna show you the shortcut to convert a number stored as text to a number.
这个单元格包含一个存储为文本的数字
So this cell here contains a number that is stored as text.
你会注意到当这个单元格被选中的时候
And you’ll notice when that cell selected that
这个小错误提示框出现在单元格的左侧
this small Error Box appears on the left side of the cell,
点击这个错误提示框 将出现这个菜单
and clicking on that Error Box will bring up this menu
里面有将文本转化为数字的选项
that will allow you to convert that text to numbers.
但是 我们想用快捷键来实现它
But we wanna…eh access this menu with keyboard shortcut.
这个键盘快捷键是“Alt + Menu Key”
And that keyboard shortcut is “Alt” + the “Menu Key”.
所以我先按下Alt
So I’m gonna hold down the Alt key
接着按下菜单键
and then press the Menu Key.
你会发现这个菜单出现了
You’ll notice that that menu appears,
按下菜单中带有下划线的字母
and these uh…underlined letters
就可以执行这个动作了
in the menu will allow you to perform that action.
所以按下Alt + Menu Key + C
So “Alt” + the “Menu Key” + the letter “C”
这就是将文本转化为数字的快捷键
is the keyboard shortcut to convert text to numbers.
我要关掉菜单
So I’ll click off that menu
现在我按下 Alt+Menu Key+”C”
and now I’m gonna press Alt+ Menu Key+ the letter “C”,
你会看到这个单元格已经被转换成数字格式了
and you’ll see that the cell has been converted to numbers.
同样的 你可以同时对多个单元格执行这个操作
And you can also do that with a range of cells
如果你选择了多个单元格
if you select multiple cells,
你会看见出现在左侧的错误提示框
and you’ll see that Error Box appears on the left side there.
我按下 Alt+Menu Key+C
I’m gonna hold Alt, Menu Key+ C,
这些数字会 额 这些单元格会被转换成数字格式
and those… numbers will be… uh those cells will be converted to numbers.
所以这是一个将你的文本转换成数字的快速方法
So that’s a really quick way to convert your text to numbers.
我们同样可以用Alt + Menu Key键盘快捷键
So we can use the same “Alt+ Menu Key” keyboard shortcut
来忽略单元格中的错误
to ignore the errors in the cells.
在这个例子中 我有一批单元格
In this case I have a range of cells
在左上角都显示有绿色小箭头
that all have that small green arrow in the top left corner.
有时如果你有一份报告或其他的需要展示
And sometimes if you have a report or something you wanna publish,
你想要消除…… 你知道就是没有箭头在那儿
you wanna get rid of…you know there’s not an arrow there,
如果你想要消除这些绿色箭头
but you wanna get rid of those green arrows,
你只需要选中这些带有箭头的单元格
you can simply select all the cells that contain the arrows,
然后用Alt + Menu Key
and use Alt+ Menu Key.
这时我们可以用快捷键字母”I”
And this time we can use the shortcut letter “I”
来忽略错误
to ignore the error.
所以我再次选中所有单元格
So again if I just select all the cells,
按下Alt Menu Key 然后字母”I”
Alt, Menu Key and then the letter “I”,
就能很快忽略错误并除去
that’ll quickly ignore the error and get rid of
所有单元格左上角的绿色小箭头
all those small green arrows in the top-left corners of the cells.
“Alt + Menu Key”这个快捷键还可以用于选择性粘贴
The “Alt+ Menu Key” shortcut also works for the paste options.
现在我要复制这个单元格
So here I’m going to copy the cell,
并粘贴到下面的单元格
and paste it in the cell below.
你会注意到当我粘贴时 这个菜单
And you’ll notice that when I paste uh…this menu
会出现在这里
pops up over here
有所有的粘贴选项
with all of our paste options.
这里你可以粘贴函数公式
So here you can paste Formulas.
你可以粘贴数值
You can paste Values.
有很多不同的粘贴选项
There is a bunch of different options for pasting.
额 你可以用
Uh…and you can use the…
Alt + Menu Key
“Alt+Menu Key” to
来打开这个菜单 然后按下任一选项末尾的
access that menu and then press any one of the letters
字母来执行这个操作
at the end of the option there to perform that action.
现在我们在Excel 2010中
Now starting in Excel 2010,
你还可以用Ctrl键来打开菜单
you can also access this menu using the “Ctrl” key.
这可能是打开菜单最快的方式了
That’s really probably the fastest way to access this menu.
所以一旦你粘贴好了 你可以接着再按下Ctrl
So once you’ve pasted it, you can then press the “Ctrl” again,
然后再按下其中一个字母
and then press one of these letters
比如”V”来粘贴数值
like “V” to paste values.
就可以把数值粘贴在单元格里了
And that’ll paste the values in that cell.
在Excel 2007中
In Excel 2007,
这个菜单不能通过
that menu is not accessible
“Ctrl”键来打开
by the “Ctrl” key.
所以 如果你正在使用Excel 2007
So if you have…if you’re using Excel 2007,
我在这里复制粘贴 你会注意到
I’m gonna copy and paste here and you’ll notice that
这个小的选择性粘贴菜单出现了
again you get this little paste options menu over here,
但是你不能通过按”Ctrl”键来打开
but you can not press the “Ctrl” key to access it.
不过你可以用Alt + Menu Key
However you can use “Alt” + the “Menu Key”
来打开菜单 然后
to access that, and then
在这里 你会看到所有粘贴选项
from there, you’ll get all kinds of options for…
所有的粘贴选项
all kinds of paste options.
所以你可以
So you could…
按下Alt + Menu Key + V来粘贴数值
paste values by basically pressing “Alt” + the “Menu Key” + “V”.
所以有一些快捷键需要使用菜单键
So there are some quick keyboard shortcuts using the Menu Key.
如果你的键盘上没有菜单键
Again if you don’t have the Menu Key on the keyboard,
你可以用shift + F10
you can use “Shift+F10”.
所以这个快捷键就是Alt + shift +F10
So this keyboard shortcut will be “Alt+ Shift+ F10”
来访问菜单
to access those menus.
视频下方有一个链接
There’s a link below the video
在那里你可以查看更多相关技术信息
where you can read more about this technique.
请订阅我们的免费电子邮件简报
And please subscribe to our free email newsletter
在excelcampus.com获取更多这样有用的技巧
at excelcampus.com to get more great tips like this.
谢谢你们
Thank you.

发表评论

译制信息
视频概述

介绍了一些Excel快捷键,打开菜单的快捷键

听录译者

小也

翻译译者

769032218

审核员

Y

视频来源

https://www.youtube.com/watch?v=wXHVIksBgyI

相关推荐