Advanced Spreadsheet Modification under free online training of advanced excel training courses in Rawalpindi

Once you have created a basic spreadsheet there are numerous things you can do to make working with you data easier. Some of these elements are hiding, freezing and splitting rows. You can also sort and filter data, these features are quite helpful when working with a large amount of data. Technical Data used in the field explained in advanced excel training courses in Rawalpindi.

Hide or Display Rows and Columns

You can hide a row or column by using the Hide command or when you change its row height or column width to 0 (zero). You can display either again by using the Unhide command. Some more details of advanced excel training courses in Rawalpindi  are as under.

You can either unhide specific rows and columns, or you can unhide all hidden rows and columns at the same time. The first row or column of the worksheet is tricky to unhide, but it can be done.

1. Select the rows or columns that you want to hide.
2. On the Home tab, in the Cells group, click Format.
3. Under Visibility, point to Hide & Unhide, and then click Hide

Rows or Hide Columns.

You can also right-click a row or column (or a selection of multiple rows or columns), and then click Hide.

Unhide Rows or Columns

1. Select the rows, columns or entire sheet to unhide.
2. On the Home tab, in the Cells group, click Format.
3. Under Visibility, point to Hide & Unhide, and then click Unhide

Rows or Unhide Columns. TIP You can also right-click the selection of visible rows and columns surrounding the hidden rows and columns, and then click Unhide.

Freezing/Splitting Rows and Columns

To keep an area of a worksheet visible while you scroll to another area of the worksheet, you can either lock specific rows or columns in one area by freezing panes.

Freezing vs. splitting

When you freeze panes, Microsoft Excel keeps specific rows or columns visible when you scroll in the worksheet. For example, if the first row in your spreadsheet contains labels, you might freeze that row to make sure that the column labels remain visible as you scroll down in your spreadsheet. A solid line indicates that the row is frozen to keep column labels in place when you scroll.

When you split panes, Excel creates either two or four separate worksheet areas that you can scroll within, while rows or columns in the non-scrolled area remain visible. This worksheet has been split into four areas. Notice that each area contains a separate view of the same data. Splitting panes is useful when you want to see different parts of a large spreadsheet at the same time. TSK Training for Skills and Knowledge is the best institute in Rawalpindi Islamabad for Pakistani Students who wants to join advanced excel training courses in Rawalpindi.