How to show hidden rows and columns in Excel

Recently, the editor has received a lot of private messages in the background. Many friends have come to this site to ask the editor how to unhidden rows and columns in excel. In order to help everyone, the editor has collected relevant information online and finally found excel. The details of how to display the hidden list with one click are in the article below. If you need it, please come to this site to have a look.

#How to unhide rows and columns in excel?

The specific steps are as follows:

1. Click the gray triangle in Excel, find the gray triangle in the upper left corner, click it to select the entire table;

##2. Click Format to select the table, find the Format button in the start ribbon, and click to expand its drop-down menu;

3. Click to hide and unhide in the expanded menu In the drop-down menu, find the Hide and Unhide button and click it;

4. Unhide content In the drop-down menu, click Unhide rows or Unhide column, you can Unhide content in the current table with one click.

#5. To unhide the table, click the Unhide Worksheet option.

#6. Click OK in the dialog box to cancel the hidden table below with one click.

The above is the detailed content of How to show hidden rows and columns in Excel. For more information, please follow other related articles on the PHP Chinese website!