Are you working on an Excel sheet and would you like to “pin” the first row of the document, the one that contains the table titles, to the screen in order to always have it on top? No problem, it's very easy.
Microsoft Excel includes a very convenient function called "Freeze Panes" which, if used properly, allows you to do what you are trying to do: fix rows or columns of the spreadsheet to the screen in order to scroll the rest of the document without ever losing them of sight. If you want to know more, here it is how to freeze an Excel row step by step.
In the guide I will use Microsoft Office 2016 (which is available for both Windows and macOS) but the information below also applies to older versions of Excel. In addition, in the final part of the tutorial we will also see how to block rows of Excel sheets using smartphones and tablets. In short, do not worry, regardless of the device and the version of Office you use, you will certainly be able to achieve your goal. I wish you a good reading and a lot of fun!
Freeze the First Row of an Excel Sheet
If you need to freeze the first row of your spreadsheet in order to view the headings of a table, all you have to do is go to the tab View toolbar Excel, click on the button Freeze Panes located on the right and select the item Freeze Top Row from the menu that opens. In this way, even scrolling down the document the contents of the first row will be displayed in a fixed way at the top of the screen allowing you to see the headings of the table.
You don't want to freeze the first row, but the first column of an Excel sheet? No problem, this feature is also available in Microsoft's software. All you have to do is select the tab View, click on the button Freeze Panes (in alto a destra) and I will select the voice Freeze first column from the menu that appears. This way, while scrolling the worksheet horizontally, the first column of values will remain frozen and always visible in the foreground.
Freeze Multiple Rows of an Excel Sheet
Excel also allows you to block a set of sequential rows (that is, they come one after the other), just select the row immediately following those you intend to "fix" and activate the option Freeze Panes from the program menu.
Let's take a practical example: if you want to block the range of rows that goes from 1 to 5, you must select row number 6 (by clicking on the number 6 on the side of the Excel sheet), then you must go to the View Excel, you have to click on the button Freeze Panes and you need to select the item Freeze Panes from the menu that appears. Easy, right?
Freeze Rows and Columns
Using the same function you can also block rows and columns at the same time. Just select the cell located immediately below and immediately to the right of the range of rows and columns to be "fixed". Let's take another example.
If you have a table with at the top (row 1) the titles of the various columns and in the first column (A) the names of the customers, it might be useful to block both and keep them always visible. To get this result, you need to select the cell B2 (which is immediately to the right of the column to be blocked and immediately below the row to be blocked), then you have to go to the tab Viewclick on your bottone Freeze Panes I will select the voice Freeze Panes give the menu to compare.
When you have finished your work on the spreadsheet, to unlock the rows and columns set for "fixed" view, go back to the tab View Excel, click on the button Freeze Panes and select the item Unfreeze Panes give the menu to compare.
Freeze a Row in Excel 2003 and Earlier
You are using an old version of Office (eg Office 2003) and you can't understand how to freeze an Excel row? Don't worry, this feature is also included in older editions of the Microsoft suite.
To find it you have to go to the menu Window Excel and click on the item Freeze Panes contained in it. The procedure to follow to choose the rows and columns to block is the same as we saw for the function Freeze Panes Office 2007–2013.
Lock an Excel Row for Smartphones and Tablets
As you surely know, Excel is also available in the form of a free app for Android, iPhone / iPad and Windows Phone, and even in this mobile incarnation it allows you to lock the rows and columns of your spreadsheets. Let's see immediately how.
If you use Excel on your smartphone you can block a row or a column by simply selecting the latter and pressing the icon of pencil which is located at the top right. Then you have to expand the drop-down menu that appears at the bottom left, select the item View from the latter and choose one of the options for "fixing" the cells found at the bottom of the menu that opens: Freeze Panes and then on one of the options available in the menu that appears: Freeze Panes to lock the selected row, Freeze Top Row to lock only the first row of the sheet or Freeze first column to lock the first column of the sheet.
If, on the other hand, you use Excel on a tablet, such as an iPad, you can block an Excel row or column by selecting the latter, by going to View application and first pressing the button Freeze Panes and then on one of the options available in the menu that appears: Freeze Panes to lock the selected row, Freeze Top Row to freeze the first row of the spreadsheet or Freeze first column to lock the first column of the spreadsheet.
When you are done working, you can unlock the rows and columns of the spreadsheet by pressing the button Freeze Panes Excel and removing the check mark from the option activated above. The procedure applies to both smartphones and tablets.
With this I would say that's all. Now you know how to freeze rows and columns within Excel sheets on all software platforms and all devices. Since it wasn't that hard ?!