If you want to freeze only the top row or just the left-hand column, go for one of the other options – ‘Freeze Top Row’ or ‘Freeze First Column’. Once you’ve marked the selected cell, click on the tab ‘View’, then go the section ‘Window’ and select ‘Freeze Panes’. The header along with the column with employees’ names will get ‘locked’ in their position on the screen, so you’ll see them all the time, no matter how far into the spreadsheet you scroll. The marking works in the way that all rows above as well as all columns to the left of the marked cell will freeze. It’s the first row and the first column here in our table, and that’s why we click on the cell B2. Let’s scroll back now and see how we can freeze cells.įirst thing, we’ll click on a cell which marks the rows and columns we want to freeze. That’s why we’ve got the function ‘freeze rows/columns’ – to get a clear overview of the information in the table. This way, it might get very hard not to get lost in data. For example, now we cannot see the names of employees anymore. If you keep scrolling down, you might notice that the header – in this case the months – disappears.Īlso, if you scroll across to the right, columns to the left might get out of sight, too. Let’s say you work in a spreadsheet such as this one. Especially with tables containing lots and lots of data. Freezing rows and columns in Excel is an amazingly handy thing.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |