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.
Step 2: Click the Advanced tab at the left side of the Excel Options window.
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.
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. After receiving his Bachelor’s and Master’s degrees in Computer Science he spent several years working in IT management for small businesses. However, he now works full time writing content online and creating websites. His main writing topics include iPhones, Microsoft Office, Google Apps, Android, and Photoshop, but he has also written about many other tech topics as well. Read his full bio here.
You may opt out at any time. Read our Privacy Policy
