To hold row and column titles in place so that they do not scroll when you scroll a worksheet click the

a) Unfreeze panes command on the Insert Menu
b) Freeze panes command on the View Menu
c) Hold the titles command on the Data Menu
d) Split command on the window menu
e) None of above

Check Answer

b) Freeze panes command on the View Menu is the correct answer. This allows you to keep certain rows or columns visible as you scroll through the rest of the worksheet. To use this feature, you need to select the cell below the rows and to the right of the columns that you want to keep visible, and then click the Freeze Panes option in the View menu.
We will be happy to hear your thoughts

Leave a reply

Exact Study
Logo