The Microsoft Excel program offers you many options that she has to make the daily work that we do in her even easier. One of the options that you can apply is the freezing of rows and columns of a table, a very useful option to visualize data in a worksheet, apply this freezing in rows and columns.
Index( )
- What is the difference of locking and freezing rows or columns in excel?
- How do you freeze rows in Microsoft Excel?
- What is the procedure for columns?
- How to freeze multiple columns and rows at the same time in Excel?
- How to freeze rows and columns in online spreadsheets?
What is the difference of locking and freezing rows or columns in excel?
Freezing and locking of rows, columns in Excel spreadsheet is the same, in said tool they are synonyms , the procedure to apply it is the same as well. The application of this immobilization or blocking in rows or columns will make them remain immobile so that you can see them when you are moving around the entire work area.
How do you freeze rows in Microsoft Excel?
The immobilization of the rows in Excel spreadsheets will make them remain static while you move through the worksheet , applying this immobilization is very simple, we will show you below:
- Open the Excel document on your computer in which you want to apply the immobilization.
- Select with the mouse the row at the bottom of either the rows you want to block or immobilize.
- Go to the toolbar , it’s at the top, click on the option View.
- The View section will open, in it you must search and select the Freeze option.
- Then you will see various options, including freeze panel. You can also select the Freeze Top Rowoption , this will freeze the first row of the document.
What is the procedure for columns?
The immobilized columns will be seen while you are scrolling in the document , to apply this immobilization in columns, carry out the procedure that will be shown below:
- Open the worksheet on your computer to which you want to freeze a column or columns.
- Select with your mouse the column that is located to the right side of the column or columns that you want to freeze.
- After the selection opens the View section, to achieve this you must click on the View option located at the top.
- Click on the ‘view’ option.
- Among the various options that will be presented to you, you will see the one to immobilize panels, you must select it. If you only want to freeze the first column, you must select the Freeze first column option.
How to freeze multiple columns and rows at the same time in Excel?
In Excel you can also freeze rows and columns at the same time , doing this is very simple, you just have to apply the procedure that will be shown:
- Open the Excel document in which you want to freeze multiple columns and rows on your computer.
- Locate the worksheet on which you want to apply the freeze.
- With your mouse select the cells that are located at the bottom of the rows that you want to freeze, the number of cells in the row that you are selecting must be the same as those that you want to freeze in the row. At the same time as the selection of the rows, you must select the columns that you want to immobilize on the right side, just as in the rows, you must select the cells of the columns that you want to immobilize.
- Click on the ‘View’ option located at the top.
- The View section will open, in it click on the Freeze option, then select the Freeze panels option, in this way you will have finished.
How to freeze rows and columns in online spreadsheets?
If you are working on an online spreadsheet, don’t worry about it, you can also freeze rows and columns, because although in said spreadsheet there is a summary of options and tools with respect to the version that is installed on computers, find the immobilization option, to apply it in rows and columns do the following:
For row freezing: open your online spreadsheet, go to the page you want to apply row freezing, select with your mouse the bottom cells of the row or the ones you want to freeze.
Locate yourself in the options panel that is at the top, in it you will find the View option, press on it. The options of the View section will open , among them you will find the Freeze option, select it and to finish press the panels option found in the menu that will open.
To freeze columns: within the online spreadsheet, locate the sheet in which you want to apply the freeze of one column or several, after you locate it, select with your mouse to the right of this column or columns that you want to Freeze.
Now go to the View section, then click with your mouse on the Freeze option and finally select the Freeze Panels option and that’s it.