Fix Rows in Excel  Step by Step Guide ▷ 2020

Excel is a software developed by Microsoft for the package Office. He himself is intended to be used by both professionals and students or anyone. This is due to its great dynamism and quantity of functions.

However, it is likely that everybody equally have ever had to fill out an extensive spreadsheet. If it were a sheet and a pencil, it would probably consist of several pages.

Do it in this way, it would be cumbersome and outdated. Fortunately, Excel offers quite a useful function to solve some problems in creating long documents. To know it, we invite you to read the following post.

Why is it useful to fix certain rows in your Excel documents?

Why is it useful to fix certain rows in your Excel documents?

As we mentioned before, large spreadsheets, that is, with many rows completed, usually presents a problem when it comes to remembering which column we are working on. Since your computer monitor has a defined size, it can cover a specific area of ​​the table. When we write too much information, document scrolls down. This does lose sight of possible headings that we have created.

It also happens sometimes that we work on several files at the same time. Having to move to the first rows to remember what the document is about is, without a doubt, a waste of time.

One of the many advantages of this software, at least in its latest versions, is that when reopening a file in which we were working previously, does it in the sector that we leave it prior to save. However, this positive utility becomes an added step in having to recognize what it is about each column.

For all these situations and those that you can add, there is the tool to fix rows and columns in the document:

Steps to fix a row in your Microsoft Excel spreadsheets

What this utility does, is keep selected rows always visible. A kind of floating cells, which overlap the document. Thus, no longer necessary, go to the beginning of the same. Much less, write down in a notebook, the category of each column.

We must tell you, that this tool is widely used by professionals.

If you want to handle Excel as one of them, we recommend that you take note of the following steps:

  • If you wish immobilize a row in a document where you have already worked, open it.
  • Otherwise, start Microsoft Office and create a new “Blank book”.

As an example we will enter data unrelated. In the first row we will place “Column 1, 2 and 3” in separate cells. Under each of them we will write numbers, letters and days.

We will do this, up to the fourth row and then we will use the “smart fill”:

Steps to fix a row in your Microsoft Excel spreadsheets freeze first row panels

  • Go to the tab “View”.
  • Inside section “Window” you will find the drop down button “Immobilize”.
  • Press it and choose “Freeze top row”. This will make the row 1 It is visible during the entire transfer that we make within the table.
  • The other two options contained within this button they are of equal use.
  • “Freeze first column” performs the same as the previous one, but applied to the “Column A”.

In the event that you want to fix more than one row or column, you should use the alternative “Freeze panels” as follows:

Steps to fix a row in your Microsoft Excel spreadsheets freeze dashboards

  • Select the next row the one you want immobilize. That is, if you want to fix the rows “1”, “2” Y “3”, click on the row “4”.
  • Then press the button “Freeze panels”. By doing so you will be able to observe a line that divides these three rows from the rest. This indicates that you have completed the process correctly.
  • If what you need is fix rows and columns at the same time, Choose the next cell to the sector you want to set. That is, if you are going to immobilize the row 1 Y column A, stand in “B2”.
  • Then press “Freeze panels”. In this way, you can move horizontally and vertically in the document, having to the visa the content of the first lines.

For undo these actions, go back to the section “Window” of the tab “View”. This time, the button name will be “Mobilize panels”. Press it.

If you have any questions, leave them in the comments, we will answer you as soon as possible, and it will surely be of great help to more members of the community. Thank you! 😉

You may be interested:

Rate this post

Leave a Comment