+5 votes
68 views
in Office by (242k points)
reopened
Excel: hide row

1 Answer

+3 votes
by (1.6m points)
 
Best answer

Hide lines

We'll show you how you can easily show and hide rows in Excel..

image image

In order to increase the clarity in Microsoft Excel, you can hide lines and of course show them again later. We'll show you how you can easily do both. By the way: Here you can find out how you can hide columns in Excel.

Hide lines

To hide a row in Excel, you have to click on a cell in this row. Then simply use the key combination [Ctrl] + [9] . So you have hidden the cell. On the left side within the cell numbering you can still see hidden rows.

By the way: You can show the lines again with almost the same key combination. Just press [Ctrl] + [Shift] + [9] .

image

...