That means that every cell above it and to the left of it will be frozen. Freeze Rows AND Columns at the Same Timeġ.Select the first cell that you want to be unfrozen. If you want to freeze rows AND columns at the same time, follow the steps below. If you want to freeze the top row or first column, just go to View> Freeze Panes, and then click on either Freeze Top Row or Freeze First Column. A good solution to this is to freeze columns, rows, or both so that they stay displayed on your screen while you scroll through the rest of your data. It is particularly aggravating when several columns or rows of data are similar, so you have to keep jumping back to the header to remember what you are viewing. Working with a large set of data in Microsoft Excel can be tricky.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |