From the course: Miss Excel’s Top Productivity Hacks
Unlock the full course today
Join today to access over 23,100 courses taught by industry experts.
Ctrl + enter: The missing heading magician - Microsoft Excel Tutorial
From the course: Miss Excel’s Top Productivity Hacks
Ctrl + enter: The missing heading magician
(upbeat music) - Let's meet the missing heading magician in Excel and make our cells reappear. So here in column A, as you can see, we have certain headings that are missing. So typically here what we would want is in cells A3 through A5 for it to say Austin, in cells A7 through A9 for it to say Miami, and so on. So we essentially want to copy the title from the cell above it and fill in all those blanks below it with whatever that office city name is. So we could be manually going in here and being like, all right, Austin. I'm going to click the corner, click and drag and copy it down. But that could take a long time if you have this long list. So an alternative for this is I'm going to do control+Z to undo that there. What we can do here is highlight our list in column A, so I'm going to zoom up here using my control and arrow keys up to the top and highlight our office list that has the city names and those blanks that we…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
(Locked)
Meet Flash Fill: The superhero of Excel2m 52s
-
(Locked)
Text to columns: The CSV file connoisseur2m 59s
-
(Locked)
Go To Special: The blank-removing remedy2m 52s
-
(Locked)
The Excel glue stick: &, CONCATENATE, and TEXTJOIN6m 14s
-
(Locked)
LEFT and FIND: The Excel power couple5m 22s
-
(Locked)
Ctrl + enter: The missing heading magician2m 33s
-
(Locked)
-
-
-