MS Excel provides a diligent tool that lets you freeze the panes of your document such they do not scroll and remain on the viewable area at any time. Then what is the significance of headers if you cannot have them throughout? Well, you can and that’s what we are going to tell you today.īut before we move on let us have a look at my example set of data (left image) and how the headers hide out when I scroll my sheet (right image). If you notice closely you will see that the headers scroll away as you scroll the document (down or left). However, there is one flaw with doing just this much. ![]() Our intention behind creating headers is that we (and the people we share our sheet with) may easily understand the data matrix and the data within it. ![]() Whenever we create Excel sheets we usually give a name to every column and sometimes, to rows too.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |