Excel is software developed by Microsoft for the package office. he himself is intended for use by both professionals and students or anyone. This is due to its great dynamism and amount of .
However, it is likely that everybody equally Have you ever had to fill out a long spreadsheet?. If it were a piece of paper and a pencil, it would surely consist of several pages.
perform it in this way, it would be cumbersome and outdated. Fortunately, Excel offers a very useful function to solve some problems in the creation of long documents. To know it, we invite you to read the following post.
Why is it useful to pin certain rows in your Excel documents?
As we mentioned before, the extensive spreadsheetsthat is to say with many completed, It 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 span a specific area of the table. When we redact too much information, document scrolls down. This does lose sight of possible headers that we have created
It also sometimes happens that we work on several files at the same time. Having to scroll to the front 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 what we were working on before, it does it in the sector that we left 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 a tool to fix rows and columns in the document:
Steps to fix a row in your Microsoft Excel spreadsheets
What this utility does, is always keep selected rows visible. A kind of floating, 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 manage 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 workedopen it.
- Otherwise start microsoftoffice and create a new “Blank Book”.
As an example we will enter data without any relation 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”:
- Go to the tab “View”.
- inside section “Window” you will find the dropdown button “Immobilize”.
- press it and choose “Freeze Top Row”. This will make the row 1 be visible during the entire transfer that we carry out within the table.
- The other two options listed within this button they are equally useful.
- “Immobilize 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 must use the alternative “Freeze panels” as follows:
- Select the next row the one you want immobilize. That is, if you want to fix the rows “1”, “two” Y “3”click on the row “4”.
- Then press the button “Freeze Panels”. By doing so you will be able to observe a line dividing these three rows from the rest. This indicates that you have completed the process correctly.
- if what you need is set rows and columns at the same timeChoose the next cell to the sector you want to fix. That is, if you are going to immobilize the row 1 Y column Aposition yourself in “B2”.
- Then press “Freeze Panels”. In this way, you can move horizontally and vertically in the documentbearing in mind the content of the first lines.
For undo these actionsgo back to the section “Window” tab “View”. This time the button name will be “Mobilize panels”. press it.
Facebook Comments
Disqus