The Best Mouse for Excel? Logitech MX Master Review - Excel Campus
15

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.

I also keep one of these Retractable USB/Lightning Cables in my desk and laptop case.  It can charge your iPhone, Android or mouse, and makes for a great stocking stuffer!

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! 🙂

Please share
Jon Acampora
 

Welcome to Excel Campus! I am excited you are here.
My name is Jon and my goal is to help you learn Excel to save time with your job and advance in your career.
I’ve been an avid Excel user and VBA developer for 10+ years. I am also a Microsoft MVP.
I try to learn something new everyday, and want to share this knowledge with you to help you improve your skills. When I’m not looking at spreadsheets, I get outdoors and surf. :) more about me

Click Here to Leave a Comment Below 15 comments
Lionel - December 8, 2017

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.

Reply
Bill - December 7, 2017

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

Reply
John Sadler - December 7, 2017

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

Reply
    Jon Acampora - December 8, 2017

    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… 😉

    Reply
Jon Peltier - December 7, 2017

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.

Reply
    Jon Acampora - December 8, 2017

    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%…

    Reply
Dave S - December 7, 2017

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.

Reply
    Jon Acampora - December 8, 2017

    Thanks Dave! Wow that is a lot of buttons! The MX Master auto detects the program you are in as well. I forgot to mention that in the article.

    Reply
Jeanette - December 7, 2017

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 🙁

Reply
    Liz - December 7, 2017

    I’m with you Jeanette. Lefties are left out in the cold.

    Proudly sinister!

    Reply
    Jon Acampora - December 8, 2017

    Hi Jeanette,
    Yes, unfortunately it’s right handed only… I’m mostly left-handed too, although I write and mouse right-handed. But a left-handed version would be nice!

    Reply
Gary Libeer - December 7, 2017

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.

Reply
    Jon Acampora - December 8, 2017

    Thanks for the suggestion Gary! I used to use a trackball and completely understand. Once you get used to them they are great.

    Reply

Leave a Reply: