Login 

Call Us Now:

Weston Technology Solutions Blog

  • Home
    Home This is where you can find all the blog posts throughout the site.
  • Categories
    Categories Displays a list of categories from this blog.
  • Tags
    Tags Displays a list of tags that have been used in the blog.
  • Archives
    Archives Contains a list of blog posts that were created previously.
Recent blog posts

Tech Tip: Freezing Rows and Columns in Excel

Posted by on in How To

If you are working on large spreadsheets, it can be very easy to get lost and forget what a certain row or column is being used for. It can be extremely handy to freeze certain rows or columns so that they won’t move when you’re scrolling through the rest of the spreadsheet. Here’s how you can go about doing this.

Excel lets you freeze things in one of three ways:

  • You can freeze the topmost row.
  • You can freeze the leftmost column.
  • You can freeze multiple rows or multiple columns (or both) to have those visible all the time.

So here’s how you do it.

Freeze the Top Row

If you want to get the top row to stay put, it’s pretty straight forward. Click on the “View” tab, click on “Freeze Panes” and then “Freeze Top Row.”

excelfreeze1

Now when you scroll up and down, the top row stays put.

If you want to reverse that, go back to the “View” menu, click on “Freeze Panes” again and select “Unfreeze Panes” to get things flowing back to normal.

Freezing the First Column

Sometimes the left column has info that you want visible at all times. This is very straight-forward as well.

Go back to the “View” tab, select “Freeze Panes” and then select “Freeze First Column.”

excelfreeze2

As before, to get things back unfrozen, go back and select “Unfreeze Panes” again.

Freeze Other Groups and Rows

The above two options work in a perfect world, but sometime the data you need visible on screen all the time isn’t the top row or first column. In some case, you want to freeze multiple rows or columns (or even both).

To freeze several rows, click on the row number below the bottom-most row that you want to freeze. So if you want rows 1-4 to freeze, click on row 5 (the number to the left of the row) to select the entire row:

excelfreeze3

Now head back up to the view menu, select “Freeze Panes” and select “Freeze Panes.”

excelfreeze4

As you scroll down the sheet, the top several rows will remain frozen and there will be a gray line that will show where the edge of the frozen panes.

To freeze a handful of columns instead, click the column to the right of the columns you want frozen, and freeze the panes again. So if we want columns A through D to stay visible, we select column E and then freeze the panes line before:

excelfreeze5

Freezing Columns and Rows

You can freeze groups of row or a groups of columns, but did you know you can freeze multiple rows and columns at the same time?

Say we wanted to freeze the left three columns (A-C) and the top three rows (1-3) so they’d be visible as we scroll through the spreadsheet. To do this, select the upper-left-most cell that you don’t want to freeze. In this case, that would be cell D4. Click once on cell D4, and then head up to the View à Freeze Panes à Freeze Panes menu as before, and you can now scroll around the spreadsheet and those rows and columns will remain visible. 

Tagged in: Microsoft Office365 Tips

Office 2007 Support Ends Soon

Posted by on in Alerts

Office 2007If you use Office 2007, you’ll want to upgrade your Office suite as Microsoft is ending support for the suite in October. What that means is that no security updates or patches will be released for the suite after that date.

If you’re using Outlook 2007 and Office 365 for email and calendars, you’ll have to upgrade your Office Suite because Office 365 will no longer support versions of Outlook older than Outlook 2010 – meaning you won’t be able to check your email unless you log into the Office365 Web Portal.

Because of the security risks involved with running out-of-support software – malware infections being the most obvious – we recommend running supported applications whenever possible (especially apps that are a frequent target of malware writers).

If you rely on Microsoft Office 2007 in your business, talk to us today about migrating your company to Office 365.

Petya Ransomware Outbreak

Posted by on in Alerts

You may have heard about the Petya Ransomware attack that is currently affecting computer users worldwide, hitting at least 65 counties, according to NPR. You can read more about the Petya outbreak at HealthITSecurity, the patched security flaw that is being exploited, the government's CERT alert and the most tragic news: a Cadbury chocolate factory was shut down because of it.

As a Weston CompleteCare client, you have multiple layers of protection in-place to help prevent these types of things from bringing down your environment. These may include:

  • WestonBlock email protection helps prevent viruses, malware, and phishing attempts from reaching your inbox. 
  • Managed Antivirus that is constantly being updated to protect opening these types of files and blocking them if they try to attack.
  • OpenDNS content filtering protects you from accidentally loading an infected web site and prevents these types of files from "phoning home" to activate.
  • WestonShield firewalls help protect against malicious inbound and outbound traffic (and has had protection for variants of Petya starting over a year ago).
  • Managed patching services that make sure security patches to help protect you from these types of infections are installed properly and quickly.
  • A solid backup and business continuity device and plan in-place that protects your local and offsite backed up data and that alerts when backups show sign of malware. 

All that being said, this is yet another reminder to be extremely vigilant about what links you click on and what emails you open. Even if you get an email and attachment from someone that you know, if you were not expecting it, contact that person and make sure it was sent by them. Also avoid browsing to sites you don't recognize or follow links that are unfamiliar.

If you have any questions or are interested in hearing about how CompleteCare can help protect your business, don't hesitate to contact us.

Friday Fun With Wikipedia

Posted by on in Off Topic/Fun

Wikipedia can be a such a time suck if you're easily distracted. Especially when you come across deleted articles with freaky titles. As the title says, a list of Wikipedia articles that actually existed at one point and have been deleted. Such useful classics as “An old dude who lives in Central America” and “Put that cookie down.” Not to be confused with Unusual Articles, which are oddball Wikipedia articles that actually exist, or the list of really, really, really stupid article ideas that you really, really, really should not create. Disclaimer: Since this is Wikipedia, it should be noted that some of the content there is a bit not-safe-for-work. 

Friday Fun with the Beatles

Posted by on in Off Topic/Fun

Sgt PepperWith the newly released 50th Anniversary Sgt. Pepper's Lonely Hearts Club Band box set, you knew this was bound to happen sometime (I’m amazed it’s taken this long): A project has been created to locate the source images used on the Beatles' iconic album cover. They have mostly been found, but there are still a few that cannot be tracked down. 

Tagged in: Paul Is Dead