The Best Mouse for Excel? Logitech MX Master Review

If you use Excel all day every day like I do, then you know it's important to have a keyboard and mouse you love.  I've talked about the best keyboards for Excel before, and in this article we'll take a look at a great mouse that can help us get our job done faster.

Best Mouse for Excel - Logitech MX Master Mouser

The Logitech MX Master Mouse is like the Tesla of computer mice, both in price ($67-$100) and performance.  It has a futuristic look to it, and it's also packed with some great features for Excel users.

The mouse has a dedicated thumb wheel for horizontal scrolling and customizable buttons that you can assign Excel keyboard shortcuts to.  Yep, keyboard shortcuts on your mouse!

I've been using the MX Master for over two years and I think it's a great mouse.  There is also a newer version called the MX Master 2S, and I explain the differences below.

Here are the Amazon links to the MX Master and MX Master 2S.  Each mouse comes in 3 different colors.

My Favorite Features of the MX Master

Beyond the futuristic look, the MX Master has some cool features that make it a great mouse for Excel.

  1. Thumb Wheel for Horizontal Scrolling
  2. Customizable buttons for Excel and other applications
  3. SmartShift vertical scroll wheel for smooth and ratchet scrolling
  4. Rechargeable battery built-in
  5. Wireless connection with USB Unifying Receiver or Bluetooth for 3 devices
  6. Gesture Button for even more Excel shortcuts

Let's take a look at each of these and see how they can help us with Excel.

1. Thumb Wheel

One of the unique features of the MX Master is the Thumb Wheel for horizontal (side-to-side) scrolling.  The small wheel is located right above your thumb.  You can spin the wheel up or down with your thumb to scroll left or right.

Logitech MX Master Thumb Wheel Horizontal Scrolling Excel Spreadsheets

A lot of modern applications and web pages have eliminated horizontal scrolling, but Excel is still one app where we need it.  If you have large worksheets with a lot of columns, then you know how time consuming it can be to scroll left or right.  We typically have to move the mouse cursor down to the scroll bar on the bottom of the application, or use a keyboard shortcut to find the column we are looking for.

The thumb wheel on the MX Master makes for a much better “column hunting” experience.  It scrolls horizontally almost an entire screen width with one scroll up/down of the thumb on a 1920×1080 screen.

The only downside is that you have to remember the scroll wheel is there, and make a habit of using it.  If you do a lot of horizontal scrolling while applying filters, then checkout my Filter Mate Add-in to save time with that process.

2. Customizable Buttons for Excel Keyboard Shortcuts

The settings of the MX Master can be customized with the accompanying Logitech Options software.  The mouse has 6 buttons that can be programmed.

Logitech Options Application Control MX Master Mouse Settings

The cool part is that you can program the buttons for different applications.  This is a really handy feature!

For example, the mouse has the typical Back and Forward buttons.  When in your web browser these buttons can be used to press the Back and Forward buttons for web browsing.

However, when working in Excel, you can have these buttons navigate to the next/previous tab, undo/redo, copy/paste, or just about any action you can do with a single keyboard shortcut combination.  The mouse detects which application you are working in and the customized buttons work automatically.  You don't have to take any extra steps to activate them.

Here's how to setup the MX Master mouse buttons with custom keyboard shortcuts:

  1. Select Mouse from the top-left corner in the Logitech Options window.
  2. Select or add the Application (Microsoft Excel) from the top-right corner.
  3. Left-click the Forward button on the mouse diagram.
  4. Choose Keystroke Assignment from the list of actions
  5. Left-click in the Enter Keystroke box, then press the keyboard shortcut for the command.
Setup Logitech MX Master Mouse Excel Keyboard Shortcuts Part 1
Click to view full size
Setup Logitech MX Master Mouse Excel Keyboard Shortcuts Part 2
Click to view full size

That's it.  The mouse button will now press the keyboard shortcut.  Open Excel and try it out.

Here is a list of keyboard shortcuts you may want to assign to the Back and Forward buttons:

  • Previous Tab (worksheet): Ctrl+Page Up
  • Next Tab (worksheet): Ctrl+Page Down
  • Undo: Ctrl+Z
  • Redo: Ctrl+Y
  • Select Entire Row: Shift+Space
  • Select Entire Column: Ctrl+Space
  • Select First Cell: Ctrl+Home

There are also dedicated actions for Copy & Paste.  Just about any dedicated keyboard shortcut can be assigned in the Keystroke Box.  If the shortcut is multi-step like Alt, A, C to clear filters, then it will not work with the mouse.  However, you could assign Ctrl+Shift+L to turn filters on/off.

3. SmartShift Vertical Scroll Wheel

The vertical scroll wheel on the MX Master is another awesome feature.  It has two settings that can quickly be toggled with the button behind the scroll wheel.

