Hide/Show scroll bars and reset vertical scroll range in Excel

Scrolling in Excel is going up and down or left to right on a worksheet using the scroll bars, the arrow keys on the keyboard, or the mouse wheel. By default, Excel displays horizontal and vertical scroll bars along the bottom and right sides of the Excel screen, but you can hide them from view.

The instructions in this article apply to Excel for Office 365, Excel 2019, Excel 2016, Excel 2013, and Excel 2010.

  1. Hide and show scroll bars
  2. Resize horizontal scroll bar
  3. Fix Vertical Slider Slider Range
  4. Find last active line
  5. Delete last active row
  6. Check before you delete
  7. save the book

Hide and show scroll bars

To increase the display area of ​​the worksheet, hide the horizontal and vertical scroll bars.

Changing the visible scroll bar only affects the current workbook.

  1. Go to the tab File

  2. Select parameters:

  3. In the dialog box Excel options select Additionally

  4. Scroll down to the section Display options for this book (about half way).

  5. Uncheck the box to hide the horizontal scroll bar Show horizontal scroll bar

  6. Uncheck the box to hide the vertical scroll bar Show vertical scroll bar

    Check the box to show the hidden scroll bar Show horizontal scroll bar or check the box Show vertical scroll bar

  7. Select Okay to close the dialog box and return to the worksheet.

Resize horizontal scroll bar

If the number of sheets in a workbook grows so much that the names of all sheets cannot be read at once, you can solve it by making the horizontal scroll bar smaller.

  1. Place the mouse pointer on the vertical ellipse (three vertical dots) next to the horizontal scroll bar.

  2. The mouse pointer changes to a double-headed arrow.

  3. Drag right to decrease the horizontal scroll bar or drag left to increase the scroll bar.

Fix Vertical Slider Slider Range

The slider on the vertical scroll bar – the box that moves up and down on the scroll bar – changes in size as the number of rows in the worksheet containing the data changes. As the number of rows increases, the slider size decreases.

If the worksheet has a small number of rows of data, but the slider is very small and moving it causes the worksheet to jump up or down hundreds of rows, a row or cell far below the worksheet may be activated. To solve the problem, find and delete the line with the last activated cell.

Activated cells do not necessarily contain data. Changing the alignment of a cell, adding a border, or applying bold or underlined formatting to an empty cell can activate the cell.

Find last active line

To find the last row in the sheet containing the activated cell:

  1. Back up your workbook.

    The next steps involve deleting rows on the sheet. If rows of valid data have been accidentally deleted, the easiest way to get them back is to create a backup.

  2. Press the keys Ctrl+Home to jump to cell A1 on the worksheet.

  3. Press the keys Ctrl+End to jump to the last cell on the worksheet. This cell is the intersection between the bottom activated row and the rightmost activated column.

Delete last active row

Since you are not sure that no other rows are activated between the last valid data row and the last activated row, delete all rows below your data and the last activated row.

  1. Select the lines to be deleted. Select the row title with the mouse or press the keys shift + space on keyboard.

  2. Right-click on the row header of any of the selected rows to open the context menu.

  3. Select remove to delete the selected rows.

Check before you delete

Before deleting lines, make sure the last line of valuable data is the last line of valuable data, especially if the book is being used by more than one person. It’s not uncommon to hide data in a workbook, so do a thorough search before deleting any data.

save the book

Save the workbook after you delete the lines. Until the book is saved, the size and behavior of the slider on the scroll bar will not change.

Leave a Reply

Your email address will not be published. Required fields are marked *