Delayed Nyse  -  05/20 04:00:01 pm EDT
333.54 USD   -1.65%
05/20HUBSPOT : How to Write a Respectable Resignation Letter
05/19INSIDER SELL : Hubspot
05/18INSIDER BUY : Hubspot
SummaryMost relevantAll NewsAnalyst Reco.Other languagesPress ReleasesOfficial PublicationsSector news

HubSpot : The Quick & Easy Guide To Freezing Rows in Excel

01/21/2022 | 07:13am EDT

Without freezing rows or columns in your Excel spreadsheet, everything moves when you scroll through the page, as shown in the gif below.

This can be frustrating if you can't always see key data markers that explain what data is what, like column headers or row titles.

As with many things on Excel, there are tricks that help you make your spreadsheets easier to read, like the freeze function. In this post, learn how to freeze rows and columns in Excel to ensure that, when you scroll around, you'll always be able to view the key data points that matter most.

How to Freeze a Top Row in Excel

The image below is the sample data set I'll use to run through the explanations in this piece.

1. To freeze the top row in an Excel spreadsheet, navigate to the header toolbar and select View, as shown in the image below.

2. When the View menu options appear, Click Freeze Top Row, outlined in red in the image below.

Once selected, everything in the top row of your Excel spreadsheet (row 1) will be frozen, and you can scroll up and down in your spreadsheet, but the top rows won't move, as shown in the gif below.

How to Freeze a Specific Row in Excel

While excel has native functions for freezing the top row of a data set and the first column of a data set, there are additional steps to take to freeze other elements of your data set that aren't those two things.

1. To freeze a specific row in Excel, select the row number immediately underneath the one you want frozen. For this example, I'm selecting row number three to freeze row number two.

2. After selecting your row, navigate to View in the header toolbar and select Freeze Panes.

Once selected, you'll be able to scroll up and down through your spreadsheet and always see row two.

Note that using the Freeze Panes function to freeze rows also freezes every row above the row you initially selected. For example, in the gif below, I selected row five which also freeze rows four, three, two, and one.

How to Freeze the First Column in Excel

1. To freeze the first column of your Excel spreadsheet (column A), navigate to the Excel header toolbar, select View, and click Freeze First Column.

Once selected, you'll be able to scroll side to side within your sheet, and the first column of your data set will always be visible, as shown in the image below.

How to Freeze a Specific Column in Excel

1. If you want to freeze a specific column in excel, select the column letter that is immediately next to the column you want frozen and click Freeze Panes in the View header menu.

Once selected, you can scroll side to side through your entire data set and continue to see those columns. In the gif below, I've frozen columns A and B.

Using the freeze function in Excel makes your spreadsheets easier to understand, as you can ensure that critical rows and columns are always visible as you scroll through your data.

Originally published Jan 21, 2022 7:00:00 AM, updated January 21 2022


Don't forget to share this post!


HubSpot Inc. published this content on 21 January 2022 and is solely responsible for the information contained therein. Distributed by Public, unedited and unaltered, on 21 January 2022 12:12:05 UTC.

© Publicnow 2022
All news about HUBSPOT, INC.
05/20HUBSPOT : How to Write a Respectable Resignation Letter
05/19INSIDER SELL : Hubspot
05/18INSIDER BUY : Hubspot
05/17HubSpot Announces Participation in Upcoming Financial Conferences
05/17Articulate Marketing named a Q1 winner in HubSpot's 2022 Impact Awards
05/06UBS Adjusts HubSpot Price Target to $390 From $410, Maintains Neutral Rating
05/06Goldman Sachs Adjusts Price Target for HubSpot to $617 From $723, Maintains Buy Rating
05/06JPMorgan Adjusts Price Target for HubSpot to $550 From $675, Maintains Overweight Rati..
05/06Morgan Stanley Adjusts Price Target for HubSpot to $539 From $645, Maintains Overweigh..
05/06Needham Adjusts HubSpot's Price Target to $500 From $700, Reiterates Buy Rating
More news
Analyst Recommendations on HUBSPOT, INC.
More recommendations
Financials (USD)
Sales 2022 1 728 M - -
Net income 2022 -106 M - -
Net cash 2022 997 M - -
P/E ratio 2022 -151x
Yield 2022 -
Capitalization 15 933 M 15 933 M -
EV / Sales 2022 8,65x
EV / Sales 2023 6,64x
Nbr of Employees 6 404
Free-Float 94,8%
Duration : Period :
HubSpot, Inc. Technical Analysis Chart | MarketScreener
Full-screen chart
Technical analysis trends HUBSPOT, INC.
Short TermMid-TermLong Term
Income Statement Evolution
Mean consensus BUY
Number of Analysts 25
Last Close Price 333,54 $
Average target price 535,04 $
Spread / Average Target 60,4%
EPS Revisions
Managers and Directors
Yamini Rangan Chief Executive Officer & Director
Kathryn Bueker Chief Financial Officer & Accounting Officer
Brian Patrick Halligan Executive Chairman
Dharmesh Shah Director & Chief Technology Officer
Ronald Scott Gill Independent Director
Sector and Competitors
1st jan.Capi. (M$)
HUBSPOT, INC.-49.40%15 933
SAP SE-26.33%113 632
SERVICENOW INC.-33.29%86 805