XFER Blog

XFER has been serving the Livonia area since 1994, providing IT Support such as technical helpdesk support, computer support, and consulting to small and medium-sized businesses.

Tip of the Week: Freeze an Excel Row for Easier Spreadsheet Navigation

b2ap3_thumbnail_excel_sheets_400.jpgMany office workers feel like they live in Microsoft Excel, spending hours using spreadsheets to enter data and crunch numbers. By taking advantage of tools like Excel’s freeze feature, workers can make the most of their time by navigating a spreadsheet more efficiently.

Once a spreadsheet grows to be larger than the screen, it can become tricky to navigate. It can be maddening to try and cross-reference a certain row or column on one side of the spreadsheet with another that’s offscreen.

Excel’s freeze feature resolves this pain point by freezing a selected row or column into place, allowing you to scroll off screen while having your needed row or column locked into place. When you think about it, this Excel feature is kind of like a grown-up version of freeze tag.

To freeze a row or column in Excel, 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.

lock panes one

With your selected rows now frozen in place, you will be able to scroll up, down, and sideways in your spreadsheet without having your needed columns or rows move off screen. 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.

lock-panes-two

This is just one of the many Microsoft Office features that make navigating a project easier. Be sure to check back next week for more time-saving technology tips.

Where Hackers Go to Shop for Malware
Don’t Fall for these 4 Smartphone Battery Myths
 

Comments

No comments made yet. Be the first to submit a comment
Guest
Already Registered? Login Here
Guest
Wednesday, February 21 2024

Captcha Image

Mobile? Grab this Article!

QR-Code dieser Seite

Blog Archive

2024
March
April
May
June
July
August
September
October
November
December
2011
January
February
March
April
May
June
July
October
December
2010
January
February
March
April
May
June
July
August
September
October
December

Sign up for our Newsletter!

  • Company Name *
  • First Name *
  • Last Name *