How to freeze a row in Excel

Pin top row and column in Excel in only 2 clicks and learn how to freeze multiple rows in less than 10 seconds!

Learn how to freeze the top row in Excel in only 2 clicks! Apply the same technique to freeze the first column in your worksheet.

If you need to freeze several rows in Excel, check our quick tutorial below!

We will show you how to make several rows and columns always visible, at the same time, using an efficient technique. Stop scrolling up and down or left and right all the time by freezing panes in Excel.

Ready to save time?

To freeze the first row in Excel, click View then Freeze Top Row. That’s it! We told you it could be done in only 2 clicks.

In Excel, freeze the column header by selecting View then Freeze First Column.

Freeze multiple rows or columns in Excel, or a mix of columns and rows in 3 clicks!

If you want to freeze several rows in Excel, select the first row you don’t need to freeze or the first cell below the rows you want to freeze. Check the video on the right to know how to do it!

Freeze multiple columns in Excel by selecting the first column you don’t need to freeze or the first cell to the left of the columns you want to lock. Watch our quick video to learn how to do this!

Freeze top and side panes by selecting the first cell next and under the columns/rows you want to lock. Then click View > Freeze Panes.

Watch how to do it in less than 10 seconds!

Unfreeze panes by clicking View then Unfreeze Panes.

Now, you know how to freeze rows and columns in Excel and how to unfreeze them!

Join our Excel Spreadsheet Course now to learn more handy tips!

Advertising
Analytics

Categories

AllAdvertisingFormatsPlatformsKPI'sAd News

What is O&O Advertising?

Discover one more important jargon term used in Programmatic Advertising: O&O advertising. Get familiar with O&O formats and advantages.

Read More

Best DSPs for Programmatic Advertising

Ted Jordan shares his list of best DSPs for Programmatic Advertising so you don’t have to lose time searching the internet to find the right Demand-Side Platform for your campaigns.

Read More
What is Programmatic Advertising?

What is Programmatic Advertising?

Understand what programmatic advertising is and how it works to increase your ROI and become a programmatic specialist.

Read More
Programmatic Advertising: What is a SSP?

Supply-Side Platforms (SSPs) Explained

SSPs basics in advertising: learn what Supply-Side Platforms are used for and who use them. Get familiar with more programmatic advertising technical terms.

Read More
Programmatic Advertising: What is a DSP?

What are DSPs?

A DSP is a great tool to use but what does DSP stand for in marketing? What are some Demand-Side Platforms examples? Today, we answer your questions!

Read More

Advertising News – 09 June 2024

This week, we'll explore Google's latest algorithm update and it's massive impact on independent websites, the newly passed media Freedom Act in the EU aimed at protecting journalists, and a...

Read More

Categories

AllFunctionsToolsShortcut Keys
Split Semicolon Separated Value in Excel

How to split semicolon separated values in Excel

Split semicolon separated values in Excel into columns and rows, or convert columns to semicolon separated values, like an Excel Master!

Read More

How to change shapes in Excel column charts

Learn how to easily change the columns shape in your Excel charts so your colleagues and customers will remember your impacting graphs.

Read More

How to use the LEFT, RIGHT and MID functions

Learn how to extract text in Excel with the LEFT, RIGHT and MID functions. Plenty of examples to learn from and functions are explained with simple words. If you start...

Read More

Excel IF statement: how to use it for 3 conditions

Learn how to use the Excel IF statement with multiple conditions and combine it with OR and/or AND functions!

Read More
Using Text to Column to Extract texts on Excel

Excel: How to split text into columns

If you need to extract data in Excel, you may want to use the Text to Columns tool. With only 3 steps, it's really easy to split text into columns.

Read More
Absolute Referencing in Excel

Locking cells: what’s the Excel dollar sign shortcut?

The Excel absolute reference shortcut will become one of your favourites to save time! Switch from relative to absolute references in seconds using this trick.

Read More