提示:其他语言是Google翻译的。 你可以访问 English 版本。
登录
x
or
x
x
注册账户
x

or

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

您的工作表中可能会有很多行和列,并且您很难在如此庞大的工作表中检查公式或数据。 但是 Kutools for Excel阅读布局 实用程序,通过突出显示活动单元格的行和列,可以更轻松地检查数据,如下所示:

Reanding布局演示

Excel生产力工具

Office Tab:为Office(包括Excel)带来强大的标签,就像Chrome,Safari,Firefox和Internet Explorer一样。 节省您一半的时间,并为您减少数千次鼠标点击。 30天无限免费试用

Kutools for Excel:节省70%的时间并为您解决80%Excel问题。 300 +为1500 +工作场景设计的高级功能,使Excel更加轻松,并立即提高工作效率。 60天无限免费试用


如何突出显示活动单元格的行和列:

您可以在工作表中选择一个单元格或一系列单元格,然后单击 Kutools > 阅读 布局 > 阅读布局 启用此功能 阅读布局 效用。 直观地突出显示所选单元的整个列和行。 查看截图:

镜头阅读布局1
-1
拍摄读,view3
  • 启用阅读布局:点击此选项启用或禁用 阅读布局.
  • 阅读布局设置:点击这个选项来配置的设置 阅读布局阅读布局设置 对话框。 看截图:

镜头阅读布局2


备注:

  • 1。 您可以通过点击取消该实用程序 阅读布局 命令。
  • 2。 如果你打开多个Excel文件,这个 阅读布局 功能适用于所有这些功能。
  • 3。 此 阅读布局 下次启动工作簿时将不会自动启用。
  • 4。 选中或取消选中突出显示活动单元格的区域以突出显示或凹陷

生产力推荐工具
以下工具可以大大节省您的时间和金钱,哪一个适合您?
Office Tab: 在您的Office中使用方便的选项卡,作为Chrome,Firefox和新Internet Explorer的方式。
Kutools for Excel: Excel的300高级函数 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天。

Excel的Kutools屏幕截图

BTN阅读更多 BTN下载 btn购买

Say something here...
symbols left.
You are guest ( Sign Up? )
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.
    Andrew · 9 months 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 · 1 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 · 1 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 · 4 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.