Essential to Expert Skills progression

Excel tutorials

The only Excel books you will ever need

  • The only constantly updated Excel 365 titles more…
  • Thoroughly covers Power Pivot and Power Query more…
  • Covers business intelligence and OLAP features more…
  • Simple, easy, understandable, 2-page lessons more…
  • Available as both printed books and e-Books more…
  • Used by schools, colleges and universities  more…
  • Available for 365, 2019, 2016 and Mac versions more…

Horizontal scrolling with the mouse in Excel

Most modern mice have a ‘mouse wheel’ that also acts as a middle mouse button. Rolling the mouse wheel up and down lets you quickly scroll up and down an Excel workbook.

You can zoom in and out of a workbook by using the mouse wheel while holding the  key, so you might expect there to be a similar keyboard shortcut to scroll horizontally. Unfortunately there isn’t a keyboard shortcut to do this, but there are two ways to scroll horizontally using the mouse.

Scrolling and navigating Excel workbooks and windows is covered in depth in our free Basic Skills E-book. It’s a great place to start for anyone who wants to improve their Excel skills.

Auto Scroll

If you click the mouse wheel (or ‘middle click’), the cursor changes into a four-headed arrow icon and ‘Auto Scroll’ is enabled. Auto Scroll allows you to scroll in any direction by moving the mouse in the direction you wish to scroll.

Auto Scroll remains enabled until you click the mouse.

The horizontal scrollbar

A horizontal scrollbar can be found at the bottom of the Excel window. Clicking the scrollbar arrows or clicking and dragging the scrollbar allows you to scroll horizontally.

You can also speed up horizontal scrolling by holding down the <Shift> key before using the scrollbar.

Share this article

Share on facebook
Share on twitter
Share on linkedin
Share on stumbleupon
Share on email

Recent Articles

Excel protected view warning

Excel protected view: Be careful – files from the Internet can contain viruses. Unless you need to edit it’s safer to stay in Protected View. This article explains what this error message means.

VLOOKUP inexact match illustration (chicken and egg).

VLOOKUP inexact match

VLOOKUP lesson with sample file that will teach you everything there is to know when creating a VLOOKUP inexact match Excel function.

VLOOKUP exact match

Simple VLOOKUP tutorial with sample file that will teach you everything there is to know when creating a VLOOKUP function with an exact match.

Clients

When you use The Smart Method you’re in good company Here are some of the companies that The Smart Method have helped empower with excellent

Microsoft Office update channels

Microsoft Office update channels are explained in this article. Beta, Current, Monthly Enterprise and Semi-annual enterprise are all covered.

Leave a Reply

Your email address will not be published.

3 + seven =