When you have a large table or database,
and you wish to keep the headings visible, it is an easy matter to Freeze the Panes so you never lose sight of
your titles or captions.
This practice is particularly helpful
not only to a user who is doing data entry, but also anyone who is reviewing a
worksheet. To
keep the headings on the screen, simply:
1.
Click the Row Number which
corresponds to the row immediately beneath
the column headings
2.
Select View – Freeze Panes - Freeze Panes
Conversely,
if you have information that you wish to keep visible in your left-most
column, simply:
1.
Click the Column Letter which
corresponds to the column immediately to the right of the column you with to keep in view
2.
Select View – Freeze Panes - Freeze Panes
That is all there is to it! To restore a
frozen worksheet, select any cell on
your worksheet and go to: View – Freeze
Panes – Unfreeze Panes
You can now scroll your data whenever you wish and still see the headings. Now, that’s Cold…
You can now scroll your data whenever you wish and still see the headings. Now, that’s Cold…
No comments:
Post a Comment