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

乔恩表格校园:如何保持列表下拉箭头可见 – 译学馆
未登录,请登录后再发表信息
最新评论 (0)
播放视频

乔恩表格校园:如何保持列表下拉箭头可见

Excel Drop-down List Arrow Always Visible

欢迎来到Excel校园
Welcome to ExcelCampus.
我是乔恩 在这个视频里
My name is Jon, and in this video
我要教你们如何保持下拉列表的下拉箭头可见
I’m gonna show you how to keep the drop-down arrow for a validation list always visible.
那么在这个例子中我这有一个简单的报表
So in this example, I have a simple report here
里面有一些列表筛选的单元格
with a few cells that contain list validation
或者说一个下拉列表
or a drop-down list.
那么基本上 你可以从这个下拉列表选择任何筛选条件
So basically, you can select any state from this drop-down list
基于该单元格链接的一些公式
and the report is gonna refresh or update
报告内容就会刷新更正
based on some formula that are linked to this cell.
问题是 当你点击这个单元格之外的区域时
And the problem is when you when the user clicks off the cell
这个与单元格相邻的下拉图标消失了
that drop-down icon next to that cell disappear.
那么再一次地 如果你选中包含列表的单元格
So again if you select the cell that contains the list,
下拉图标出现在那里
the drop-down icon appears there.
如果你选中这个单元格以外的任意区域 图标就消失了
But if you select anywhere off that cell that list that icon disappears.
然后用户就不一定知道这里有一个可以选择的列表
And then the user doesn’t necessarily know that there’s a list there for them to select from.
所以在这个视频里 我会给你展示一个例子
So in this video, I’m gonna show an example of how to
一个让这个单元格的下拉列表保持可见的方法 就如下面这个单元格一样
a possible solution of how to keep this drop-down list always visible like it is in this cell here,
即便我没有选中这个单元格
even though I don’t have this cell selected.
如果你还没看过这个
And if you haven’t seen it already.
比尔•耶伦有一个关于这个和其他合适技巧的视频
Bill Jelen has a great video on this as well with some other possible techniques
在他的播客”Excel先生”第1816集
in his Mr Excel Podcast No.1816.
我会在视频下方放出链接
And I’ll put a link below this video to that one.
在这个方法中 我让这个单元格
So for this solution I basically have a cell here
包含了一个Wingdings字符
that contains a Wingdings character.
你可以看到 在功能区的主页选项卡下
So you’ll see up here on the Home tab of the ribbon.
我正在使用Windings字体 Windings 3字体
I’m using a Wingdings font Wingdings 3 font.
这个单元格里基本上只包含了一个Windings字符
In this cell it basically contains a Wingdings character.
只是它的显示形式看起来像是个下拉图标
And it’s just formatted to look like the drop-down icon,
我在单元格周围又放了个灰色边框
so I put a gray border around the cell.
并把他的背景颜色和字体颜色
I shaded the background and the font color is that grey color to make it
编辑的像是一个未激活的下拉列表图标一样
look like kind of like a disabled drop-down list icon.
之后当我点击单元格时 真正的下拉列表覆盖在了它上面
Then when I click on the cell the actual drop-down list appears over it,
你可以在这里选择列表选项
and you can choose from the list right here.
那么再一次的 如果你取消选择 你可以看到这里
So again if you click off the cell then you just see that cell contains
包含了Windings字符的单元格
this Wingdings character there.
那么如何插入Windings字符 你只需要选择要插入箭头图标的地方
So to insert that Wingdings character basically just select the cell where you want to put that
找到功能区的插入选项卡
arrow looking icon in there go to the insert tab on the ribbon,
我们找到符号菜单 点开符号选择窗
and we’re gonna go over to the symbols menu, and open symbols here.
现在你可以在符号菜单里看到字体选项下的Windings3字体
And you can see now on the symbols menu I want to choose the Wingdings 3 font
我们往下拉一页
from the font options, and I’m just going to page down one set of symbols here.
就看到了这个字符 字符代码128
And we have this character here which is character code 128.
它看上去和这里下拉列表的选择图标一样
And it just looks like that icon for the drop-down list there,
所以你需要做的就是 将他插入单元格 点击关闭
so all you have to do is Insert that in your cell and hit Close.
我实际上在这里插入了两个图标了 我先删除一个
And I’ve actually inserted two icons there, so I’m gonna delete one,
按回车键 你现在可以看到字符已经被插入了
and hit Enter and you’ll now see the that character code has been inserted there.
如果你不想用符号菜单 你也可以用字符代码Q
If you don’t want to go to that symbols menu can also use the character code Q
或者说字母Q 如果我在这里输入字母Q
or just letter Q, so if I just type the letter Q there.
这里就会显示出这个下拉图标 与之前的非常相似
That’s gonna show that drop-down symbol which looks very similar
如果你想达到完美效果 字符代码128更精确一点
the character code 128. It’s a little more accurate, If you want to get super technical.
看起来也更像下拉列表的图标 不过你用Q也是可以的
It’s looks a little more like the drop-down icon there, but you can also use Q as well.
现在你也注意到了 当我选择d4单元格时
Now you also notice when I select cell d4 here,
这里显示出了一条信息 告诉使用者点击左边的单元格激活下拉列表
this message comes up telling the user to select the cell to the left to active the drop-down menu.
如果他们正在选中别的单元格 想打开这里的下拉列表选项
So if they’re just outside the cell there and they go and probably accidentally click here
他们可能会意外的点到这里
to think they’re goona be able to make a selection.
但除非选中左边的单元格并激活下拉列表
Well they really won’t be able to make a selection until they select this cell
否则是无法打开选项的
and then active that drop-down list.
所以要插入这个 这实际上只是一个输入信息
So to insert this, this is just an input message here
同样也是在数据 有效性下 如果你找到功能区的数据选项卡
also in the data validation, so if you go to the data tab
之后找到有效性
on the ribbon and then go to data validation.
你就可以看到这里 我已经为这个单元格设置了一个输入信息
You could see here that I have an input message for this specific cell.
那么这个输入信息将会在单元格被选中的时候显示
So this input message is gonna show on the cell selected.
这里是显示的信息内容 你可以编辑它
And this is the message that’s goona be displayed and you can edit this if you like.
下一步 当你创建了这个图标之后
So the nice part about this is once you have this created.
我会有一个文件 里面已经为你创建好了图标 你可以直接下载
and I’ll have a file where you can download this and it already be created for you.
你可以把他复制到任何工作簿或者工作表格里
You can just copy it in any workbook or worksheet you like.
那么我把这个单元格复制 放到上面d2单元格里
So if I just copy this cell here then I want to place it up here
我只用按下Ctrl + C 然后 Ctrl + V
in cell D2. I’ll just hit Ctrl+C and Ctrl+V.
现在我在d2单元格里也有一个仿下拉图标了
And now I have my arrow my fake drop-down arrow in cell D2 as well.
那么现在如果我按下Escape 你可以看到这个报告比之前看上去好多了
So now if I hit Escape there, you can see this report looks a little nicer.
使用者可以知道在这个单元格里
and the user will know that there’s drop-down arrow there for them
有个可以展开的下拉列表
or drop-down list for them to select from in these particular cells.
这种方法的一个潜在的缺点是
One possible drawback to this method is that you do have to have a blank column to the right
你必须在目标单元格右侧有一个空白列
of the cell that contains in your list.
在这个例子里 我有一张表格
So in this example here, I have a table
我基本上用了同样的方法实现刚才的效果
and basically to get this to work I’ve done the same applied the same technique
但是在这里我不得不在表格的右侧插入一个空白列
But I had to insert a blank column to the right in my Excel table here,
然后在这里插入Windings字符
and then insert that Wingdings character there.
所以如果你的下拉列表是这样的 这点可能是个限制
So that could be one limitation if you have your dropdowns like this.
在这个例子中 我在A列有一列下拉列表
In this example, I have my drop-down list in column A here.
其中每个单元格都可以选择“True”或者“False”
In each of these cells, It’s just True or False.
但为了放置Windings字符
But I also have that blank column over here to the right
我在右边也列了一个空白列
in order to add that Wingdings character in and it also has to be
宽度大概18像素左右
a width of you know about a little lesser to wider 18 pixels cell.
所以这是一个可能的限制
So that could be one possible limitation.
但对于像这样的报告 如果你在设计时就想到了
But for a report like this, at design time if you kind of think about your
下拉列表菜单右边必须放的空白列
drop-down menus is having a blank column to the right of it,
那么你还是可以想出一些办法来实现它的
you can pretty much figure it out and get it to work.
那么我希望这些能帮到你 再次的 获取更多技巧请查看“Excel先生”的播客
So I hope that’ll help you, again check out that Mr. Excel Podcast for some other techniques
他在那里有许多富有创意的技巧
for this he has some very creative technique in there.
别忘记订阅我的免费邮件通知
And don’t forget to subscribe to my free email newsletter to stay updated
来获取最新窍门和技巧推送 帮助你学习Excel
with tips and tricks and help you learn Excel.
感谢观看 希望你有个美好的一天
Thanks for watching, and I hope you have a great day.

发表评论

译制信息
视频概述

乔恩本次在表格校园中教各位如何保持筛选箭头或列表下拉箭头可见。

听录译者

真皮沙发

翻译译者

null;

审核员

审核员W

视频来源

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

相关推荐