How to scroll formula in excel. 2. See also Turn Text To Dec 19, 2023 · Write On Screen in the Search bar. Pressing “Ctrl” + “G” and then typing May 20, 2023 · Step 1: Select the Column. If you want to scroll down your sheet viewpoint while editing text, enable scroll lock. Add or edit cell contents. Step 1: Locate the "Scroll Lock" key on your keyboard. Select Customize Ribbon. Select View > Freeze Panes > Freeze Panes. , if you want to keep up to the 14th row, select the 15th row ). ”. Pick the cell or range of cells. If F14 exists on your keyboard, but there is no Fn key, use the Shift + F14 shortcut to toggle the Scroll Lock on or off. Press the C key to Freeze First Column. Next, click on the sheet where you want to go. , "Ctrl + Home" to navigate to cell A1, then press "Ctrl + End" to see the last cell on the sheet). Using the On-screen Keyboard. Jul 3, 2023 · Step 1: Go to file and click on the Excel option. 6. Press and hold the “Ctrl” key, then click on the cells to which you wish to apply the formula. Select Ease of Access > Keyboard. Once done, the corresponding light (if any) of the toggle key turns off. See the screenshot below. Click Change PC Settings. The status bar shows the scroll lock status if it is on. When the screen lock feature is on, it will be highlighted as blue in the app. Select the first few rows. Below are the steps to use the above keyboard shortcut: Select the cells where you want to drag down the cell/formula. ‘ The Format Control dialogue box will appear. It is possible in Office 2013 - just drag the scroll bar. Feb 6, 2022 · Option 2: Home tab > Find & Select under Editing. The second method is to use the F4 hotkey as the shortcut to lock up a cell. Step 1: Open your Excel spreadsheet and locate the horizontal scroll bar at the bottom of the window. Excel allows users to use a custom scroll bar so that they can limit the number of visible rows and columns in a large data table for convenience. In t Nov 11, 2020 · Read How to Insert & Run VBA code in Excel – VBA101 if you forget how to insert VBA code in Excel. Step 3: Select the Developer Check box. When the on-screen keyboard appears on your screen, click the ScrLk button. Tap in the formula bar. Step 4: Enable Scroll Lock. Copy ( CTRL+C) the formulas and paste (CTRL+V) them inside Notepad. Go to the View tab: Navigate to the View tab in the Excel ribbon at the top of the window. Select the cell with the formula. Right-click the Start button (lower-left corner) in Windows, and click Run. Place the cursor. Enabling Scroll Lock is essential in ensuring that the locked cells are not editable while May 30, 2012 · Enter your desired formula into the 2nd row of the column you want to fill. The On-Screen Keyboard appears with the ScrLk key highlighted in blue if the scroll lock is enabled (as shown below). This can be useful for navigating large spreadsheets and viewing data while keeping the current cell selected. The status bar in Excel provides useful information about the active worksheet. Select ‘Advanced’ from the left-hand column and scroll down until you see the option for ‘Enable Smooth Scrolling’. Go to Home > Editing > Find & Select > Go To Special. Under the “Protection” tab, check the “Locked” checkbox, then click “OK. If you’d rather not add the May 7, 2024 · How to Enter a Formula in Excel. However, using an arrow key while the input cursor is active within a cell does not move the selection to the adjacent cell. Click an arrow next to Simply press Ctrl + G to open the "Go To" dialog box, then enter the cell reference for the last cell on the sheet (e. In such cases, reducing the complexity of the spreadsheet by minimizing formulas, rows, columns, or objects can alleviate the strain on Excel’s scrolling functionality. Range("A1:J25"). Now, row 5 is visible at the top instead of row 1. Unhide the hidden rows. To enter a formula in Excel: Click on the cell where you want the result to be displayed. If you want to keep the top row of cells in place as you scroll down through your data, select Freeze Top Row. It will turn blue indicating the lock is enabled. Step 4: Put your cursor over the vertical scrollbar. For example, =A1+B1. To make the most of this free training, please go through these Excel training videos in the Keyboard shortcuts can be another efficient way to get to the bottom of your Excel spreadsheet. B. This page gives you access to a completely FREE Online Excel Training (26 video lessons with 12+ hours of learning). STEP 1: Open your spreadsheet and ensure the top row with your headers or titles is in view. Mar 30, 2016 · Click the “ScrLk” key to turn off Scroll Lock. Moves to the boundary of the dataset. Go to ‘View’ in the Ribbon menu at the top. Press Enter to execute the formula. Close your brackets. e the height and width of what we want to display is just the 1 cell. Scroll options in Excel allow for seamless navigation, zooming, and customization. This was another quick way to copy a formula in Excel without changing cell references. Try moving around with the arrow keys and watch the address in the name box (directly left of the formula bar). Select the third column. Apr 15, 2021 · ⚡ In this tutorial, I will show you how to add a scroll bar on an Excel spreadsheet so you can control data in a cell simply by dragging the scroll bar. Just scroll down and start watching the videos to learn Excel. Troubleshooting common scroll issues and seeking help from Excel support can improve user experience. ScrollArea = ws. Use the shortcut Control + D to fill it down. May 16, 2024 · Here’s how to extract formulas using Go To Special: Select the range of cells that contains the formulas you want to extract. Oct 21, 2015 · You can use the OFFSET function in order to specify a cell offset from cell A1. Click on that app icon. This method allows for precise navigation to a specific cell on the sheet, including the bottom. Dec 9, 2021 · Press the “Ctrl” and “C” keys simultaneously to copy the formula. Click on the drop-down arrow next to it. Step 3: In the "ActiveX Controls" section, click on the "Scroll Bar" option. An Excel Options dialog box appears. Detail how to disable scroll lock via the Column B contains the Turn Over. May 10, 2024 · This acts as a toggle and will also unfreeze the rows or columns if they are already frozen. Press Enter. Note: The scroll bar is added in a top-down orientation. Explain the function of scroll lock in Excel Dec 19, 2023 · Steps: First, press the SCROLL LOCK button on the Keyboard. Type the equal sign ( = ), followed by your formula. Select one of these options: Freeze Panes, Freeze Top Row, or Freeze First Column. Add a scroll bar (Form control) On the Developer tab, in the Controls group, click Insert, and then under Form Controls, click Scroll bar . Make sure to use $ for any referenced cells where the row stays the same for all equations. Select a cell inside your table go to the Data tab choose From Sheet. May 21, 2021 · If you want to remove the Excel scroll lock feature on Mac, do the following: On the Apple Extended Keyboard, press the F14 key (This is an analog of the Scroll Lock key on a PC keyboard). Click Customize Ribbon in the left pane. Select the Developer check box under Main Tabs on the right, and then click OK. To scroll up, select a cell => Press the Up Arrow (↑) To scroll down, select a cell => press the Down Arrow (↓) Similarly use the Right or Left arrow keys to scroll in those directions. Select OK to save the changes and exit the “Excel Options” window. Even if the formula is being copied downward, this can still be a horizontal offset. Step 2: Click Customize Ribbon. Oct 5, 2020 · Learn how to copy data or formulas down a column in Microsoft Excel and increase productivity. To do this, follow these steps: Click File, and then click Options. The first method is about assigning the Dollar Sign ($) manually before the column and the row number. Lastly, the INDEX function extracts the first Sales Rep for 1002 Product ID. Method 2: Using an on-screen keyboard. Go to the Add Column tab and click on the Index Column command. Option 3: Select the Name Box above Column A. Pick Go to and enter the cell under Reference. Below I have a formula in cell C2, and I have selected all the cells in the column where I want to fill the same formula. Click the View tab on the ribbon. Tab. May 6, 2024 · The easiest way to limit rows in an Excel worksheet is by hiding them. Insert the Scroll Bar Control. Release the Ctrl key to stay at the desired location. Use the Fill Handle (bottom-right corner) to drag it down to your desired row. Sep 1, 2021 · Even though Excel allows 32,767 characters in a cell, it has always been tough to deal with that much data in one cell. This will enable or disable Scroll Lock depending on its previous state, letting you move the active cell to any part of the sheet. This is how you work with formula bar in Excel. 9K views 12 years ago #evergreen #spreadsheets #exceltricks. Ctrl+Arrow Key. MrExcel. I tested while I was logged out to see if I could edit and scroll, which I could. The Main Freeze Panes Options. Hold the Control key and then press the D key on your keyboard. May 10, 2024 · This will open the On-Screen Keyboard app and you will be able to use the ScrLk key. Your goal is to see the text “Word 3276” at the end of the cell. To use the form controls, you have to enable the Developer tab. Sep 8, 2021 · Add your data into query by using a From Sheet query. To use the Count Numbers option, go to the Home tab. Jan 2, 2024 · The methods of turning off the scroll lock in Excel are listed as follows: Method 1: Using a physical keyboard. Step 2: Click on the small arrows on either side of the scroll bar to move horizontally through your spreadsheet. To lock the selected cells, right-click on any of the cells, and select “Format Cells” from the menu. 4. Pres s CTRL+SHIFT+Downward key to select all remaining empty rows. 5. I can still scroll while editing a formula. But in Excel, I cannot find for the life of me, how to scroll horizontally, other than by May 7, 2024 · To freeze the needed cells, just do these 5 steps: Open the Excel file. Then press the keys Ctrl +D. Select an empty row after your dataset (e. Check this box and click on ‘OK’. Or, Go to the Home tab > Editing group > Fill dropdown > Select Down. Or, use the keyboard shortcut Ctrl+G then click the Special button. Now, if we move the mouse cursor with the Arrow keys, then we will see that scrolling in Excel is no longer the problem. Click the menu option Freeze Top Row. Oct 27, 2011 · Excel - Scroll Through Long Formulas In The Formula Bar: Episode 1458 - YouTube. Select the cell below the rows and to the right of the columns you want to keep Jan 10, 2023 · Open Excel’s File tab. Select the cell below the rows and to the right of the columns you want to keep Jul 16, 2015 · 1. 3. (Nb: The Scroll Bar control option is found on the Developer tab. We'll be waiting for the result. When scroll lock is turned on, pressing the arrow keys will cause the screen to scroll, rather than the selected cell. 9. Step 2. To orient the scroll bar from left to right, drag one Jan 25, 2024 · Press the Scroll Lock key to enable it. You can also press Ctrl+A to select the entire active worksheet. Step 3: To change the size of the scroll bar, click and drag the Microsoft Excel Tutorial: Fix the vertical scroll bar in Excel. Click the small triangle (drop-down arrow) in the lower right corner of the Freeze Panes button. Jun 23, 2023 · How to Freeze a Row in Excel. Feb 2, 2024 · Here’s how you can freeze rows in Excel –. To keep the first column in place as you scroll horizontally, select Freeze First Column . To freeze a row in Excel, navigate to the View tab on the ribbon at the top of the screen. STEP 4: Select “Freeze Top Row” from the dropdown menu. Jan 9, 2024 · Enter the formula in the starting cell. After copying the data, use the vlookup function and see if the issue will occur on the new Excel file. Jun 19, 2023 · A drop-down menu will open with a set of three freezing options. g. Create Table dialog box appears. Click Freeze Panes: In the Window group, click on the "Freeze Panes" option. Step 2: Click on the ‘Freeze Panes’ Option. Selects all the non-blank cells in the direction of the arrow. Select View >> Freeze Panes >> Freeze Top Row as in method 1. SHIFT+Arrow Key. Right-click. May 4, 2024 · The Scroll Lock feature in Microsoft Excel allows users to scroll through a spreadsheet without changing the active cell. If the cells are blank, move to the last cell in the row or column. Hit the scroll bar and test! Enable The Developer Tab In Excel. Next two references are 1 and 1 for one cell value i. If your arrow keys work again, you can go back and enable the add-ins one at a time to narrow down the culprit. Tick the Developer check box, then click OK. microsoft. STEP 2: Go to the “View” tab located in Excel’s ribbon. Release the mouse. Configure the Status Bar If Scroll Lock Status Is Not Displaying. The SMALL function finds the smallest value in a given dataset. Verify the freeze: You can verify that the cells are frozen by scrolling through the spreadsheet. Shifts to the right by one cell. Scroll through your spreadsheet using either the arrow keys or your mouse. Step 4: Click and drag on the worksheet to draw the scroll bar. This will insert a new row between the existing frozen row and your spreadsheet data. This will freeze the rows above the selected cell and the columns to the left of the selected cell. Again, make sure the “Scroll Lock” indicator is selected to display on the status bar so you can tell if it’s on or off. Quickly select all cells with content. . Step 2: Press the "Scroll Lock" key to toggle the function off. Add a scroll bar (Form control) On the Developer tab, in the Controls group, click Insert, and then under Form Controls, click Scroll bar. Double-tap the cell, or tap in the formula bar. Click the worksheet location where you want the upper-left corner of the scroll bar to appear. Freeze columns and rows. This is for us to know if the issue is with the current Excel file only or not. Turn off Sticky Keys. Mar 10, 2014 · Hit Comma and enter zero for columns as we don’t want the columns to move. Step 2: Open a saved spreadsheet or create a new one. Jul 17, 2019 · In most applications, one can scroll horizontally using a combination of holding Ctrl/Shift and using the scrollwheel. Click on that button to disable the Scroll Lock feature. And in most applications, one can also scroll horizontally by nudging the scrollwheel sideways if the mouse has that feature (mine does). Enabling scroll in Excel leads to increased efficiency, enhanced user experience To use the fill down keyboard shortcut to copy formulas, select the range of cells that you want to copy formulas into, where the top cell of your selection contains the formula to be copied. Click on the Table command of the Insert tab. Check the Status Bar in Excel. Apr 16, 2024 · Method 3 – Hide and Lock Top Rows in Excel. Tap, then drag the selection handler. Welcome to another episode of the MrExcel Podcast, where we help you become an Excel pro. Right-click on the row number above where you want the floating information and select ‘Insert’. Address End Sub Jan 9, 2024 · Steps to copy a formula to an entire column automatically with an Excel table: Select your entire table. See, ScrLk is marked/highlighted. Another way to expand the formula bar in Excel is by using the shortcut Ctrl + Shift + U. Now, On-Screen Keyboard appears. That means Scroll Lock is turned on now. Select More on the sidebar and select Options . May 21, 2024 · Step 1. Step-by-step guide on how to adjust the horizontal scroll bar. As a result, Excel scrolls one row at a time. Copy your function across 3 cells in my example and 10 rows down. Select Hide. Select the cell containing the formula, and press Ctrl + Shift + Down . This saves you the time and effort of navigating through the sheet navigation buttons in the bottom-left corner of the Excel window. Then, press the Up or Down arrow keys on your keyboard. Click on ‘ Format Control. This will open up the power query editor and you will be able to add a column with serial numbers from here. Click the ScrLk key to turn off the scroll lock. As a result, the list of the prevailing worksheets will appear on the right side of the active sheet. Mac Excel 2011 doesn't show scroll lock status anywhere. In the next article, we are going to talk about more serious things such as evaluating and debugging Excel formulas. Step 2: Go to the "Developer" tab on the Excel ribbon and click on the "Insert" button in the "Controls" group. After selecting the column, click on the ‘View’ tab in the Excel ribbon. Again click on the Show Formulas command. Jun 10, 2021 · 1. See full list on support. Deselect all add-ins and select OK. Freeze the first two columns. The “Go To” function can also help you quickly navigate to the bottom of your Excel spreadsheet. Some keyboards may require the use of a function (Fn) key in combination with the "Scroll Lock" key. You should see a new menu with three options. The quickest way to remove Scroll Lock in Excel on Windows is to use the keyboard shortcut: press the Scroll Lock key. When using the Freeze Panes shortcut, remember to select the cell directly below and to the right of the rows and columns you want to be frozen. Press the R key to Freeze Top Row. To restore the default formula bar size, press this shortcut again. Selects one cell in the direction of the arrow. Go to the cell where you want to display the result of the formula. Explore the full course and increase your Excel efficiency: ht Enable the Developer tab. Ctrl+Arrow key. If you are selected in a formula and hit F2, it will switch so that the arrow keys move the cursor Sep 17, 2015 · Using the arrow keys while an empty cell is selected moves the selection to the adjacent cell, as normal. The steps to insert the Scroll Bar in Excel are as follows: Step 1: Select the “ Developer ” tab → go to the “ Controls ” group → click the “ Insert ” option drop-down → select the “ Scroll Bar (Form Control) ” symbol from the “ Form Controls ” category, and insert the Scroll Bars by Provide step-by-step instructions for freezing a cell in Excel formula: Select the cell: Click on the cell that you want to freeze in the formula. Note the icons as they provide visual clues. Using the "Scroll Lock" key or alternative methods can enable scroll in Excel. For example, the following formula inserted into cell B2 in your screenshot will offset to the right when it is copied downward (it uses the numbers in column A as the offset values): Jan 16, 2024 · Moves by one cell in the direction of the arrow. The active cell that follows the movement of the cursor will remain visible. This should select all cells in that column between the selected cell and the very bottom. Then select Excel Add-ins > Go. VBA code 1 (restrict the range you specified) Sub Set_scroll_area() 'Change the below range address according to your wish Dim ws As Worksheet ws. This Mar 22, 2022 · To get started, open your workbook and head to the sheet you want to use in Excel. Click on the ScrLk key to turn off the screen lock feature and the blue highlight will be removed. Type the cell reference to jump to, and press Enter. Open a blank workbook and enter the formula =CON CAT (“Word ”&TEXT (SEQUENCE (3276), “0000 ”)) in cell A1. Press the Scroll Lock key on the physical keyboard to turn it off. It is typically found in the top row, near the "Print Screen" and "Pause" keys. Mar 2, 2023 · Additionally, excessive formulas, rows, columns, or objects within a worksheet can overload Excel’s capabilities, resulting in scrolling difficulties. When you see the virtual keyboard, to activate Scroll Lock, click the ScrLk button. Select Advanced on the sidebar and scroll to the “Display options for this workbook” section. Activate the Developer Tab in your Excel spreadsheet . Position yourself where you need to enter information. You will see a solid green border at the top after hiding the rows. Select the Keyboard option on the left sidebar of the Settings window. With smooth scrolling enabled, users can now swiftly move up or down large blocks of data without any jarring motion. Oct 11, 2023 · Step 4: Format the Scroll Bar. Now, we will be able to scroll with the arrow keys. Excel will add the Developer as a new tab, as shown in the image below. In this blog post, two methods to lock a cell in an Excel formula have been discussed with examples. Mar 10, 2024 · Press and hold the Ctrl key on your keyboard. Next, select the entire new row by clicking on its number on the left-hand side of the screen. Jan 10, 2024 · Open a Notepad. Tap on a cell, and then flick the selection handle in the direction you want to select. Step 4: Under the Controls group, click Insert, then select the SCROLLBAR control. May 7, 2024 · Cell anchoring in Excel provides numerous advantages, including the ability to reference specific cells in a formula and prevent unintended changes when copying formulas. To deactivate the lock, click the same key again. Now copy the formulas from the Notepad and paste them to your destination cells of the sheet. Mar 16, 2018 · I shut down all Office programs first, then opened Excel, clicked on File > Account then Sign Out. Then, we will see the “ Scroll Lock ” is not there anymore on the Status Bar. The key should no longer be blue when Scroll Lock is off. Select View > Freeze Panes > Freeze First Column. In the Format Control dialogue box, go to the ‘Control’ tab and make the following changes: Explanation: The maximum value is 21 because we will display ten elements in the list. Mar 21, 2023 · Formula bar shortcut. Select the Navigation command under the Show option. May 7, 2024 · Step 1: Open Microsoft Excel on your computer. These are vertical and horizontal scroll bars. Note that if there are blank cells in the column, Ctrl+Down Arrow may not take you to the very last row with data, and Ctrl+Up Mar 6, 2018 · To open the On-Screen Keyboard, click the Start button on your Windows desktop and type On-Screen Keyboard. May 20, 2023 · Step 3: Lock the selected cells. Scroll lock is a feature in Excel that allows users to lock the position of the cell pointer while scrolling through a worksheet. Aug 13, 2022 · Open that keyboard by accessing the "Start" menu, searching for "On-Screen Keyboard", and selecting the app in the search results. This can be accomplished using a few simple steps. The faint line that appears between Column A and B shows that the first column is frozen. Step 3: See the scroll bars to the right and bottom of the screen. Or, you can also use the shortcut key, CTRL + T instead of Step_2. Click on the column header to select the entire column. Ctrl+Shift+Arrow Key. Press the Down Arrow key to jump to the last row with data or the Up Arrow key to jump to the first row with data. Click Freeze Top Row or Freeze First Column. Thus, we have finished the first solution to our issue. Click the On Screen Keyboard slider button to turn it on. End, Arrow key. May 20, 2023 · Using the Keyboard Shortcut. Note: If you can not find the Scroll Lock key on the physical keyboard, use an on-screen keyboard. This is the same functionality as when editing a formula in a cell. May 14, 2024 · The fastest way to switch between sheets in Excel is to use the shortcut key combination “CTRL” + “PgUp” to switch to the previous sheet and “CTRL” + “PgDn” to switch to the next sheet. Here’s an example. Instead, it creates a "+" formula, using the location of the second cell. To find a recent add-in you installed and disable it, select File > Options > Add-ins. You can then use the Count Numbers option in the Sum list or enter the formula manually. Jan 23, 2024 · To navigate worksheet tabs using the Navigation Pane, apply the following steps: Go to the View tab. Subscribed. Pressing “Ctrl” + “Down Arrow” will take you directly to the last cell of your spreadsheet. Enter the End mode, move to the next nonblank cell in the same column or row as the active cell, and turn off End mode. Choose "Freeze Panes": From the drop-down menu, select the "Freeze Panes" option. To turn off SCROLL LOCK, click the ScrLk key, and then close the On-Screen Keyboard. Or, Press CTRL+D to quickly fill the formula down to the specific row. Right-click on the selected cells and choose Hide. Select multiple cells. Open Excel in Safe mode. If the address doesn't change, Scroll Lock is probably turned on. Tap a cell. A. The only way I know to verify the Scroll Lock state is to use the arrow keys and observe behavior. Right-click on the control. The Scroll Lock indicator on the status bar goes away when Scroll Lock is off. When you start entering something in a cell, you can press F2 to use the cursor keys to move in your formula bar and press F2 again to switch back to "cell move" mode. Type osk in your Desktop/PC search box to access the on-screen keyboard. Define what scroll lock is in Excel. In this article, I’ll provide you with a descriptive article on scroll bar in Excel. Closed Excel, reopened and logged back in. com. Move to the last cell on a worksheet, to the lowest used row of the rightmost used column. Dec 21, 2023 · Last updated: Dec 21, 2023. ) Select the File menu, then click on Options. Look for ‘Window’ group in the middle of the ribbon and select ‘Freeze Panes’. From there, if you want to freeze the first row, click on the “Freeze Top Row” button. Click the Use the On-Screen Keyboard toggle button to turn it on to display the On-Screen Keyboard. However, Excel offers a convenient tool to quickly navigate and select cells without the need for scrolling – the Scroll Bar. To move through the formula using the keyboard, select anywhere in the formula and hit the F2 key. When working with large Excel sheets, it can be time-consuming to manually scroll through rows and columns to select a large range of cells. We can customize the status bar to set which information to show on it. Dec 19, 2023 · Conclusion. This article explains how to navigate Excel quickly between worksheet tabs and around large worksheets using various shortcuts and Add a scroll bar (Form control) On the Developer tab, in the Controls group, click Insert, and then under Form Controls, click Scroll bar . You do need to be in the formula as opposed to the Formula Field at the top of Feb 2, 2016 · About Press Copyright Contact us Creators Advertise Developers Terms Privacy Policy & Safety How YouTube works Test new features NFL Sunday Ticket Press Copyright Aug 13, 2022 · Open that keyboard by accessing the "Start" menu, searching for "On-Screen Keyboard", and selecting the app in the search results. Navigate to the ‘File’ tab and select ‘Options’. The scroll wheel wont work though. To orient the scroll bar from left to right, drag one Activate the Scroll Lock feature by pressing the 'Scroll Lock' key on your keyboard. This will copy down the formula that is in the top cell of the selection, through the whole range/column selected. This will keep the first row fixed at the top of the screen, even as you scroll through the data below it. Jul 1, 2014 · Let us isolate the issue by copying the data you're using on your vlookup function and pasting it on a new Excel file. The first thing you need to do is select the column you want to keep fixed. Apr 26, 2024 · Open your worksheet. com Dec 21, 2023 · 1. If you just use the arrow keys, it will select cells for use in the formula. 💡 Tip: Use the Ctrl + Win + O keyboard shortcut to open the virtual keyboard app. Click the Sum button in the Editing section of the May 18, 2024 · When the formula matches, it returns TRUE, else it returns FALSE. The On-Screen Keyboard app will appear. You don’t need to sign-up or do anything to get access to the course. Jun 24, 2020 · Disable suspicious add-ins. If your keyboard does not have a Scroll Lock key, on your computer, click Start and then press CTRL+C to display the Charms bar. Select the checkboxes next to Show horizontal scroll bar and Show vertical scroll bar . Here, the function returns the lowest row number assigned as the row_num argument in the INDEX function. 151K subscribers. Scrolling Using the Arrow Keys. STEP 3: Click on “ Freeze Panes ” in the Window group. ko uq nz db cy ll kk qh hs us