Web Analytics

EXCEL: CREATING CUSTOM LISTS

The AutoFill feature in Excel can be used with lists to simplify data entry. For example, enter “Monday” in a cell: Then pull the fill handle down to fill in the days of the week: Excel uses “lists” with the AutoFill feature.  The lists that are built into Excel are the names of days and […]

EXCEL: HIDE AND UNHIDE

Large worksheets in Microsoft Excel pose a challenge in their display, printing, and sharing of information.  To work with the data on screen requires scrolling in both directions, printing either spans multiple pages or reduces the font to an unreadable size, and there could be underlying data that is not appropriate to be shared with […]