How to Freeze Rows and Columns in Excel


When you’re working with a lot of spreadsheet data on your laptop, keeping track of everything can be difficult. It’s one thing to compare one or two rows of information when dealing with a small subset of data, but when a dozen rows are involved, things get unwieldy. And we haven’t even started talking about columns yet. When your spreadsheets become unmanageable, there’s only one solution: freeze the rows and columns.

Freezing rows and columns in Excel makes navigating your spreadsheet much easier. When done correctly, the chosen panes are locked in place; this means those specific rows are always visible, no matter how far you scroll down. More often than not, you’ll only freeze a couple of rows or a column, but Excel doesn’t limit how many of either you can freeze, which can come in handy for larger sheets.



Source link

We will be happy to hear your thoughts

Leave a reply

TECH DEVIL
Logo
Enable registration in settings - general
Compare items
  • Total (0)
Compare
0
Shopping cart