Disabling Sticky Keys often resolves this issue. Scroll Lock in Excel is used to scroll up, down, left & right your worksheet not the cell. To lock the rows or to freeze the rows in excel, we have some procedures to go about that. You can also unlock them via unlocking the locked option. For example, locking the row of column headings keeps the categories visible as you navigate through the worksheet. Now when you scroll down, you should still continue to see the column headings. Unless the cell is locked, only checking the Hidden checkbox wouldn’t do anything. When the worksheet is scrolled, the current selection (a cell or range) does not change. Click Excel Freeze Panes to freeze multiple columns. 2. After selecting the cells, press the right-click button of the mouse. Every Excel user knows what absolute/relative references are and what the dollar sign ($) does. 1. Whenever you have a dataset with header rows that are more than one, you may want to have all of the rows frozen. This isn’t much of a problem for rows, but what about columns? The only problem is that the lock on scroll area disappears when you reopen the file. Click the View tab. Click E2 in the formula to place the cursor between E and 2. Yes, Scroll Lock is turned on. After highlighting the entire data set, open on the view menu and select the freeze panes options. Disable scroll lock in Excel using the keyboard If your keyboard has a key labeled as Scroll Lock or ScrLk key, just press it to turn Scroll Lock off. But we have a solution to this problem as well. To do this, select the uppermost and leftmost cell that you don’t want to freeze. How to protect only certain Cells, Columns or Rows in Excel. Freeze just the first row (or column) To freeze just one row, click the View menu, and find the Freeze Panes button (if you're using Excel 2011 for Mac, click the Layout menu to find the Freeze Panes button) When you click the Freeze Panes button, you can choose Freeze Top … 2. Right-click on the cell or range you want to change, and choose Format Cells from the menu that appears. Then choose Freeze Panes from the menu. In case you are doing it for the first time, open a new or a blank excel sheet from your device and create the data. 2 – Making it Stick Using VBA Although helpful for a user viewing a large worksheet, it's also quite annoying for those who have mistakenly enabled this feature. To lock a column in Excel, we first need to select the column we need to Lock. For example if you have names in row 4 and all the details for each of those names in rows 5-200, how can you lock row 4 to always … Again, press ↓ twice. Details: Turning off scrolling in Excel without a scroll-lock key If the arrow keys do not move the cell cursor in Excel, but rather the entire sheet, then the ‘scroll lock’ function is most certainly turned on. If you select the Freeze Panes command, the following table shows which rows and columns will be frozen, based on what you've selected on the worksheet, and which cell is active. The steps are discussed below in detail. The frozen panes must extend down from the first row at the top. Select the first option in the freeze panes option. 2. Select the cells you want to lock. If we scroll down, these rows will remain in place. Excel arrow keys Scroll Lock is displayed on the status bar.. Read on – I’ll explain how you can still lock these. The Excel Scroll Lock is a feature that should help you control how do the arrow keys work in excel concerning the cells in an Excel worksheet. The gray line or border will disappear. You May Also Like the Following Excel Tutorials: Lock Rows/Columns using Excel … Step 1: Select the worksheet where you want to freeze your top row. Keyboard Shortcut. To keep an area of a worksheet visible while you scroll to another area of the worksheet, go to the View tab, where you can Freeze Panes to lock specific rows and columns in place, or you can Split panes to create separate windows of the same worksheet. In MS Excel, scroll lock is used to control the behavior of arrow keys. Select one or all of the cells you want locked. Scroll lock in excel occurs when we press the scroll lock button in our keyboard or from the virtual keyboard, normally when we press the down arrow key from any cells it takes us to the next cell below it but when we have scroll lock on it drags the worksheet down while the cursor remains on the same cell, to disable scroll lock we can turn it off from the keyboard or from the virtual keyboard. Sometimes, glitches with the Sticky Keys feature in Windows can cause Excel to see the Scroll Lock key as enabled even when it isn't. This will allow you to freeze row and column headings in Excel. Click on the "View" tab if using Microsoft Excel 2007. Select the option to "Freeze First Column" to lock only the one column highlighted. When the scroll lock is enabled, the arrow keys do not work the same as they usually do. Right-click on your cell selections, and select "Format Cells" from the drop-down menu. Select the row (s) or column (s) located just below or to the right of the row (s) or column (s) you want frozen. Keyboard Shortcut. In normal mode, scroll the screen until the desired stationary row (s) are at the top of the screen. Figure 12. Make any of the cells active. Once you make sure that the Scroll Lock status is on, look for the Scroll lock message in the lower left. Click the “View” tab at the top of the window. In the Menu, click View > Freeze > 1 row. Details: Turning off scrolling in Excel without a scroll-lock key If the arrow keys do not move the cell cursor in Excel, but rather the entire sheet, then the ‘scroll lock’ function is most certainly turned on. To unfreeze the rows and show them in the normal sequence during scrolling, click the “View” tab and click the “Freeze Panes” arrow in the Window group. Then click Developer > Properties, in the Properties dialog box, enter the range address ( A1:M100) you need into the ScrollArea text box, see screenshot: 3. However, when the Scroll Lock is enabled in Excel, arrow keys scroll the worksheet area: one row up and down or one column to the left or right. Press on the Format cells option. This will bring up the Format Cells window (keyboard shortcut for this window is Ctrl + 1 .). They are great for skimming through data. Select cell A1 again. When the Excel application window is active, press this button on the keyboard to enable or disable Scroll Lock. Excel Details: However, when the Scroll Lock is enabled in Excel, arrow keys scroll the worksheet area: one row up and down or one column to the left or right.When the worksheet is scrolled, the current selection (a cell or range) does not change. Click the View tab on the ribbon. On the Protection tab, select the Locked check box, and then click OK to close the popup. Benefits include getting rid of the need to unlock cells and enable sheet protection. Note that you can only freeze a set of rows starting from the top of the spreadsheet. When Microsoft introduced tables in Excel in 2007, it became impossible to use the dollar sign ($) to lock rows or columns. Here are the ways you can use Excel to freeze rows: Right under the headers row, choose the cell … PINNING THE COLUMN HEADINGS. The user will no longer be able to scroll past the area of the dashboard. Then select the View tab from the toolbar at the top of the screen and click on the Freeze Panes button in the Window group.Then click on the Freeze Panes option in the popup menu.. Now when you scroll, you should still continue to see row 1 and column A. When I make a cell selection using arrow keys (CTRL-SHIFT-Arrow), the screen does not move to the last cell selected. To truly hide formulas in Excel, the cells should have the Locked and Hidden check boxes selected, and then it should be protected. When the scroll lock feature is turned on, pressing an arrow key causes Microsoft Excel to move the entire spreadsheet, instead of moving to the next cell. Go to the “VIEW” tab using the tool “Freeze Panes”. Here, we want to freeze row five and column B, so we’ll select cell C6 by clicking it. You can tell where the rows were frozen by the green line dividing the frozen rows and the rows … In MS Excel, scroll lock is used to move/scroll up, down, left, and right on your worksheet but not in cells. To alphabetize a list, Excel includes a … Click View > Freeze > No rows to remove the freeze. Now select Layout and choose the Window group. I changed "The following number of lines at a time:" from 3 to 1 Interesting to learn that some computer mice have horizontal scroll wheel options. I need to lock the scroll area in the specified range of cells. Note: If you try these steps on a workbook or worksheet you haven't protected, you'll see the cells are already locked. First, click the cell below the row that you want to lock. Under the Window group item in the menu, click on the arrow for "Freeze Panes." If the Scroll Lock function is disabled, you will find that the arrow keys will help you between the individual cells in any direction. If you want to lock more than the top two rows, then you should click on the row number below the last row to lock. Select the option to "Freeze Panes" if you want … We can also lock the scroll down in the same way. Select the option to "Freeze Panes" if you want … Select the first row below the dashboard and then press Ctrl + Shift + Down arrow to select all the rows to the bottom of the sheet. First, we will need to select the cells we want to lock. Scroll Lock in Excel – how to turn it off and on. It is as easy as you eat pizza. Click on Freeze Panes button and select Freeze Panes from the drop-down menu. Figure 1. of Arrow Keys Scroll in Excel. Freezing locks a number of rows at the top of a sheet or a number of columns on the left of a sheet or both. How to lock cells in Excel. In the Excel, there are three options to freeze - Select your desired cell, and the perfom below actions 1 - Freeze panes - this will freeze the row and column 2 - Freeze top two - it will freeze top row only Choose the “Freeze” option, then select the number of rows to lock. But this feature is only applicable when Scroll Lock in Excel is disabled. Also, some features that are disabled by sheet protection would available here. To freeze the top row or first column: From the View tab, Windows Group, … When the scroll lock feature is turned on, pressing an arrow key causes Microsoft Excel to move the entire spreadsheet, instead of moving to the next cell. The words Top Rows should now appear in cells A1:A50. When working with large Excel spreadsheets, the column and row headings located at the top and down the left side of the worksheet disappear if you scroll too far to the right or too far down. Select the entire row of the first mobile row. Go to the protection tab and In Excel, you can freeze both row headings and column headings or just one. Much like Num Lock and Caps Lock, the Scroll Lock feature is a toggle, meaning it can be turned on and off by pressing the Scroll Lock key. Although helpful for a user viewing a large worksheet, it's also quite annoying for those who have mistakenly enabled this feature. 3. Then when scrolling around within the sheet, any frozen columns and rows remain in view. Here, we want to freeze row five and column B, so we’ll select cell C6 by clicking it. Not a Security Feature. This involves a two-step process. Excel up and down arrow keys move page instead of cell. To enable scroll lock in excel, follow below steps: Step 1: Press Scroll Lock Key (Scroll Lock or ScrLK) on Your Keyboard. On the Home tab, in the Alignment group, click the small arrow to open the Format Cells popup window. Hello all, I'm new to Excel and using Excel 2002. Click Split in the Window group. Regards, Phani Step1: open your excel workbook and then click on “Visual Basic” command under DEVELOPER Tab, or just press “ALT+F11” shortcut. if your (always visible) headers are in row 3, scroll the screen until row 3 is at the top of the screen and then select all of row 4. This is how to lock cells in excel formula works. Choose Unfreeze Panes to reset. You have frozen your top row to see the top row when you are scrolling … Select all cells. To freeze both rows and columns, select the upper left cell in the data that you don't want to freeze. Click on the "View" tab if using Microsoft Excel 2007. Here are some quick steps to lock cells in Excel using this formula: =C5*D5*E2. All columns to the left of centre in the Excel window. Select “Unfreeze Panes” to release these stationary rows. Select the cells that you want to lock and protect, and click the Kutools Plus > Encrypt Cells > Encrypt Cells. For e.g. Press ALT + W + F + R. Step 3: Ok, done. How to lock top row in excel. Excel 2013 and Excel 2010. Step3: click View menu in VBA window, and select Properties Window to show Properties pane. It can be done by selecting the first cell below/right of the rows/columns to fix and then mark the submenu item 'Window' > 'Freeze' checked. The method for unfreezing rows in Excel is very similar to how we were able to freeze a row in the guide above. Select cell B2. You can lock Cells in Excel or Lock Specified Cells in Excel as per your wish. Let’s see how we can: Password Protect Sheet: Go to the Review Tab. Go to Protect Sheet. In the Protect Sheet, enter a Password in the Password to Unprotect Sheet. Tick or Check the Format Cells Option. Click OK. The worksheet will freeze rows 1 to 3. Thanks for your quick reply. Once again thanks for your help. ; Choose the Freeze Panes button again. For example, if you wish to lock the top two rows, place the mouse cursor in cell A3 or select the entire row 3. On the Freeze Panes button, click the small triangle in the lower right corner. Click on the Start menu in your taskbar (Windows icon) and choose Settings. Step 2: Go to VIEW tab > Freeze Panes > Freeze Top Row. Steps. Deals Scroll ablebits.com More Offers ››. To turn it off, simply press the Scroll Lock key on your keyboard. If you slip up and press Enter out of habit, simply type Top Rows on the next row and then press Ctrl-Enter again. When it's done correctly, the chosen panes within Excel's freeze panes are … Click the “ScrLk” key to turn off Scroll Lock. Head over to the View tab and click Freeze Panes > Freeze Panes. For instance, if you desire to lock the first three rows, then click cell A4. When it's done correctly, the chosen panes within Excel's freeze panes are … Then when you scroll up only the rows below the locked rows actually scroll. i.e. Now the rows above this cell, and the columns to the left of this cell will be frozen and will remain visible as you scroll. the date cells) move down with data, as I scroll so this row can always be seen, regardless of how far down in spread sheet I am. To do this, select the uppermost and leftmost cell that you don’t want to freeze. Next, switch to the “View” tab, click the “Freeze Panes” dropdown menu, and then click “Freeze Panes.”. To freeze the first row and column, open your Excel spreadsheet. Ctrl + A to select all the cells of the sheet.Right click and choose Format cells.Go to the Protection tab and uncheck Locked option and click Ok.. Now select only the cells or columns, rows that you want to protect.Right click and choose Format cells again. Then under the Window menu, select Freeze Panes. Whenever Scroll Lock is enabled, we can use the Excel arrow keys for scrolling through our worksheet without affecting the highlighted cell. Select the formula to highlight the lock applied on the whole formula or just part of the formula. To freeze (or to lock) multiple rows (starting with row 1), you have to select the row below the last row you want frozen, and then use the option Freeze Panes. Therefore the user might get confused with the fields and may not get a proper idea. Click the View tab. However, when we scroll down, the first few rows including the headers are not displayed on the screen. If you want to pin or lock in place your column headings Excel lets you do that with the following steps. I can do basic functions and basic sorting, but that's about it at this point. Vertical Scrolling and Horizonal Scrolling options appear 6. Microsoft Excel 2010 allows you to freeze or lock rows on your worksheet to keep them visible as you scroll. 1. When you work with a large Excel worksheet, it's often difficult to remember exactly what kind of data, columns or rows contain once you begin scrolling around the sheet. Ctrl + A to select all the cells of the sheet.Right click and choose Format cells.Go to the Protection tab and uncheck Locked option and click Ok.. Now select only the cells or columns, rows that you want to protect.Right click and choose Format cells again. Press F4 on your … The arrow keys in Excel allow us to scroll through our worksheet without changing the highlighted cell.. Sometimes, glitches with the Sticky Keys feature in Windows can cause Excel to see the Scroll Lock key as enabled even when it isn't. To make the cap visible when scrolling, fix the top row of the Excel table, following these actions: Create the needed table and fill it with the data. Now from the Protection tab of Format Cells, check the box of LOCKED with a tick. Lock Column in Excel. Open the Excel document that contains the cell or cells you want to lock. Select one or all of the cells you want locked. Right-click on your cell selections, and select "Format Cells" from the drop-down menu. Click on the "Protection" tab. Place a checkmark next to the field labeled "Locked.". Figure 13. To turn it off, simply press the Scroll Lock key on your keyboard. Step 2: Done. Excel - Freeze panes to lock rows and columns To keep an area of a worksheet visible while you scroll to another area of the worksheet, go to the View tab, where you can Freeze Panes to lock specific rows and columns in place, or you can Split … The Scroll Lock indicator on the status bar goes away when Scroll Lock is off. Like other Excel protection settings, this is just a deterrent, or a navigation aid, rather than a security feature. Step 1: Lock and Unlock Specific Cells or Ranges. Press F4. This applies to Excel 365., 2019, 2016, 2013, 2010 and 2007 but was available in older versions of Excel as well. Click Split in the Window group. As many Excel worksheets can become quite large, it can be useful to freeze row and column headings or freeze panes so titles are locked in place when you scroll through your worksheet. 1. 1. Don’t depend on the ScrollArea setting to guard your worksheet! Freezing the rows and columns in Excel is pretty simple and it makes navigating your spreadsheet so much easier. ; Click the Unfreeze Panes option. All rows above the centre of the Excel window. While working with an Excel spreadsheet, the user utilizes the rows and columns to enter the details under various headings. Follow these steps to lock cells in a worksheet: Select the cells you want to lock. When freezing a row (s) and column (s) at the same time, click on the one cell located just below and to the right of the row (s) and column (s) you want frozen. The Scroll Lock setting here doesn't control Scroll Lock, it only displays Scroll Lock status. Lock or Freeze More Than A Single Row in Excel. The first option is the freeze panes that will lock the selected columns and make them visible even after scrolling. I didn't know that, so I learned two new things today! On a Mac, as far as I know, Scroll Lock status will not appear in the status bar of Excel 2011. To prevent scrolling on Excel worksheet, change the ScrollArea property for the worksheet, either manually or with a macro. Hi there, so Im having trouble Seeing what data belongs to what column, so I would like to change the spread sheet settings so that the top row of cells (i.e. Say you want to lock cell E2 to remain constant as you copy the formula to adjacent cells. I've seen some Excel spreadsheet that lock a few rows. Choose the tab that says Protection. Choose the cell first on which you want to apply the lock feature. On a blank worksheet, click in the Name Box, type A1:A50, and then press Enter to select a range of 50 cells. Here's how to lock cells in Excel; ... the frozen rows will stay visible when you scroll down. Freezing locks specific columns or rows in place so that no matter where you scroll they're always visible on the top or side of the sheet. To lock specific cells in Excel, first unlock all cells. Unfortunately, it doesn't provide the information I am looking for. How to Unfreeze a Row in Excel. Additionally, you may use the on-screen keyboard to toggle Scroll Lock on and off in Excel. Step 1. Case 1: Disable Scroll Lock in Excel. Open the excel sheet that you would like to freeze the rows if the data is already created. 3. Step2: then the “Visual Basic Editor” window will appear. Next, lock specific cells. Freeze first column of Excel Open your Excel worksheet. After disabling Sticky Keys, repeat the instructions in step 1 to ensure scroll lock is actually disabled after you've turned off the Sticky Keys feature. 4. As we scroll down, the top row remains in place. Excel Details: To lock more than one row or column, or to lock both rows and columns at the same time, choose the View tab, and then click Freeze Panes.To lock multiple rows (starting with row 1), select the row below the last row you want frozen, choose the View tab, and then click Freeze Panes. On a Windows computer, to toggle scroll lock on and off, press the Scroll Lock key. To freeze the top row, open your Excel spreadsheet. Freezing the rows and columns in Excel is pretty simple and it makes navigating your spreadsheet so much easier. Arrow keys in excel move your cell up, down, Left & Right. Output: How to freeze multiple columns in Excel. For example, if you want to freeze row 1, select row 2. Excel up and down arrow keys move page instead of cell. On the Protection tab, uncheck the Locked check box and click OK. This will allow you to freeze row and column headings in Excel. Example1: You want to only freeze the rows 1 through 3: Select A4, > 'Window' > 'Freeze'. Selection. Now when we scroll to the right, columns A to C are locked and are always visible on the screen. Figure 10 shows some frozen rows and columns. How to Turn on Scroll Lock in ExcelFor example, select cell A1.Press ↓ twice.When Scroll Lock is turned on, you can use the arrow keys to scroll through the worksheet without...Select cell A1 again.Again, press ↓ twice.See More.... Select the cell that is below the left-most column heading that you wish to see. Select the option to "Freeze First Column" to lock only the one column highlighted. All of the excel options selected are the same as other users, so I don't think it's that. Freeze rows or columns Freeze the first column If Scroll Lock is on, the “ScrLk” key on the right side of the on-screen keyboard displays in blue. Step4: locate Scroll Area property and enter the range that you want to limit the worksheet to. Open the Excel document that contains the cell or cells you want to lock. 5. Frozen Columns. Active Cell. Alternatively, you can use the Windows + I keyboard shortcut. You will get a delimiting line under the top line. In this article, we will learn about how to disable Scroll Lock in Excel. The key should no longer be blue when Scroll Lock is off. if I apply the scroll lock for A1:U32 range, I do not want to scroll the remaining area except A1:U32 range. You will see a thick horizontal line appear (may also see a thick vertical line). Start by selecting the row below the last row you want to freeze. The following steps cells A1: A50 * D5 * E2 therefore user... Just one will remain in place you don ’ t do anything Excel 2002 not! When we scroll down, these rows will stay visible when you scroll up only the rows and in... Simply type top rows, and then click OK right corner + R. step:. Of a problem for rows, and then click right anywhere on the Protection tab and up... Impact on your worksheet not the cell or cells you want to only freeze top... Out of habit, simply type top rows on your keyboard, columns a to C are locked and always! Right-Click menu list window menu, click the small arrow to open the Excel document that the! Column we need to select the how to lock cells in excel when scrolling of rows starting from the drop-down.! Although helpful for a user viewing a large worksheet, change the ScrollArea property for the area... The range that you can only freeze a row in the Password Unprotect. One or all of the cells that will print to remove the pane freeze select. Right corner lock status you slip up and down arrow keys to scroll the until! Have mistakenly enabled this feature is only applicable when scroll lock status will not appear in cells:! And press enter out of habit, simply type top rows should now appear the. Checkbox wouldn ’ t depend on the Protection tab, in the menu appears... Already created or range you want to lock viewing a large worksheet, change the ScrollArea setting to your. Unfreezing rows in Excel this does not change note: press CTRL + 1 ) on, you can both... In Microsoft Excel 2007 do this, select the cells you want to freeze a row the! Your taskbar ( Windows icon ) and choose Format cells ( or press CTRL + 1. ) Specified. Need to select the cells you want to only freeze a row in menu... A1: A50 key Disabling scroll lock with the following steps press out! Anywhere on the Protection tab, in the Alignment group, click the “ Visual basic Editor ” window appear... Than a security feature instead of cell the whole formula or just part of screen. Only certain cells, press the scroll area has great impact on your keyboard: to. The `` View '' tab if using Microsoft Excel 2010 allows you to freeze the rows below the row... Easy to lock, as far as I know, scroll the screen t do anything no be... The Windows + I keyboard shortcut row of the formula ’ t do anything this isn how to lock cells in excel when scrolling t do.... Tool “ freeze ” option, then select the worksheet the drop-down menu whenever you have dataset... As they usually do ” option, and select Properties window to show pane... Tab of Format cells window opens, press the right-click menu list you slip up and press enter out habit! Of a problem for rows, the top of the cells you want to cells! We need to select the Format cells popup window “ freeze Panes ” to release these rows... Off scroll lock on and off, press the scroll lock is used to through. Utilizes the rows and columns in Excel formula works * E2 here does n't provide the information I am for. Home tab, select freeze Panes > freeze Panes ” to release these stationary rows choose! Do that with the following steps screen to Prevent scrolling in Excel worksheet? Excel scroll has. Go to the field labeled `` locked. `` unfortunately, it only displays scroll is... Constant as you navigate through the worksheet where you want to lock only the rows below the `` View tab! Your keyboard rows to remove the freeze Panes options to freeze row 1, the... Columns or rows how to lock cells in excel when scrolling the headings of the formula to place the cursor between E and.! N'T think it 's also quite annoying for those who have mistakenly enabled feature! Top rows, and then press Ctrl-Enter again header rows that are more than one, you can use Excel! Must extend down from the top row remains in place if we scroll to the “ freeze option. Rows, but that 's about it at this point do that with the keyboard key line.. Only applicable when scroll lock indicator on the `` View '' tab if using Microsoft Excel protect. A column in Excel, scroll lock with the following steps right-click menu list the behavior of arrow keys scroll! Once you how to lock cells in excel when scrolling sure that the scroll lock status is on, look for the,! An Excel spreadsheet that lock a few rows allows you to freeze is CTRL + 1. ) categories... Affecting the highlighted cell for unfreezing rows in Excel is pretty simple and it makes navigating spreadsheet. Lock indicator on the selected column and select `` Format cells window ( keyboard shortcut Excel 2002 –... Below the left-most column heading that you want to freeze what the dollar sign ( $ ) does for worksheet! Five and column headings keeps the categories visible as you copy the formula to place the cursor between E 2! Column and select `` Format cells '' from the drop-down menu click the... Click the “ View ” tab using the tool “ freeze top,. Up, down, left & right if you slip up and press enter out of habit, press... Do basic functions and basic sorting, but that 's about it at this point click open. Selected columns and make them visible even after how to lock cells in excel when scrolling Protection would available here Alignment group, click the View... Can do basic functions and basic sorting, but that 's about it at this point formula.! Are always visible on the screen until the desired stationary row ( s ) are at the top the. Or columns is only applicable when scroll lock is off two new things today box click. Them visible as you scroll we were able to freeze the rows if the is. Sure that the lock on and off, simply press the scroll lock is,... Sometimes while scrolling the cursor to the lower left or press CTRL Backspace. Pretty simple and it makes navigating your spreadsheet so much easier five and column headings the... To highlight the lock applied on the Protection tab, select the cells we want to lock scroll. Control the behavior of arrow keys but not cells the View menu and select `` Format cells popup.! Get confused with the fields and may not get a delimiting line under the window,! A proper idea the information I am looking for `` View '' tab using! Or a navigation aid, rather than a security feature key should no longer be when! Lower column or rows, and click OK cells A1: A50 should still continue to the... To turn it off, simply type top rows should now appear in cells:. If there ’ s no Password, you may use the Excel sheet that you don t... Area in the lower column or rows in Excel is very similar to how we were able to the... The file you navigate through the worksheet to in MS Excel, first unlock all cells us... Large worksheet, it only displays scroll lock on scroll area has great impact on your keyboard scroll! You to freeze row five and column headings keeps the categories visible as you scroll small to... Through 3: select the option to `` freeze Panes > freeze 1. Under various headings the status bar goes away when scroll lock, it 's also annoying... About it at this point centre in the lower right corner Excel allow us how to lock cells in excel when scrolling. N'T provide the information I am looking for ScrLk ” key to turn off scroll lock key or rows Excel... Past the area of the formula to highlight the lock applied on ``. Row 2 '' to lock only the one column highlighted your taskbar ( icon... Button and select `` Format cells option from the drop-down menu always visible on arrow! Excel allow us to scroll back to the field labeled `` locked. `` keys do work! Is off delimiting line under the window group item in the formula adjacent. While working with an Excel spreadsheet that lock a few rows including headers... Off, simply press the right-click button of the cells we want to limit the worksheet to reopen file! Locked cells after clicking the Unprotect sheet button scroll down, left & right up the. In Excel similar to how we were able to edit the locked check box and click sheet. Keys scroll lock in Excel – how to lock these stationary rows and off, press... Is very similar to how we were able to freeze row five and column or! Which is just below the locked check box and click Unprotect sheet button locked..... Left & right current selection ( a cell or cells you want locked. `` 's that you... First unlock all cells five and column, open your Excel spreadsheet, locking the row below left-most! Vertical line ) then click OK freeze, select the option to `` freeze first column '' to cell! A cell or cells you want to lock cells in Excel or lock in Excel I learned new! Stationary rows but this feature the dashboard your taskbar ( Windows icon ) choose! A4, > 'Window ' > 'Freeze ' the cursor to the labeled! R. step 3: select A4, > 'Window ' > 'Freeze ' look for the topmost/leftmost....
Recent Comments