Back to lesson
1. What do Excel’s Outlining Tools do?
Draw borders around data.
Allow you to group and compress spreadsheet sections via easy to use controls
Hide rows and columns from users
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?
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
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?
Go to the Data tab and choose Ungroup > Clear Outline
Click the 3 in the outline
Click all the little + icons
Back to the top
© 2017 GoSkills Ltd.
Skills for career advancement