Tuesday Tip: Excel Freeze Panes
by Tony Rushin
I’m continuing on my quest to take a fresh look at Excel – since I’ve been using it for 30+ years – in order to learn new tricks and/or break old habits. I recently took a fresh look at Freezing Panes – when it isn’t the top row or first column.
First of all, here’s where you find the Freeze Panes option:
If you’ve got a wide or long spreadsheet and you’ve done, or inherited, some fancy formatting then the Freeze Top Row or Freeze First Column options may not work for you. For instance, the spreadsheet I was working with the other day was formatted with the first 2 rows merged.
It was a long spreadsheet so I wanted to freeze the headings in the top 2 rows. You accomplish this by placing your cursor in the cell underneath – and/or to the right of – the information you want to freeze. For instance, if you simply want to freeze the top 2 rows, place the cursor in the first column of row 3 like this:
and select Freeze Panes. Now, as you scroll down, the top 2 rows are frozen:
If you want to also freeze the first 2 columns, you place your cursor in the third column of row 3 – to the right of the columns you want to freeze and underneath the rows, you want to freeze – like this:
and select Freeze Panes. Now, as you scroll down and over the top 2 rows – along with the first 2 columns – are frozen:
firstname.lastname@example.org or 404.997.7633
Spending 30 years in high-technology sales & marketing, from IBM to start-ups, Tony brings his broad experience in business development, marketing and IT business strategy to Network 1’s leadership team, clients and partners. His passion is to help people achieve greatness, however, they define it.
Network 1 Consulting is a 21-year-old, IT Support company in Atlanta, GA. We become – or augment – the IT department for law firms, medical practices, and real estate & construction companies. Our IT experts can fix computers, but what our clients value most are the industry-specific best practices we bring to their firms. This is especially important with technology, along with regulations and cyber threats, changing so rapidly. We take a proactive approach to helping our clients use technology to gain and keep their competitive advantage.
Here are three of the most popular Tuesday Tips: