MS Excel : Hide rows by GROUPING AND OUTLINING

MS Excel : Hide rows by GROUPING AND OUTLINING 

You can utilize the Excel grouping and outlining highlight to hide sets of columns and/or rows. For instance, you can hide the subtleties identifying with week by week deals so you can think about month to month deals. Your layouts can incorporate up to eight degrees of detail.

Outlining a lot of rows or columns makes a clickable button on the extreme left or top of your worksheet. The button shows either a minus sign or an or more sign, contingent upon what is shown in the worksheet. Click the minus sign to hide rows or columns, and the in addition to sign to show them once more. Neighboring the button is a strong line that shows, by its length, the estimated number of rows or columns Excel has covered up.

Outlining was designed for use with organized information, for example, records yet can be utilized with any worksheet. When you plot a PivotTable, outlining has a similar impact as it does in some other

worksheet.

Include A GROUP 

1 Click and drag to choose the rows
or columns to hide.
2 Click the Information tab.
3 Click Group in the Layout group.
You can likewise choose the rows or
columns and then press
Shift+Alt+Right Arrow

l The Group dialog box shows up. 

4 Click to choose either the Rows or
the Columns alternative ( changes to ).
Click Rows on the off chance that you need to group rows.
Click Columns on the off chance that you need to group columns.
5 Click alright.

l Excel makes another left or top edge with a minus sign.
6 To hide the rows, click

the minus sign.
The rows vanish, and
an or more sign replaces the
minus sign.
l To show the rows once more, click the in addition to
sign.

Expel A GROUP 

1 Click the Information tab.
2 Click Ungroup.
l The Ungroup dialog box shows up.
3 Click to choose either the Rows or the
Columns alternative ( changes to ).
Click Rows in the event that you need to ungroup rows.
Click Columns in the event that you need to ungroup columns.
4 Click alright.
Excel expels the group

Did You Know? 

You can home frameworks; that is, you can put one group of laid out rows or columns inside another. For instance, inside every year, you can group each month, and inside every month, you can group every week.

Did You Know? 

You can likewise hide rows and columns by clicking and hauling the lines that different the section
letters or the line numbers. Likewise, on the off chance that you click and haul over section letters or column numbers and at that point right-click, a menu shows up. Click Hide to hide the segment or column or Unhide to show covered up columns or rows.