When you work with a large Excel worksheet, it's often difficult to remember exactly what kind of data, columns or rows contain once you begin scrolling around the sheet. Then apply the keyboard shortcut CTRL + A to select all the cells in the dataset. For this, we have to select any cell in the dataset first. There is another interesting method to freeze the header in Excel by inserting the whole dataset in a Table. ![]() ![]() ![]() 760How do I freeze/fix column or row headings in Excel? Freeze Header in Excel Using Table Method.
0 Comments
Leave a Reply. |