未登录,请登录后再发表信息
最新评论 (0)
播放视频

两种只复制粘贴可见单元格的快捷方法

Copy & Paste Visible Cells Only in Excel for Windows or Mac

欢迎来到Excel校园
Welcome to Excel Campus.
我叫乔恩 在这个视频里
My name is Jon, and in this video,
我将会教你一个只选中可见单元格的快捷方式
I’m gonna show you a quick shortcut for selecting the visible cells only.
这是什么意思呢
So what do I mean by that?
呃 在这个例子中 表格里有一堆隐藏行
Well, in this example, I have a report with a bunch of hidden rows.
这些行已经在分类汇总中被隐藏折叠了
And these rows have been hidden and collapsed using the subtotal feature.
如果我展开这些组
So if I expand these groups here,
你会看到在总计之间
you’ll see that I have a bunch of detail rows
有一堆详细信息行
between each of the totals.
基本上我要做的就是
And basically what I wanna do
复制这个范围的内容
is I wanna copy this range here,
也就是我在这里所看到的单元格
just these cells that I’m seeing right here.
我要把它们粘贴在工作表中的其他区域
And I wanna paste them to another area in my worksheets.
那么如果我用Ctrl + C复制
If I do that using Ctrl+C,
然后用Ctrl + V粘贴到下面这里
and then paste down here with Ctrl+V,
你会注意到那些隐藏行的详细信息
you will notice that all the detail of those hidden rows
也都被粘贴到下面了
also got pasted down here below.
这可不是我想要的结果
And that’s not what I want.
所以我要在键盘上按Ctrl + Z来撤销掉
So I’m gonna hit Ctrl+Z on the keyboard just to undo that.
我们要做的只是选中
So what we wanna do is just select the visible cells
在屏幕这里看到的可见单元格
that we’re seeing here on the screen,
而不要选中那些隐藏行
and not select any of those hidden rows.
那么第一步就是来到上面选中
So the first step is to go ahead and select the range
我们所想要复制的部分
that we wanna copy.
然后我们就要用到键盘上的快捷键Alt + ;
And then we’re gonna use the keyboard shortcut Alt+;.
那么按住键盘上的Alt键
So I’m gonna hold down the Alt key on the keyboard,
然后按下;键
and then press the semicolon key.
这样就只选中了可见单元格
And that will select the visible cells only.
现在你会看到这个选中范围有点像被切割了一样
So you can now see that this selection has kind of been cut up here,
这样就只选中了可见单元格
and we’re only selecting the visible cells.
在Mac上对应的快捷键是Cmd + Shift + Z
And that keyboard shortcut on the Mac is Cmd+Shift+Z.
所以在Mac上按下Cmd + Shift + Z效果也是一样
So Cmd+Shift+Z on the Mac will do the same thing.
现在按Ctrl + C复制时我们就选中了可见的单元格
And now that we’ve selected the visible cells when I hit Ctrl+C to copy,
你会注意到在我选中的范围内
you’ll notice that the marching ants are now marching around
每个可见单元格四周有”蚂蚁线”正在流动
each of the visible cells here in the range that I selected.
这样你就知道自己只选中了可见单元格
So that lets you know that you’ve only selected the visible cells.
现在我就要来到下面 按下Ctrl + V来粘贴
And when I go down here and I’m gonna press Ctrl+V to paste.
你会看到我们只粘贴了可见单元格
You’ll see that we’ve only pasted the visible cells.
而那些隐藏行没有被粘贴
And all those hidden rows were not pasted with our…our copy.
以上就是单纯复制粘贴
So that’s just a quick way to copy
可见单元格的快捷方法
and paste just the visible cells only.
你也可以把这个命令添加到”快速访问工具栏”里
And you can also add that command to the Quick Access Toolbar.
如果你来到上面的快速访问工具栏
So if you go up here to the Quick Access Toolbar
在菜单中选择”其他命令”
and select More Commands from the menu,
会把你带到……呃 这个窗口
that will bring up …ur this window,
好让你添加快捷按钮到快速访问工具栏里
that allows you to add buttons to the Quick Access Toolbar.
我要做的第一件事是在这个命令菜单里
And so the first thing I’m gonna do is from this commands menu,
选择”所有命令” 因为我想看到所有的命令
I’m gonna choose All Commands, cause I wanna see all the commands.
在这个列表里 我想找到”选定可见单元格”的命令或者说按钮
And we’re looking for the Select Visible Cells command or button in this list,
这个列表真长
and it’s a very long list.
为了跳到下面 我可以按键盘上的S键
So to jump down, I can hit the S key on the keyboard,
会把我带到第一个以S开头的单词
and that’ll get me down at least to where the S is start,
我在找”选定可见单元格” 按钮在这里
and I’m looking for Select Visible Cells in here, and here’s the button right here.
那么我们想要”选定可见单元格”
So we want Select Visible Cells,
我要选中那个 然后点击”添加”来把命令添加到”快速访问工具栏”里
I’m going to select that and click Add to add that over to my Quick Access Toolbar.
再点击”确定”
And then I’ll just click OK.
然后你就能在我的”快速访问工具栏”里看到这个按钮了
And then you’ll see I have this button up here in my Quick Access Toolbar,
这个按钮也有同样的功能
which will do the same thing, and in fact it even shows
事实上当你在按钮上停留时它还能显示键盘上的快捷键Alt + ;
the keyboard shortcut Alt+;right there when you hover over the button.
它的效果也是一样
And that will do the exact same thing,
那么现在如果我简单选中这个范围
so now if I just simply select this range,
点击上面的按钮
and click the button up there,
这样就选中了可见单元格 我再按Ctrl + C
that’ll select those visible cells and I’ll just hit Ctrl+C,
这样你就能看到”蚂蚁线”就知道我们只选中了那些可见单元格
so you can see the marching ants, and see that we’ve only selected those visible cells.
这就是另外一种快捷方式
So that’s another quick little shortcut.
如果你不常用
If you don’t use this very often,
你很可能记不住键盘上的快捷键
and you probably won’t remember that keyboard shortcut,
你就可以在”快速访问工具栏”这里插入那个按钮
you can just plug the button right up there in the Quick Access Toolbar,
只要你乐意 随时调用
and use it whenever you like.
那么以上就是选中可见单元格的快捷窍门
So that’s just a quick tip on how to select visible cells only.
欢迎在视频下方留言提出问题
Please leave a comment below the video with any questions,
并点击视频下方的链接
and also click the link below the video
订阅我的免费邮件简报
to subscribe to my free email newsletter,
我还会送你一份免费赠品来帮你自学Excel
and I also send you a free bonus gift to help you learn Excel.
还有其他很酷的玩意儿
So lots of cool free stuff.
感谢观看 下期再见
Thanks for watching, and I’ll see you soon.

发表评论

译制信息
视频概述

乔恩教你excel,这一视频将教会你只复制粘贴可见单元格,而不复制隐藏行的方法

听录译者

收集自网络

翻译译者

One静茹

审核员

审核员E

视频来源

https://www.youtube.com/watch?v=9k5Zngv_ulE

相关推荐