Excel Right Click Menu Options That Save Real Time

A colleague of mine, a sharp analyst and meticulous with data, spent the better part of 45 minutes reformatting a quarterly report last year. She was manually copying values, resizing columns by hand, reapplying borders one cell at a time. I watched her do it. I didn't say anything until she finished, because I know how satisfying it is to complete something you've been grinding through. Then I showed her Paste Special. The look on her face was not gratitude. It was mild fury. Everything she'd just done was available in the Excel right click menu, two clicks from where she started.

That's not a rare story. Most Excel users right-click constantly. They just never scroll past Copy and Paste. The context menu has a lot more in it, and the specific options it shows depend entirely on what you've clicked on. That's the part most guides skip over. This article maps the right-click menu by context, covers the underused right-click-drag technique, and addresses what to do when the menu disappears entirely. If you're just getting oriented with the application itself, the Excel for Beginners starter guide is a good place to start before diving into menus and shortcuts.

---

What You'll Learn, and When the Excel Right Click Menu Actually Changes

The right-click context menu in Excel isn't one menu. It's several, and Excel decides which one to show based on what you've selected. Right-click a cell and you get formatting and paste options. Right-click a row header and you get insert, delete, and hide. Right-click a sheet tab and you get an entirely different set of navigation and organizational tools. Right-click on a chart or image and the menu shifts again.

I've logged over 300 shortcuts across my Excel workflow, and the right-click menus account for a surprising chunk of them, not as tricks, but as the fastest path to options that would otherwise require three ribbon clicks and a dialog box. By the end of this, you'll know the most useful options across the main contexts, how to use the right-click-drag menu most users don't know exists, and how to fix the menu when it stops working.

All options described here were tested in Excel 2016, 2019, and Microsoft 365.

---

Step 1: Navigate the Excel Right Click Menu by Context

The fastest way to understand the right-click menu is to stop thinking of it as one thing and start thinking of it as three or four different tools that happen to live in the same place.

Right-clicking a cell or selection

This is where most people spend their time, and where most of the value is buried. When you right-click a single cell or a selected range, you'll see the standard shortcut menu with Cut, Copy, and Paste, but the options below those are the ones worth knowing.

Paste Special is the one I use every day without exception. After copying data from an external source (another workbook, a web export, a database pull), I never paste directly. I right-click, choose Paste Special, and select Values Only. This strips out any formulas, formatting, or references from the source, and you get clean numbers.

I spent two hours once debugging a formula that was returning wrong results because a copied cell carried a trailing space nobody could see. Paste Special, Values is what prevents that problem entirely.

It's not just a convenience. It's a data hygiene decision.

The Format Cells option in the cell context menu opens the same full formatting dialog you'd reach via Ctrl+1: number format, alignment, borders, fill, protection, all of it in one place. No ribbon hunting. One right-click.

On Mac, the right-click cell menu is largely the same in Microsoft 365, though the Paste Special dialog has a slightly different layout and a few options appear in different order. Worth checking if you switch between machines.

Right-clicking a row or column header

Click the number on the left side of a row (or the letter at the top of a column) to select the whole thing, then right-click. The menu that appears is completely different from the cell menu. Here you'll find Insert, Delete, Row Height or Column Width, Hide, and Unhide. These are the options that make bulk structural edits fast. Need to insert three rows above row 12? Select rows 12 through 14 by clicking the row headers, right-click, choose Insert. Done. Excel inserts exactly as many rows as you had selected.

This is also the fastest path to hiding rows or columns without deleting them, useful for clean printing or decluttering a view without changing the data underneath. To unhide, select the rows or columns on either side of the hidden ones, right-click, and choose Unhide. It works the same way in Windows and Mac.

---

Step 2: Use the Right Click Drag Menu to Move and Fill Data in One Motion

Once you've spent time with the standard right-click context menu, this one is going to feel like finding a room in a house you've lived in for years.

Most people drag cells using the left mouse button. Try it with the right mouse button instead. Here's how:

1. Select the cell or range you want to move.
2. Hover over the border of the selection until your cursor changes to a move arrow (four-directional).
3. Hold the right mouse button and drag the selection to a new location.
4. Release the button. A small shortcut menu appears with options: Move Here, Copy Here, Copy Here as Values Only, Copy Here as Formats Only, Link Here, Create Hyperlink Here, Shift Down and Copy, Shift Right and Copy, and Fill Series.

The one that changes how you work: Copy Here as Values Only. You can move formula results to a new location, as static values, in one drag. No copy, no Paste Special dialog, no extra steps. I used to miss this completely because I'd always defaulted to Ctrl+C without thinking about it.

The right-click-drag menu is exclusive to Windows. Mac users with a standard trackpad won't have access to it the same way, though an external mouse with a right button restores the behavior in Microsoft 365.

---

Common Mistakes: When the Excel Right Click Menu Is Missing or Not Working

The two failure states I see most often: the menu doesn't appear at all, or it appears but is missing options that should be there. Both are fixable.

If the right-click menu disappeared entirely, the first place to check is File, Options, Advanced. Scroll down to the "Editing options" section and look for "Show shortcut menus on right click." If that box is unchecked, that's your answer. Check it, click OK, and the menu comes back. This setting somehow gets toggled by add-ins or by users who hit it accidentally. I've seen it show up as a mystery on r/excel more than once in 2025 and 2026.

If specific options are missing (like Insert Comment or Hyperlink), the sheet is likely protected. Go to Review, Unprotect Sheet (you'll need the password if one was set). Protection locks down what the right-click menu exposes. That's by design, but it catches people off guard on inherited workbooks.

If right-click isn't working at all in Microsoft 365 on Windows, an add-in conflict is the usual culprit. Open Excel in safe mode (hold Ctrl while launching), test the right-click menu, and if it works there, an add-in is interfering. Disable them one by one via File, Options, Add-ins, Manage COM Add-ins.

On Mac, if the right-click context menu isn't appearing, check your mouse or trackpad settings in System Preferences. Two-finger click or "secondary click" needs to be enabled. Excel itself doesn't control that setting on macOS.

Right-click behavior you can't see often comes down to something set outside the file. That's the pattern. Check settings first, then protection, then add-ins, in that order.

---

Frequently Asked Questions