Back to lesson
1. 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
2. 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
3. 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 all the little + icons
Go to the Data tab and choose Ungroup > Clear Outline
Click the 3 in the outline
Back to the top
© 2017 GoSkills Ltd.
Skills for career advancement