课程章节
培训 · 课程 14. 电子表格 · 第 14.3 章,共 5 章
14.3 表格、查找和视图 2:17
将区域设置为表格,查找和替换文本,并保存命名视图而不改变单元格。
演示 Holarch 2.35。
您将学到
- 将区域设置为命名表格,并在公式中使用
- 一步在整个工作簿中查找和替换文本
- 打开筛选按钮并对列排序
- 保存命名视图并在视图之间切换
整理 EO-1 质量预算:将子系统行设置为带名称、镶边行和筛选按钮的表格,用“查找和替换”在各处重命名一个子系统,然后在与项目共享的命名视图中按质量对表格排序,并切换回“默认”视图,它仍按存储的样子显示单元格。
练习
在 Holarch 中基于 CubeSat EO-1 亲自完成此操作。
- 打开本章的起始文件,或第 14.2 章中的工作簿。
- 选择 A2:E8,单击 表格,命名为
Subsystems,然后单击 确定。 - 打开 查找和替换,查找
Comms,打开替换字段,输入Communications,单击 全部查找,然后单击 全部替换。 - 单击表格内部,打开 排序和筛选,打开 筛选按钮。在 With contingency 上选择 按 Z 到 A 排序。
- 单击 保存视图,命名为
Heaviest first,选择 有访问权限的所有人 并保存。在 默认 和 Heaviest first 之间切换。
当表格命名为 Subsystems、Comms 显示为 Communications,且 Heaviest first 视图对行排序而“默认”按原顺序显示行时,即完成练习。
自测
- 公式如何引用表格 Subsystems 的 Mass 列?
- 在视图中排序会改变单元格吗?
- 除排序和筛选外,视图还保留什么?
显示答案
公式如何引用表格 Subsystems 的 Mass 列?
写作 Subsystems[Mass]:表格名称加方括号中的列名。
在视图中排序会改变单元格吗?
不会。视图只改变您查看工作表的方式;切换回“默认”会按原顺序显示行。
除排序和筛选外,视图还保留什么?
隐藏的列、列宽和冻结窗格。
延伸阅读
文字稿
显示文字稿 (旁白和屏幕内容)
Introduction
Chapter three: tables, find and views. A table gives a block of rows a name and a style. Find and Replace changes text in one step. And views show the same cells in different ways.
In this chapter you organize the budget.
Tables
Select the headings and the six subsystems, A2 to E8, and click Table.
On screen: Name Box A2:E8 → Table.
The dialog shows the range, and that the first row holds the headers. Name the table Subsystems, and click OK.
On screen: Range A2:E8, headers; name Subsystems → OK.
The table has a styled header row and banded rows, and grows when you add a row below it. Its name works in formulas: Subsystems, with a column name in square brackets.
On screen: The table: header style, banded rows.
Find and Replace
One subsystem is abbreviated. Open Find and Replace. Find Comms, open the replace field, and type Communications.
On screen: Find ▾ → Comms; ⇄ → Communications.
Find All lists each match with its sheet and cell. Click Replace All: the name is changed everywhere it appears, in one undo step. Close the bar.
On screen: Find All → the results; Replace All → close.
Named views
Now a view. Views change how you see the sheet, never the cells. Click in the table, open Sort and Filter, and turn on Filter Buttons.
On screen: B3 → Sort & Filter ▾ → Filter Buttons.
Click the filter button on With contingency, and choose Sort Z to A: the heaviest subsystem comes first.
On screen: With contingency ▾ → Sort Z to A.
The views bar shows the unsaved change. Click Save View, name it Heaviest first, choose Everyone with access, and save it.
On screen: Save View → Heaviest first, Everyone with access → Save View.
A view keeps sort, filters, hidden columns, widths and frozen panes. Click Default: the rows are back in their order, because the cells never changed. Everyone with access can switch views without affecting anyone else.
On screen: Default → rows in order; Heaviest first.
Recap
To recap: format rows as a named table, use Find and Replace for changes in many cells, and save sorts and filters as views.
In the next chapter, you chart the budget and feed it from the model.