Search for courses or lessons
Redeem a coupon
Start free trial
What do Excel’s Outlining Tools do?
Allow spreadsheet sections to be grouped and compressed via easy-to-use controls
Hide rows and columns from users
Draw borders around data
Suppose cells B24:B25 are grouped so they can be compressed to show the value in B26. When expanded, B26 has a top and bottom border on the cell. When compressed the top border disappears, but the bottom one doesn’t. Where are these borders applied?
B25 and B26 both have bottom borders only
Both the top and bottom border are applied on B26
B25 has a top border and B27 has a top border
Suppose rows 4:9 are grouped, as are rows 10:32, 12:17, 18:24 and 25:31. Which is the best method to show all the data rows?
Click all the little + icons
Click the 3 in the outline
Go to the Data tab and choose Ungroup and then Clear Outline
Back to the top
© 2019 GoSkills Ltd.
Skills for career advancement