The Smooth Scrolling setting allows the wheel to spin freely.  You can give the wheel a flick with your finger and it will continue to spin and scroll.  This is great if you are on a really long web page, or spreadsheet.  You can quickly scroll down to the bottom of the sheet.

SmartShift Scroll Wheel Settings for Logitech MX Master S2

With one flick of the wheel I was able to scroll down 8,694 rows.  You can have a competition with your co-workers to see who can scroll the farthest.  Then make sure to update your resume with your newfound skill… 😉

Clicking the button behind the wheel toggles the Ratchet Scrolling mode.  This is for more precise scrolling where the wheel clicks into place with each scroll.  On a spreadsheet, the scroll only moves 2 or 3 rows at a time.

The mouse also has a SmartShift feature which allows you to use a combination of both modes.  You can keep it in ratchet mode for precise scrolling, and then give the wheel a firm flick and it will click into a smooth scrolling free spin.  This allows you to jump down a page, then scroll precisely in the same mode.  It's kind of fun, and you just have to mess with it to figure out what you like.

SmartShift can be turned on/off in the Logitech Options software, and you can also set the sensitivity of how hard you need to flick to get it into free spin.

4. Rechargeable Battery

The worst part about wireless mice is running out batteries right as your finishing a project and trying to get home on time.  Fortunately, the MX Master has a rechargeable battery built-in.  You charge the mouse with a micro USB cable (included).

Logitech MX Master Rechargeable Battery Built In

The mouse can be used while it is charging.  The micro USB connection is on the front of the mouse, so it just looks like a wired mouse while you are charging it.  I get over 2 weeks of use on a single charge, and you get a notification on your computer when the battery is running low.  There are also battery indicator lights on the mouse.

5. Wireless Connection USB or Bluetooth for 3 Devices

The MX Master includes a small USB wireless receiver that you can plug into your computer to connect the mouse.  It uses Logitech's Unifying technology, which means you can also pair a Logitech Keyboard to the same USB receiver.

MX Master Wireless Connection USB Unifying or Bluetooth

The mouse has 3 memory presets for different devices.  So you can connect to 3 different computers via Bluetooth or Unifying USB, and press a button on the bottom of the mouse to switch devices.

Checkout my article on the best keyboards for Excel where I talk about the Logitech K270 keyboard.  You can connect both the mouse and keyboard to the same USB Unifying Receiver, which helps free up your USB ports.

6. Gesture Button

As you can see in the pictures, this mouse has a thumb rest.  It helps place your thumb in the right spot for the thumb wheel.

There is also a button under the thumb rest.  Pressing this button brings up Task View where you can see all the open windows on the computer.

Logitech MX Master Gesture Button

You can also perform gestures by holding the button and moving the mouse up/down/left/right.  Checkout the image to see what each gesture action does.

The button and gestures are completely customizable.  Logitech has pre-built options for navigating and arranging windows, or even media controls like volume up/down.  You can also completely customize these gestures, and do so for each application.

Logitech Options MX Master Gesture Settings

That means you can create gestures for 5 additional keyboard shortcuts or actions in Excel.  Of course this is going to take some getting used to, but if you are a heavy mouse user then these shortcuts could become your best friend.

Excel Keyboard Shortcuts for Mouse Gestures on Logitech MX Master

What I Don't Love

This mouse is packed with features that make it a great companion for Excel.  If I could change anything about it I would make the Back and Forward buttons bigger.  They are hard to find at first, and it definitely takes some getting used to.  I guess I have big hands and thumbs, so that might be part of the problem… 🙂

Logitech MX Master S2 Forward Button Small

What's the difference between the MX Master and 2S

Both the MX Master and 2S are physically very similar.  The 2S has a new Flow feature that allows you to control two computers at the same time without having to click the button on the bottom of the mouse.  If you don't use 2 computers at the same time then the original MX Master is a great choice.

Logitech MX Master vs 2S

The MX Master is currently $67 to $79 on Amazon, depending on color.   The MX Master 2S can be found for $94 to $99 on Amazon.  Each comes in black, blue, or light grey.  Both mice are compatible with PC or Mac.

Is the MX Master the Best Mouse for Excel?

That's a highly subjective question.  A mouse is a personal choice.  I believe you have to try them to find the one that feels and works the best for you.

When I first got the MX Master I didn't love it.  It was a different feel from my previous mouse (the Logitech M510), and took some getting used to.  But I committed to trying it for a few weeks, and now it's been my daily driver for over two years.  It's a big, comfortable mouse, and the smooth vertical & horizontal scroll wheels are probably my favorite features.

