fbpx

EZ MSP Blog

EZ MSP has been serving the New York area since 2008, providing IT Support such as technical helpdesk support, computer support and consulting to small and medium-sized businesses.

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 EZ MSP’s blog every week for more time-saving tips.

Hackers Shop for Vulnerabilities at Online Black M...
Time to Go Mobile: 3 Mobile Device Tethering Optio...

Contact Us

Learn more about what EZ MSP
can do for your business.

EZ MSP
7 Odell Plaza Suite 134
Yonkers, New York 10701

Connect With Us

Facebook logo  Twitter logo  Linkedin logo  RSS feed

Latest Blog

Social media is constantly evolving, and if the big social networks had it their way, it would be the only place people go when they log onto the Internet. Whether you have strong feelings for or against social media, or perhaps you are ind...