how to freeze first two rows in excel on mac

After that, press the keyboard hotkey sequentially Alt + W + F.

To select the row click on row 9 or click on any cell in row 9 and press Shift + Spacebar, to select the whole row.

We are going to select row 9 to lock the above rows.

Firstly, select the row or cell or column.

But I will explain in a detailed way that will help to understand how those shortcuts work. To use the shortcut to lock rows or columns or both, we just need to select the cell or column or rows and then press the keyboard hotkey. Shortcut to Freeze Both Rows and Columns in Excel And the dataset includes Product Name in column B, Price in column C, and the product’s percentage of value-added tax in column D ( Vat).ġ. To use the keyboard shortcuts to Freeze Panes in excel we are going to use the dataset below. It takes only a few clicks to freeze panes but if you are using the keyboard shortcut, you will be able to complete the task within some seconds.

We may all know about the Freeze Panes in excel with this we can easily freeze or lock the data we want to display all the time even while navigating to another part of the worksheet.

How to freeze first two rows in excel on mac