Blog

Tip of the Week: Freezing Panes in Your Excel Spreadsheets

Tip of the Week: Freezing Panes in Your Excel Spreadsheets

Microsoft Excel is a great tool for keeping data and figures organized…until, that is, you need to scroll down at all, leaving some important headers out of sight. Fortunately, there is a way to keep your headings in view: freezing the panes they are present in. Let’s go over how to do so.

Let’s say you were working with the following data, outlining the departments each of your employees are a part of, along with when they were first hired and their current pay rate.

As you scroll down this list, you might find it useful to have a reminder of what each column is describing—and this only becomes more the case as your spreadsheets grow larger and more complicated. Luckily for us, Excel makes it easy to have certain data remain on screen.

How to Freeze Panes in Excel

Freezing a pane simply means that you’re telling Excel to keep that data visible as you scroll, and again, it’s laughably easy to do.

First, select the row immediately below or the column immediately to the right of the data you want frozen. In our example, since we want to keep Row 1 in sight, we’d select Row 2.

With the appropriate row or column (in this example, row) selected, you’ll next access the View tab in the ribbon and select Freeze Panes. You’ll then be presented with three options: Freeze Panes, Freeze Top Row, or Freeze First Column.

For our purposes, we’ll be selecting Freeze Panes (although Freeze Top Row would also work in this context). Once you’ve done so, you can then scroll freely, with your top row remaining in sight.

And just like that, you have continued access to critical context for your data! What else would you like to know how to do with your essential business software? Reach out to us at 603-889-0800 and let us know, or to learn more about how we can generally make your IT maintenance a non-issue for your business.

Related Posts

Social media can be remarkably overstimulating, and for some users this is a problem which is difficult to navigate without giving it up entirely. If you want a nice middle-ground to terminating your account entirely, you can instead curate your news...
If you have ever invested time and effort into an Excel spreadsheet, then you know how irritating it is to move all of that data to a different sheet. Thankfully, you can easily and accurately copy this data using a simple technique. Here’s how you c...
One of the big advantages that Mac computers have had over the traditional PC is that they “don’t get viruses,” but how true is this claim, really? Research conducted by Elastic Security Labs proves that this is certainly not the case, discrediting t...
How often have you been browsing the web on your phone, only to find something that would be legitimately useful for your work—maybe it was a tip you wanted to try out, or a bit of information that would be helpful to know—so you wanted to be able to...
Have you ever found yourself in a position where you wanted to download an email from your inbox? Whether it’s documentation or a different reason, there is a way to download your messages into a PDF. PDFs make for great file-sharing formats, as the ...
If you want to optimize productivity, then you’ll want to take a look at the startup page for your Google Chrome web browser. If you change this setting, you can shave off countless minutes every week while you fumble around trying to find your favor...
How often do you receive emails from someone written in another language? We bet the answer is “not often,” but you never know when being able to translate an email might come in handy—especially if you ever do business overseas. Let’s go over the bu...

In what seems to be the final stage of a plan that Microsoft has been inching towards for years, Microsoft Office will apparently be phased fully into the Microsoft 365 brand. Let’s consider what we know so far about this change.

When working in your browser, we know how efficiency is extremely important. Like many other pieces of software the developers at Google have baked some keyboard shortcuts to make getting around their browser easier for the average user. Let’s take a...
Artificially-intelligent image generation has become a hot topic in recent weeks and months. Not too long ago, an artist created a stir for winning a competition with an image that he largely created using an artificially-intelligent tool. Now, Micro...
It’s a great feeling, being able to download something, but also being able to download it as a PDF file. In cases where you want to save something as a PDF rather than its original image or web page file, you can do so relatively easily in order to ...
If you use Android mobile devices, then you’ll know that updating your device is routine maintenance to keep it safe from threats and security breaches. Not only that, but updating your device can resolve various bugs which impact functionality. Let’...

Onsite Service Coverage Area

Although we provide remote services and support to businesses in over 20 states, onsite services are limited to within reasonable driving distance from our offices in NH.  We will manage a local vendor for locations outside of our service area to provide onsite assistance when needed.

 

Onsite Computer Support Services are available to businesses within 60 miles of Nashua New Hampshire. We have excellent onsite coverage from Concord NH, south through Manchester NH, and then down into Boston. From Northern and Central Mass, we cover from Worcester, east to the North Shore, including the Salem NH and Portsmouth NH area.

White Mountain IT Services

 


33 Main St, Suite 302
Nashua, NH 03064

 


121 Riverfront Drive
Manchester, NH 03102

 

Client Help Desk      603-889-2210

New Client Inquiries   603-889-0800

Open Positions