Note: The other languages of the website are Google-translated. Back to English
登陆  \/ 
x
or
x
注册  \/ 
x

or

在Excel中轻松读取/查看大量行和列

如果您在工作表中包含包含数百行和数百列的海量数据,则在检查数据并将它们从一个跳到另一个时会很容易感到困惑,这会浪费时间。 为了解决此问题,Kutools for Excel的Reading Layout实用工具突出显示了跨行和跨栏,以使活动单元格或范围突出,如下图所示。 演示

镜头阅读版式2

Office选项卡在Office中启用选项卡式编辑和浏览,并使您的工作更加轻松...
Kutools for Excel解决了您的大多数问题,并使您的生产率提高了80%
  • 重用任何东西: 将最常用或最复杂的公式,图表等添加到您的收藏夹中,并在将来快速重用它们。
  • 超过20种文字功能: 从文本字符串中提取数字; 提取或删除部分文字; 将数字和货币转换为英文单词。
  • 合并工具:将多个工作簿和工作表合二为一; 合并多个单元格/行/列,而不会丢失数据; 合并重复的行和总和。
  • 分割工具:根据价值将数据分割成多个工作表; 一本工作簿可转换为多个Excel,PDF或CSV文件; 一列到多列。
  • 跳过粘贴 隐藏/过滤的行; 计数与求和 按背景色; 向多个收件人批量发送个性化电子邮件。
  • 超级过滤器: 创建高级过滤方案并应用于任何工作表; 排序 按星期,日期,频率等 滤波器 用粗体,公式,注释...
  • 超过300种强大的功能; 适用于Office 2007-2019和365; 支持所有语言; 在您的企业或组织中轻松部署。

启用阅读布局实用程序

单击 库工具 > 阅读版式 要启用此实用程序,在启用“阅读布局”时,突出显示该选项卡。
镜头阅读版式2


阅读版式设置

如果要更改形状,样式,颜色或透明度等设置,则可以转到 阅读版面设置对话框更改。

单击 库工具 标签,然后单击旁边的箭头 阅读版式 展开下拉菜单,然后单击 阅读版式设置.
镜头阅读版式2

阅读版式设置 对话框中,您可以根据需要更改形状,样式,颜色和透明度,也可以同时预览 预览 部分,然后再应用更改。
镜头阅读版式2

关于我们 突出显示活动单元格区域 以及 突出显示单元格编辑区域 选项​​。

突出显示活动单元格区域 选项,活动单元格或范围将突出显示。

镜头阅读版式2

打钩 突出显示活动单元格区域 选项,但勾选 突出显示单元格编辑区域 选项,活动单元格或范围将不突出显示,但溢出区域突出显示。

镜头阅读版式2

取消勾选两个 突出显示活动单元格区域 以及 突出显示单元格编辑区域 选项,活动单元格或范围以及溢出区域均不会突出显示。

镜头阅读版式2

启用阅读布局:在设置后勾选此选项,然后单击 Ok,阅读版式将自动启用。

默认设置:单击此按钮,“阅读版式”的设置已恢复为默认设置 库工具.


备注:

1.您可以通过单击 阅读版式 命令,选项卡将变为浅灰色。

2.如果您打开多个Excel文件,则此 阅读版式 功能适用于所有这些。

3。 此 阅读版式 下次启动工作簿时不会自动启用。

阅读版式演示


Kutools for Excel 包括适用于Excel的300多种便捷工具,可以在30天之内免费试用。 立即下载并免费试用!

    生产力工具推荐
    以下工具可以极大地节省您的时间和金钱,哪一种适合您?
    Office Tab: 在办公室中使用方便的选项卡,作为Chrome,Firefox和New Internet Explorer的方式。
    Kutools for Excel: 超过300种Excel高级功能 2019、2016、2013、2010、2007和Office 365。
    Classic Menu for Office: 将熟悉的菜单带回Office 2007、2010、2013、2016、2019和365,就好像是Office 2000和2003。

    Kutools for Excel

    上述功能只是Kutools for Excel的300个强大功能之一。

    专为Excel(Office)2019、2016、2013、2010、2007和Office 365设计。免费下载和使用60天。

    Kutools for Excel的屏幕截图

    btn了解更多      btn下载     btn购买

