Page 119 - Ms Excel Note and Workbook

MICROSOFT EXCEL NOTE AND WORKBOOK

Freezing rows and columns

You may want to see certain rows or columns all the time in your worksheet, especially header cells.
By freezing rows or columns in place, you'll be able to scroll through your content while continuing

to view the frozen cells. In this example, we've frozen the top two rows, which allows us to view the
dates no matter where we scroll in the spreadsheet.

Sorting Data

You can quickly reorganize a worksheet by sorting your data. Content can be sorted alphabetically,
numerically, and in many other ways. For example, you could organize a list of contact information
by last name.

110 | P a g e