Repeating title creation and suppression


show more Repeating title creation and suppression provides you with in-depth training on Business. Taught by Dennis Taylor as part of the Excel 2010 Power Shortcuts show less
please wait ...

Repeating title creation and suppression

The data in this worksheet appears to have been set up for printing purposes. Rather than repeating the department name over and over and over again in column A, we only see it referenced once at the beginning of the department. So by implication, these people here are in the ADC department, these people in the Admin Training department and so on. And it's potentially a huge list. And it is easier on the eyes when we are working with this data on the printed page. Now as it turns out we are going to be adding more data eventually here.

And the problem is if we sort the data. Suppose we put in a new column that's salary or building or something like that and we sort the data. We will not be able to sort the data by department again because these are blank. What we'd like to do now is to fill this in. Now this could be somewhat tedious and it could be thousands of rows. It's going to take a while. So pulling together a variety of tips at once, let's talk about a couple of ...

Repeating title creation and suppression
Video duration: 6m 17s 3h 43m Intermediate

Viewers:

Repeating title creation and suppression provides you with in-depth training on Business. Taught by Dennis Taylor as part of the Excel 2010 Power Shortcuts

Subject:
Business
Software:
Excel
Author:
please wait ...