How to View the Scroll Bar in Excel 2010

Unless you are only dealing with small amounts of data in Excel 2010, then you have likely become dependent upon the horizontal and vertical scroll bars to move to data that is not currently visible on your worksheet. But if you accidentally removed a scroll bar earlier, or if someone else was using Excel on your computer and they removed the scroll bar, then you could have trouble navigating to the position in your spreadsheet where you need to be. Luckily the Excel 2010 Options menu has an setting where you can remove or restore a scroll bar that is no longer visible in the program.

 

How to Get the Scroll Bar Back in Excel 2010

There are a number of reasons why someone might want to remove a scroll bar in Excel, but it usually involves expanding the number of cells that are visible on the screen. But when you want to use a scroll bar to quickly move to another part of the spreadsheet, its’ absence can be a huge inconvenience.

 

Step 1: Click the File tab at the top-left corner of the window, then click Options at the bottom of the column at the left side of the window.

open the excel 2010 options menu

 

Step 2: Click the Advanced tab at the left side of the Excel Options window.

advanced tab on the excel options menu

 

Step 3: Scroll to the Display options for this workbook section.

Step 4: Check the box to the left of the scroll bar that you want to restore to view.

how to view the scroll bar in excel 2010

 

Step 5: Click the OK button at the bottom of the window to apply your change to the current workbook.

 

Do you find that you are often having problems when you print your Excel workbooks? Particularly that important data is not all fitting on one page, and you end up with additional printed pages that have one or two columns of data? Learn how to show page breaks in Excel 2010 so that you can see on your spreadsheet the data that is going to print on a particular page.

solveyourtech.com newsletter
vintage t rex t-shirt

Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.