Join Dennis Taylor for an in-depth discussion in this video Repeating title creation and suppression, part of Excel 2010: Tips, Tricks, and Shortcuts.
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 ideas.…If we could some how select just the cells in here that don't have data,…
Author
Released
8/12/2010- Creating charts with keyboard shortcuts
- Converting formulas to values by dragging
- Repeating Undo and Redo actions
- Displaying formulas instantly
- Navigating quickly through worksheets and across workbooks
- Formatting numeric, and date/time data in a flash with keystroke shortcuts
- Inserting dates or times instantly
- Grouping rows or columns to create collapsible regions
- Building data-entry shortcuts with Auto-fill
- Displaying unique items from large lists
Skill Level Intermediate
Duration
Views
Q: Where can I learn more about Excel formulas?
A: Discover more on this topic by visiting Excel formulas on lynda.com.
Related Courses
-
Excel 2010: Advanced Formatting Techniques
with Dennis Taylor3h 2m Intermediate -
Excel 2010: Charts
with Dennis Taylor3h 38m Intermediate -
Excel 2010: Macros
with Dennis Taylor2h 44m Intermediate
-
Introduction
-
Welcome1m 16s
-
-
1. Top Ten Shortcuts
-
Print Preview1m 7s
-
Instant date or time entry1m 16s
-
Undo/Redo/Repeat3m 19s
-
Zooming in and out quickly2m 10s
-
2. Ribbon and Quick Access Toolbar Tips
-
Keyboard command access2m 22s
-
3. Display Shortcuts
-
4. Navigation Shortcuts
-
Navigation shortcuts2m 30s
-
Navigating within worksheets5m 13s
-
-
5. Selection Shortcuts
-
6. Data Entry and Editing Shortcuts
-
Accelerating data entry6m 27s
-
Custom lists for rapid entry5m 54s
-
Cell editing tips2m 19s
-
-
7. Drag-and-Drop Techniques
-
Copy/Move acceleration tips3m 27s
-
-
8. Formula Shortcuts
-
Rapid formula creation3m 48s
-
AutoSum shortcuts2m 57s
-
Rounding shortcuts5m 14s
-
Generating random numbers3m 16s
-
Counting unique entries3m 11s
-
-
9. Operational Shortcuts
-
Controlling rows and columns5m 50s
-
Realigning imported text2m 27s
-
Handling blank cells4m 20s
-
-
10. Formatting Shortcuts
-
Formatting numbers6m 49s
-
Aligning data3m 49s
-
Creating custom formats6m 23s
-
-
11. Database Techniques
-
Sorting shortcuts2m 40s
-
Cleaning up spaces4m 47s
-
Identifying duplicates6m 10s
-
Splitting columns3m 57s
-
Ensuring unique entries2m 46s
-
-
12. Charting and Visual Object Tips
-
Placing and adjusting charts2m 37s
-
-
Conclusion
-
Goodbye9s
-
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.
CancelTake notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Repeating title creation and suppression