From the course: Excel Tips Weekly

Unlock this course with a free trial

Join today to access over 22,400 courses taught by industry experts.

Restoring missing column titles

Restoring missing column titles - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Restoring missing column titles

- [Instructor] In this worksheet, recurring titles, 2 for example, in cells A3 to A6, 3 have been eliminated, also in A8 down here, 4 probably done for visual reasons, 5 both for viewing on the screen. 6 Also, when this is printed on paper, 7 it's easier to read this way than it would be. 8 The problem is if we leave it like this 9 and we sort the data, suppose I sort this by employee name, 10 I'm going to click in column B, 11 go to the Data tab, choose AZ. 12 The names are now in order alphabetically, 13 but which department is James Abbott in, Robert Acosta? 14 We don't know necessarily, 15 and based on what we had seen before, 16 would we assume that all these people here are 17 in audit services? 18 Well, not really, because we've got an alphabetized list 19 of names to the right of them. 20 So obviously we've got a problem here. 21 Let's undo, first of all, Control + Z, 22 go back to this display. 23 The next…

Contents