Say something here...
symbols left.
You are guest
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.
  • To post as a guest, your comment is unpublished.
    sophiajordan135 · 2 months ago
    Have you heard about the ongoing Toronto property sale?

    https://dalemundi.com/ontario/toronto/41-broadleaf-rd/

    With exquisite views and a friendly neighbourhood find homes for sale in Toronto, ON. Browse homes, apartments in Toronto property sales to find a place and call it home. You can see different listings for various commercial properties by visiting Dalemundi.com. For any questions, send an email to dalemundi@realestatehut.com
  • To post as a guest, your comment is unpublished.
    clarkmegan135 · 2 months ago
    Where We Get Complete List Of Commercial Real Estate in Toronto

    https://dalemundi.com/

    For commercial purposes, Toronto has a good location and properties available at a reasonable price range. So, if you're thinking of buying any commercial real estate property in your favourite Toronto, visit Dalemundi.com. 
  • To post as a guest, your comment is unpublished.
    purohitbhavesh742 · 3 months ago
    Hey, Its Nice Post thanks for sharing this with us 
  • To post as a guest, your comment is unpublished.
    TractorGuru · 7 months ago
    Hello, Thanks for sharing this informative blog with us.
  • To post as a guest, your comment is unpublished.
    simon@netready.biz · 10 months ago
    This feature is great. Bear in mind I had an existing Excel file where this button was ALWAYS disabled. I had to copy-and-paste the data out of the file and save it into a new file to get the "Reading Layout" button to enable. It then worked fine.
  • To post as a guest, your comment is unpublished.
    Lindomar · 2 years ago
    se eu compra a licença consigo instalar mais de uma vez no pc ou só serve uma vez ?
  • To post as a guest, your comment is unpublished.
    Andrew · 3 years ago
    This solved one of my biggest headaches. I have one program that outputs a report that when exported to Excell it creates 200 worksheets! I have never been able to use it until now. Merging all of them into one worksheet only takes a few minutes with Kutools.
  • To post as a guest, your comment is unpublished.
    Arun · 4 years ago
    Thanks A lot of this product, mainly its use for reading layout & shortcuts of left side menu
  • To post as a guest, your comment is unpublished.
    Rodger A Sanders · 4 years ago
    My OS: Windows 7 Pro fully updated
    My Excel: 2010
    My sheet: Range R1C6:R504C6 is in use

    PROBLEM: READING LAYOUT FAILS TO FILL ROW AND COLUMN SELECTED

    1. Magnification: 60%
    2. Rows 313-355 show
    3. Cell R354:C6 selected
    4. Column 5 fills to row 323. Row 354 no fill
    5. Mag to 50%
    6. Rows 311-357 show
    7. Column 5 fills top to bottom. Row 354 fills left to right
    8. Mag to 60%. Goto 4.
    9. Mag to 70%.
    10. Rows 319-354 show
    11. Column 6 fills to row 325. Row 354 is empty.
    12. Click R354:C6
    13. No change!
    14. WHY?

    NOTE: At 60% magnification selecting any cell on visible sheet on rows greater than 323 demonstrates same problem.
    Selecting row 323 or lower i.e R320 the function works as expected with row and column selected but only to
    row 323!
  • To post as a guest, your comment is unpublished.
    John · 6 years ago
    Hi.
    Thank you for a good product.
    I am using reading layout at the moment but it only highlights in some parts of the spreadsheet. If I move the cursor further the highlights disappear.

    I am using Windows 8.1 and Office 2013.
    Also I am filtering the spreadsheet to look at certain rows.

    Thank you for your assistance with this.

    I am entering data in another program and need the highlight option.