Search for courses or lessons
Redeem a coupon
Start free trial
What do Excel’s Outlining Tools do?
Draw borders around data.
Hide rows and columns from users
Allow you to group and compress spreadsheet sections via easy to use controls
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?
Both the top and bottom border are applied on B26
B25 and B26 both have bottom borders only.
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
Go to the Data tab and choose Ungroup > Clear Outline
Click all the little + icons
Back to the top
© 2019 GoSkills Ltd.
Skills for career advancement