How do rows or columns of Excel worksheets appear

How do rows or columns of Excel worksheets appear

In this article, the Office Assistant's small series continues to tell you how to hide and display the rows or columns of an Excel worksheet. First of all, it must be explained that the method of hiding rows and columns in Excel is almost identical, in this tutorial, to hide the behavior examples.

Hide Rows

1. Drag the mouse to select the line number that you want to hide rows (can be one row or multiple lines), switch to the Cells group on the Start tab, and then in the Format Drop-down menu, select hidden rows in hide and unhide.

2, now, the 3rd line is hidden, the effect is as follows. But if you want to show hidden lines, what do you need to do?

Show rows

1. Drag the mouse to select the top and bottom rows that contain the rows you want to display, and then on the Start tab, find Unhide rows and click OK.

2, the hidden 3rd line is displayed, is it amazing?

Tip: In addition to the two methods mentioned above, there are more simple methods, detailed steps see the following figure.