How to Freeze Columns and Rows in your Excel Tables? – Setting

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 you can apply is the freezing of rows and columns of a table, very useful option to visualize data in a worksheet, apply this freeze on rows and columns.

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 stationary so that you can see them when you are moving around the entire work area.

How do you freeze rows in Microsoft Excel?

Freezing rows in Excel spreadsheets will cause this stay static as you scroll through the worksheetapplying this immobilization is very simple, we will show you below:

1. Open the Excel document on your computer in which you want to apply the immobilization.
2. Select with the mouse the row at the bottom of either the rows you want to block or immobilize.
3. Go to the toolbarat the top, click the View option.
4. The View section will open, in it you must search and select the Freeze option.
5. Then you will see various options, including freeze panel. You can also select the option Freeze Top Row, this will staticize the first row of the document.

What is the procedure for columns?

The frozen columns they will be visible while you are scrolling in the documentto apply this immobilization in columns, carry out the procedure that will be shown below:

1. Open the worksheet on your computer to which you want to freeze a column or columns.
2. Select with your mouse the column that is located to the right side of the column or columns that you want to freeze.
3. After the selection opens the View section, to achieve this you must click on the View option located at the top.
4. Click on the ‘view’ option.
5. 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 option Freeze first column.

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, achieving this is very simple, you just have to apply the procedure that will be shown:

1. Open the Excel document in which you want to freeze multiple columns and rows on your computer.
2. Locate the worksheet at which you want to apply the freeze.
3. 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 of the selection of the rows you must select towards the right side the columns that you want to immobilize, as in the rows you must select the cells of the columns you want to freeze.
4. Click on the ‘View’ option located at the top.
5. 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’re working on an online spreadsheet, don’t worry. in it you can also perform the immobilization of 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, there is 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 freeze the rows, 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. they will open up to you the View section options among them you will find the Freeze option, select it and to finish press on 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 immobilization of one or more columns, 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.