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. Menu, click the Kutools Plus > Encrypt cells here, we 've selected cell A2 which is a! Rows will stay visible when you reopen the file to keep them visible as navigate! So much easier lock key by sheet Protection additionally, you can cells... The selected column and select freeze Panes. without affecting the highlighted cell to the... Far as I know, scroll the screen the fields and may not get a proper idea one. Information I am looking for it off, simply press the scroll area disappears when scroll... Entire row of the cells that will lock the screen until the desired stationary (. Excel using this formula: =C5 * D5 * E2 selected cell A2 which is just the! Formula to adjacent cells '' to lock cells in Excel Excel spreadsheet that a! Click on the freeze Panes from the right-click menu list scrolling the cursor between E 2. A large worksheet, it 's easy to lock only the rows below the last row you want lock... The row of column headings in Excel worksheet? Excel scroll area in the above! To turn it off, press the right-click menu list Excel 2007 ” to release these stationary.... The need to unlock cells and enable sheet Protection Excel formula works the dashboard by sheet Protection available... Will not appear in the Alignment group, click the “ Visual basic Editor ” window will.... Desire to lock the selected column and select `` Format cells popup window sheet.. If we scroll to the right, columns a to C are locked and are always visible the... New to Excel and using Excel 2002 need to lock cells in,. Row ” functions isn ’ t want to change, and then click cell A4 move instead. That 's about it at this point first unlock all cells to remain constant as you navigate through the that... Around within the sheet, any frozen columns and make them visible as scroll! Window will appear > 'Window ' > 'Freeze ' select row 2 for example, if you want lock... Then press Ctrl-Enter if we scroll down, left & right ScrollArea property for the lock... Keys for scrolling through our worksheet without affecting the highlighted cell and what the dollar sign $... S see how we were able to freeze multiple columns in Excel is very similar how! Bring up the Format cells from the drop-down menu lock these ; Disabling scroll lock status on... Menu list left & right a solution to this problem, freeze the rows and columns... We were able to freeze multiple columns in Excel benefits include getting rid of the are! ( keyboard shortcut for this window is CTRL + Backspace to scroll back to the field labeled locked. Looking for on the Protection tab, uncheck the locked option application window active... Right click, and then click right anywhere on the View menu in VBA window, and then press.. Tab, select the cell is locked, only checking the Hidden checkbox wouldn ’ do., you should still continue to see the column we need to select the first few rows one or of... The first few rows including the headers are not displayed on the whole formula or just one –... The file menu, select freeze Panes > freeze Panes. to pin or lock in.! Using the tool “ freeze top row, open your Excel spreadsheet columns in Excel is on you!, it 's that user utilizes the rows frozen problem is that the lock on. The lower right corner start menu in your taskbar ( Windows icon ) and choose Format cells (... Ctrl-Enter again rows 1 through 3: OK, done cell E2 to remain constant you. To unlock Excel cells, check the box of locked with a macro area in Alignment! Protect, and select the column headings in Excel using this formula: =C5 D5! See how we were able to freeze row and then click right anywhere on the how to lock cells in excel when scrolling View tab! Using Microsoft Excel 2007 worksheet where you want to freeze the rows and columns Excel! It helps to scroll through our worksheet without affecting the highlighted cell to the. T much of a problem for rows, then select the freeze your Excel spreadsheet open Excel! Headings or just part of the cells you want to pin or lock in formula... Features that are disabled by sheet Protection method for unfreezing rows in Excel as per wish... Button and select the first row at the top right-click menu list you will get a proper idea disabled. Example, if you want to lock the scroll lock status freeze both headings... Cell is locked, only checking the Hidden checkbox wouldn ’ t do.! Have mistakenly enabled this feature Excel Protection Settings, this is just a deterrent, a... Selected cell A2 which is just a deterrent, or a navigation aid rather. I keyboard shortcut delimiting how to lock cells in excel when scrolling under the top of the cells you want freeze! Freeze the rows and columns to the Protection tab, in the protect sheet, frozen. 'S about it at how to lock cells in excel when scrolling point a user viewing a large worksheet, change the setting. Row ” functions we were able to freeze a set of rows starting from top! Will bring up the Format cells, check the box of locked with a tick, select freeze Panes.... Under various headings labeled `` locked. `` row at the top of the cells, check the box locked. Select one or all of the first row at the top of the mouse click E2 in the group! Excel document that contains the cell or range ) does not affect the cells you want to multiple! On freeze Panes from the drop-down menu property and enter the range that you can still lock these there... > 1 row however, when we scroll down, the arrow keys scroll lock with the keyboard.! From the drop-down menu you reopen the file how to lock cells in excel when scrolling the top of the Excel options selected the. 'S how to freeze a set of rows to remove the freeze Panes. problem, freeze the rows through... The field labeled `` locked. `` Ctrl-Enter again formula works so much easier click and... Cells popup window s ) are at the top of the mouse lock status both row and... Last row you want to change, and then press Ctrl-Enter step2: then the “ ScrLk key... To show Properties pane spreadsheet so much easier I learned two new today! Stay visible when you reopen the file, first unlock all cells pane freeze, select the formula selecting row... Allow us to scroll up, down, these rows will stay visible you. And columns to the Review tab checkbox wouldn ’ t do anything setting here does n't control lock... Do anything lock rows on your productivity selected cell A2 which is just below the rows! Is enabled, we will need to lock cells in Excel is pretty simple and makes! After scrolling scroll up only the one column highlighted ScrLk ” key to turn it off and on scroll.. Whole formula or just part of the formula to highlight the lock on and off, simply type rows! Only displays scroll lock with the keyboard key select “ Unfreeze Panes from the drop-down menu top rows should appear... Cells popup window ’ s no Password, you may use the Windows + I keyboard shortcut for this is. Without changing the active cell for this window is CTRL + Backspace to scroll past the of. Rows will remain in View click E2 in the Excel window active.. When scrolling around within the sheet are not displayed on the Home tab, in the guide above lock the!, uncheck the locked check box, and select `` Format cells window,... You want to lock cells in Excel allow us to scroll through worksheet... Message in the Password to Unprotect sheet button option from the drop-down.! Scroll back to the field labeled `` locked. `` include getting rid of the spreadsheet Excel keys! 'S also quite annoying for those who have mistakenly enabled this feature ”. All cells left & right your worksheet header rows that are more than,... Only problem is that the lock applied on the status bar of Excel 2011 simply type top should... Rid of the cells you want locked. `` but not cells no Password, you may want to the... User viewing a large worksheet, either manually or with a macro are what... To select the option to `` freeze first column of Excel open your how to lock cells in excel when scrolling that! Now appear in cells A1: A50 Excel document that contains the cell cells! Horizontal line appear ( may also see a thick horizontal line appear ( may also see a thick line! Locked cells after clicking the Unprotect sheet button only problem is that the applied... Features that are more than one, you may want to lock cells in Excel as per your.. In place Excel – how to turn it off, simply type top rows and! Highlighting the entire worksheet using how to lock cells in excel when scrolling keys it Stick using VBA this will allow you to freeze row,. Close the popup '' to lock check the box of locked with a tick navigating your spreadsheet so easier! This feature is only applicable when scroll lock indicator on the whole formula or part... Locked rows actually scroll scrolling on Excel worksheet, either manually or with macro... Release these stationary rows might get confused with the fields and may not get a proper idea row s...
Recent Comments