قالب وردپرس درنا توس
Home / Tips and Tricks / How to freeze a row in Microsoft Excel

How to freeze a row in Microsoft Excel



  Microsoft Excel Laptop Finance Business

When you work with rows and rows of data in Microsoft Excel, it can be difficult to keep your data right where you need it. You can waste time scrolling up and down looking for each number. Freezing rows is the solution – attach the rows you need to the top of the screen so you can always see them. Here are some tips on how to freeze a row in Excel.

How to freeze a row in Excel:

1. Select the line just below the data you want to freeze. In our case I want to freeze rows one to three, so I have selected row four.

  freeze rows 1

2. Go to View the tab and find the Window .

  freeze rows 2

3. Now select the option Freezer panes and select Freezer panes. You will also notice that you can choose to freeze only the first row or the first column as well. Note that freezing of rows means that you freeze every row above where you choose.

  freeze rows 3

4. If you want to freeze the panes, you can go back to the Freeze panes and select the Unfreeze option.

  freeze rows 4

What else can you do with rows?

Now that you know how to freeze rows in Excel, what else can you do? Rows are a perfect way to start exploring data analytics, and a little training can take you from zero to hero. If you're ready to get started, you can check out the entire Microsoft Excel and VBA package right now on Tech Deals. The massive learning kit packs a lot more information than our guides ever could.

  Complete Microsoft Excel and VBA package

You can dive into nine depth modules on everything from the basics of formulas and functions all the way up to VBA. The kit includes an incredible 65 hours of content that can help you get acquainted with the latest three versions of Excel.

One of the most impressive parts of the kit is the value it provides: The nine modules are worth a total of $ 300, but you can get started for just $ 29.99 right now. You can join over 3000 people and learn Excel through the widget below.

$ 29 .99

Complete Microsoft Excel and VBA packages

Save $ 270 .01

Buy it now

Complete Microsoft Excel and VBA package Buy it now

Save $ 270 .01 $ 29 .99 [19659037]
Source link