If you're saying, there's no way I would pay that much for a mouse, then checkout the Logitech M510 (Amazon Link).  You can get that mouse for $15 on Amazon and it also uses the wireless Unifying technology to pair with my favorite keyboard for Excel.

Otherwise, the MX Master is definitely worth a try, and would make a great gift for your favorite Excel geek. 🙂

Here are the Amazon links to the Logitech MX Master and MX Master 2S.

What keyboard shortcuts would you program the MX Master's buttons with?  Please leave a comment below with your answer.  Thank you! 🙂

  • The most important feature of a mouse is a trackball for you thumb to move the cursor instead of your hand (see Logitech M570).

    I would go for the MX Master if it had this feature, without it my productivity would drop drastically.

  • Thanks Jon – still jealous of all you right-handed people who get the cool tech gadgets. Logitech still has no plans to make either of these models in a left-handed version 🙁

  • Looks a great mouse, I use the Logitec G602 gaming mouse which has 11 programmable buttons. The added advantage is that it auto detects which software package you are using, it then auto switches to the macros or shortcuts that you have programmed for each button for each piece of software.

  • Do they only make right-handed ones? I use the completely symmetric Logitech M100. No bells and whistles, but does its job. Also it is not wireless, so when it burrows under my papers, which mice are apt to do, I can pull it out by its tail.

    • Hey Jon,
      Haha too funny! 🙂 Unfortunately they only make it right-handed. I’m mostly left-handed too except for writing and mousing, so I agree it’s nice when companies accommodate us 11%…

  • I’m right handed but have used a mouse left handed for over 25 years (makes sense to me when you look at keyboards where the number pad is on the right). Damn annoying the lack of Left handed options

    • Hey John,
      Yeah I know a lot of people do the same. At one of my previous jobs most of the call center team learned to mouse left-handed so they could write and use the number keys at the same time.

      I’m mostly left-handed and understand the annoyance of limited product options like this. I guess we’ll have to start a campaign to make more left-handed people… 😉

  • Thanks Jon, always very informative, I use the Logi M570 trackball and have found it great, I also benefit from large hands!

  • I have been using the original version for almost two years, and I love it. Thank you for all the customisation hacks, they seem great ! I personnally really like the horizontal scrolling wheel.

  • Hi Jon, I purchased this mouse based on your recommendation. The only instructions I could find on the mouse was the instructions contained in your blog. The mouse did not come with instructions on how to program it, nor could I find instructions or an owner’s manual on the Logitech website. So, thank you for the very nicely illustrated instructions on how to program this mouse. The numerous features it comes with can be very overwhelming. I will start with a few basics and build from there. Thanks so much!

  • If you really want to master excel you should avoid using the mouse at all costs. It’ll make you more efficient in the long run.

    I agree that this is a great mouse though and I use it for my computers as well.

  • I think the Logitech m720 triathlon mouse is always sadly forgotten by most. It can do EVERYTHING the MX can do and in some cases better. It lacks the Second wheel but you can tilt the Main scroll wheel left/right and hold. This saves you from scrolling like mad if you have a long way to go. The forward and back button are in a better position just like the MX Master 3 and the computer switch button is NOT on the bottom of the mouse which makes it super easy to switch to my phone to take speaker phone calls or send a quick text. it’s smaller than the MX 2s but still works for my large hand.

  • Hi, I was wondering how you are able to utilise the horizontal scroll feature on Excel? My MX Master 2S can’t scroll horizontally there but can on every other application. Thank you!

  • Can you share information regarding your laptop and it’s specs. Do you use a regular laptop or a 2-in-1? Are there tradeoffs between the two if you are using the Power applications – Query, Pivot, and BI?

  • Hello Jon!
    Thanks for your article..I found it very interesting.

    Do you know if the Logitech M510 is
    it compatible with mac?

    I was assigned a MacBook at work (Retina, 12-inch, 2017)
    and it is really inconvenient to use.

    Thank you so much for your answer

  • Search
    Generic filters
    Exact matches only


    Learn 10 great Excel techniques that will wow your boss and make your co-workers say, "how did you do that??"
    Plus weekly updates to help you learn Excel.

    Download the eBook

    Excel Shortcuts List

    keyboard shortcuts list banner

    Learn over 270 Excel keyboard & mouse shortcuts for Windows & Mac.

    Excel Shortcuts List

    Join Our Weekly Newsletter

    The Excel Pro Tips Newsletter is packed with tips & techniques to help you master Excel.

    Join Our Free Newsletter

    About Me

    Jon Acampora Profile

    Hello and welcome! My name is Jon Acampora and I'm here to help you learn Excel.

    This blog is updated frequently with Excel and VBA tutorials & tools to help improve your Excel skills and save time with your everyday tasks. Subscribe above to stay updated. More about me...


    Free Excel Training Webinar Modern Power Tools