See more worksheets, less scroll bar — Business Management Daily: Free Reports on Human Resources, Employment Law, Office Management, Office Communication, Office Technology and Small Business Tax Business Management Daily

See more worksheets, less scroll bar

by on
in Excel Training,Office Technology

Q. I have workbooks with a lot of worksheets. I don’t need the horizontal scroll bar. I’d rather see more worksheets. Can I get rid of it?

A. You can on a workbook-by-workbook basis. In Options (File>Options in 2010, Office Button>Excel Options in 2007), choose Advanced. In the Display options for this workbook section, uncheck Show horizontal scroll bar. You can use Alt+Page Up and Alt+Page Down to scroll left and right.

Leave a Comment