![]() ![]() This is especially useful to keep track of what each column represents. First, it allows you to keep important data visible at the top of your spreadsheet while you scroll down. There are a few benefits to freezing rows in Excel. If you have a large spreadsheet in Excel, you can freeze the top rows of your document to make working with your data so much easier. Voila! If you try to scroll down your spreadsheet, you will find that the top two rows are now frozen in place and will stay at the top of your document. Select Freeze Panes from the drop-down menu. Select the third row, immediately below the two rows you wish to freeze in place.Ĥ. ![]() If you find yourself needing to freeze the top two rows of your spreadsheet so they stay in place while you scroll through your document, simply follow these steps:ġ. ![]() Let’s take a look at the topic in a little more detail below. To freeze the top two rows in Microsoft Excel, highlight the third row and go to the View tab where you will click the Freeze Panes option and choose Freeze Panes. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |