Where Is The Properties Dialog Box In Excel: Quick Access Guide

I’ve watched countless users spin their wheels looking for Excel’s properties. The dialog box isn’t hiding—it’s just moved between versions.

In Excel 365 or 2019, you’ll find it under File > Info. Older versions like 2016 stash it under File > Properties. The shortcut Alt+F, I, P works across most modern versions.

This isn’t just metadata—it’s where you set document titles, tags, and even custom properties for tracking. One stop for all your file details.

Works the same whether you’re on Windows or Mac, though the Mac path reads Excel > Preferences > User Info for some settings.

What Youll Need

Instructions

Here’s the quickest way to find this often-overlooked dialog in any Excel version.

Open your workbook and navigate to the File tab in the top-left corner. This is the most reliable method across all modern Excel versions. Click Info in the left-hand menu, then look for the Properties section on the right.

You’ll see a Properties dropdown with Advanced Properties at the bottom. Clicking this launches the dialog directly. The window should appear within 1-2 seconds without any additional prompts.

For a slightly faster approach, look at the very top of your Excel window where your workbook’s name appears as a tab. Right-click this tab to reveal a context menu. The Properties option appears near the bottom, just above Close.

Selecting this opens the same dialog as the ribbon method. I prefer this route when I’m already working in the file and want to avoid navigating through the backstage view. The dialog appears instantly with all standard metadata fields visible.

Press Alt+F to open the File menu, then I to select Info. From here, you can use Tab to navigate to the Properties section and Enter to open the dropdown. Use the arrow keys to select Advanced Properties and press Enter again.

This sequence takes about 3-4 seconds with practice. The method works identically in Excel 2013 through 365. You’ll know it worked when you see the Summary, Statistics, and Custom tabs at the top of the window.

The Properties dialog contains multiple tabs. The Summary tab shows basic metadata like title and author. The Statistics tab reveals creation date and modification counts. The Custom tab allows adding user-defined properties.

If you don’t see these tabs, you’ve opened the wrong dialog. Some users confuse this with the Format Cells dialog or the Document Inspector. The correct window always has Microsoft Office in its title bar and shows file-specific information that persists with the document.

Tips and Common Mistakes

The little details that make finding the Properties dialog effortless every time.

The Ribbon Method: I’ve found that navigating through the File tab to Info and then to Advanced Properties is the most consistent across Excel versions. This approach works even if your ribbon layout has been customized, as the Properties section remains in the same place.

Right-Click Shortcut: When you’re deep in a project, the right-click method on the file tab saves time. It bypasses the backstage view entirely, which is especially helpful if you’re toggling between multiple workbooks. The dialog appears instantly, so there’s no waiting around.

Keyboard Efficiency: The Alt+F, I, Tab, Enter sequence is a game-changer for power users. With practice, you can open the dialog in under 3-4 seconds. I use this constantly when I need to check metadata without breaking my workflow.

Verification Tip: Always glance at the title bar to confirm you’re in the correct dialog. If you see Microsoft Office followed by your workbook name, you’re in the right place. The presence of the Summary, Statistics, and Custom tabs is your final confirmation.

Frequently Asked Questions

Now you know exactly where to find the Properties dialog box in Excel—whether through the File menu, right-click, or keyboard shortcuts! 🎯 Take a moment to practice opening it in a test workbook to build confidence. For more Excel tips, explore our other guides to boost your productivity!