Blog

Tip of the Week: How to Freeze Excel Rows and Columns

b2ap3_thumbnail_microsoft_excel_400.jpgModern office workers spend lots of time entering data and crunching numbers with Microsoft Excel. Therefore, it’s essential that Excel users know how to best navigate a spreadsheet. One of the best ways to make Excel easier to use is by freezing its rows and columns.

It may be a pain point for Excel users to view a spreadsheet that’s larger than their screen. It can be annoying to try and scroll up, down, or sideways, only to have a crucial piece of information that you want to reference scroll off screen. The best way to prevent this is to freeze a needed row or column into place so that it doesn’t move while you scroll through your spreadsheet. Here’s how you do it:

The first thing you’ll do is select the cell that’s in the first column and row that you don’t want to be frozen. Next, go to the View tab and click Freeze Panes. A drop down menu will appear. From here, click on the first option, Freeze Panes.

freeze columns

This will freeze multiple rows and columns in place, which means that they’ll stay in place and visible when you scroll. With your selected rows and columns now frozen, test this out by scrolling sideways, up, and down on your spreadsheet.

When you’re ready to unfreeze your rows and columns, simply select any row or column and then go to the View tab. Now go to Freeze Panes > Unfreeze Panes.

unfreeze columns

By freezing columns and rows, you’ll find Excel to be easier to navigate. Check back with White Mountain IT Services’s blog every week for more time-saving tips.

Related Articles

  • Tip of the Week: 3 Ways to a Faster Boot Time Your time is valuable, so you don’t have time to waste on waiting for your Windows operating system to boot up. In the interest of saving time, today’s tip will go over three ways to speed up your Windows 10 boot time. Of course, you should always check with IT to make sure it is okay before you ...
  • What You Need to Know About the Growing FinTech Market Money needs to move in order for the economy to work. Traditionally, banks are the major lending institutions, and as a result have to adhere to a myriad of regulations. To provide an equitable system that people aren’t afraid to utilize, there are a lot of checks and balances that have put in place...
  • 4 Internal Threats Every Business Owner Should Understand In light of all the data leaks and vulnerabilities that have been brought to light over the past few years, network security has to be a priority for every business. One problem many organizations have is that while they are protecting their network and infrastructure from threats outside their comp...
  • Tip of the Week: How to Spot a Scam What would you do if you sat down at your desk one morning, coffee still kicking in, to discover a pop-up message on your computer announcing that Microsoft has detected a fatal issue with your workstation, and if they aren’t allowed to remote in and fix it, the entire network could be at risk? Woul...
  • Tip of the Week: Evaluating and Assessing Risk Whenever you decide to implement something in your information technology strategy, you accept some level of risk. Understanding and managing this risk is crucial to your business’ success. For this week’s tip, we’ll review how to manage your IT risks and what your options are. Understanding IT R...
  • IoT Security is a Key Business Concern The Internet of Things is everywhere, which means that potential security risks are also everywhere. Your business needs to take the risks presented by the IoT into account and prepare accordingly. What are You Willing to Risk?When devising a policy for your company concerning the IoT, you need t...
With the surge in the number of small and medium businesses that have fallen prey to malware and cyber criminals, there is a lot of focus of what an organization can do to prevent being a victim and how the company should handle themselves after an attack. There is another key factor to preventing cyber criminals from penetrating into your network:...

- Onsite Service Coverage Area -

Onsite Computer Support Services are available to businesses within 100 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 and Portsmouth NH area.

 

603-889-0800

White Mountain IT Services
33 Main Street Suite 302
Nashua, New Hampshire 03064

 

 padlock1  Cyber Security Toolkit

cloud desktop2 Cloud Desktop Login

Open Positions