TOP MICROSOFT EXCEL KEYBOARD SHORTCUTS HOW TO

To make it easy to understand the dataset we need to lock the headers which we put at the top of our dataset. When we scroll down our dataset, we lost the headers of the datasets.

TOP MICROSOFT EXCEL KEYBOARD SHORTCUTS HOW TO

Read More: How to Freeze Top Row and First Column in Excel (5 Methods) Now if we scroll down, the frozen rows will still be visible to us.And finally, a gray line will show up directly below the frozen rows.As we are showing how this works thatвЂ™s why we are seeing this in detail. All we need to do is press Alt + W + F + F to freeze panes.This will appear in the Freeze Panes option. 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.

Top microsoft excel keyboard shortcuts