Search for courses or lessons
Redeem a coupon
Start free trial
What do Excel’s Outlining Tools do?
Allow you to group and compress spreadsheet sections via easy to use controls
Hide rows and columns from users
Draw borders around data.
Assume that B24:B25 are grouped so that when you can compress them 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 the 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
Assuming that rows 10:12 are grouped, that rows 20:40 are grouped, and rows 25:30 are also grouped, what is the best way to show all the data rows?
Click the 3 in the outline
Click all the little + icons
Go to the Data tab and choose Ungroup > Clear Outline
Back to the top
© 2020 GoSkills Ltd.
Skills for career advancement