Back to lesson
1. You want to freeze the first three rows and first three columns of a worksheet. Which cell should you be in before selecting ‘Freeze Panes’ from the ‘View’ tab of the Ribbon?
2. It is suggested that a hyperlink should actually be situated in merged cells if the text extends beyond the cell width. Why?
Hyperlinks often change cell formatting and require merged cells in order to be displayed correctly
It is easier to select the cell with the keyboard
This will ensure that the hyperlink will activate no matter where you click on the text
3. Which of the following statements is correct?
Freeze panes will freeze what is below and to the right of the selected cell(s)
The black lines which appear after the ‘freeze pane’ option has been selected indicate where the window has been locked
Freezing panes are useful when a worksheet has a heading and data that is not visible on another work sheet
Back to the top
© 2017 GoSkills Ltd.
Skills for career advancement