LibreOffice 25.2 帮助
Choose
.Choose
.On the
menu of the tab, choose .Text to Columns
Choose
- .On the
menu of the tab, choose .Define Range
Choose
.On the
menu of the tab, choose .Select Range
Choose
.On the
menu of the tab, choose .Sort
Choose
.On the
menu of the tab, choose .Sort Ascending
Choose
.On the
menu of the tab, choose .Sort Descending
选择「数据 - 排序 - 排序条件」选项卡。
向上排序
向下排序
选择「数据 - 自动筛选」。
Choose
.On the
menu of the tab, choose .
自动筛选
CommandCtrl + Shift + L
Choose
.On the
menu of the tab, choose .Advanced Filter
选择「数据 - 更多筛选 - 标准筛选... - 选项」标签。
选择「数据 - 更多筛选 - 高级筛选... - 选项」标签。
选择「数据 - 更多筛选 - 重置筛选」。
On the
menu of the tab, choose .Choose
.On the
menu of the tab, choose .Hide AutoFilter
Choose
.On the
menu of the tab, choose .Subtotals
选择「数据 - 分类汇总 - 第 1 组、第 2 组、第 3 组」选项卡。
On the
menu of the tab, choose tabs.On the
menu of the tab, choose tab.Choose
.On the
menu of the tab, choose .Data Validity
On the
menu of the tab, choose tab.On the
menu of the tab, choose tab.On the
menu of the tab, choose tab.On the
menu of the tab, choose .Choose
.On the
menu of the tab, choose .Consolidate
Choose
.On the
menu of the tab, choose .Show Details
Choose
.On the
menu of the tab, choose .Hide Details
选择「数据 - 组合及分级显示 - 组合」。
Choose
.On the
menu of the tab, choose .
组合
F12
选择「数据 - 组合及分级显示 - 取消组合」。
Choose
.On the
menu of the tab, choose .
取消组合
CommandCtrl + F12
On the
menu of the tab, choose .AutoOutline
On the
menu of the tab, choose .选择「数据 - 组合及分级显示 - 显示细节」(用于某些透视表)。
Choose
.Choose
.Choose
.On the
menu of the tab, choose .Pivot Table
选择「插入 - 透视表」,在「选择数据来源」对话框中选择选项「LibreOffice 中注册的数据源」。
选择「插入 - 透视表」,在「选择数据来源」对话框中选择选项「当前选中的区域」。
选择「插入 - 数据透视表在「选择数据来源」」对话框中选择选项 「LibreOffice 中注册的数据源」,点击「确定」,此时会打开「选择数据源」对话框。
Choose
.On the
menu of the tab, choose .Choose
.Refresh Pivot Table
Choose
.On the
menu of the tab, choose .Choose
.Delete Pivot Table
Choose
.On the
menu of the tab, choose .Refresh Range
Choose
.CommandCtrl + Shift + F9
Choose
.Choose
.On the
menu of the tab, choose .Recalculate
F9
Choose
.Choose
Choose
On the
menu of the tab, choose .Choose
Choose
.On the
menu of the tab, choose .Streams
Choose
.Choose
.XML Source
Choose
.Choose
.On the
menu of the tab, choose .Statistics
Choose
Choose
.On the
menu of the tab, choose .Choose
Choose
.On the
menu of the tab, choose .Choose
Choose
.On the
menu of the tab, choose .Choose
Choose
.On the
menu of the tab, choose .Choose
Choose
.On the
menu of the tab, choose .Choose
Choose
.On the
menu of the tab, choose .Choose
Choose
.On the
menu of the tab, choose .Choose
Choose
.On the
menu of the tab, choose .Choose
Choose
.On the
menu of the tab, choose .Choose
Choose
.On the
menu of the tab, choose .Choose
Choose
.On the
menu of the tab, choose .Choose
.On the
menu of the tab, choose .Choose
Choose
.On the
menu of the tab, choose .