You know that chart exists. You made it. It's in this workbook somewhere.

Sheet14? 16? Who named these sheets anyway?

Excel has a Navigator for this. Most people still don't know it's there.

View > Navigation.

It opens a pane on the side with a list of all your tabs. You can easily jump between them.

Expand any tab, and you'll see an overview of all the contents in the sheet.

All your tables, pivot tables, charts, slicers, and any other objects, like shapes and pictures.

Use the search box to find the table or chart you need.

Well, as long as you make the effort to rename them. If everything's still Table1, Table2, Table47, you're not going to find much.

Good news: you can rename them from the navigation pane.

As well as rename, delete, or hide (or show if hidden) any sheet or object. Simply right-click.

Useful feature. Saves you from scrolling through tabs or hunting for that one chart buried three sheets back.

It's been around for a couple years now. We covered it here, along with other features that quietly showed up and got mostly ignored.

Are you using the Navigator? What else are you sleeping on?

​

🎁 Still Haven't Found That Perfect Gift? Some people are tricky to shop for. But here's something that actually lands well: skills that make someone's work life easier. Know someone who could use a career boost? Or just someone who'd appreciate not doing things the hard way? Gift them a course. They get immediate access. You look thoughtful. They actually use it. Here's how: 1 Pick any course from our site and go to checkout 2 Scroll down till you see "Send as a gift." 3 Add their name, email, and a personal message if you want. ​ Browse Courses Here

​

🤓 Geeky News

📂 File Explorer gets new buttons and a speed boost

Microsoft is adding another Copilot button to File Explorer. This one sits in the Home tab and sends your files to Microsoft 365 Copilot for summaries and insights. It's optimized for Office files specifically.

There's already an "Ask Copilot" option in the right-click menu. It's the same experience, just a new entry point.

Next to the new Copilot button, you'll find a new folder icon. It lets you open file locations directly from the Home tab.

Meanwhile, Microsoft admitted File Explorer is slow to open. To fix it, they decided to keep it running in the background all the time.

When Windows 11 boots, it starts explorer.exe for your taskbar and desktop. But File Explorer itself doesn't load until you click it. Now it'll preload in the background automatically.

In testing, it does open faster. RAM impact looks minimal. But if it causes issues on your machine, you can turn it off in Folder Options.

Rolling out to everyone in early 2026.

💻 Windows gets a real "Undo" button

Windows 11 is testing a feature called Point-in-time Restore. It takes automatic snapshots of your entire system - apps, settings, files, everything - every few hours. But don't confuse it with the controversial AI Recall feature.

No AI in this one (I know, I'm shocked too. I'm sure they'll find a way to cram it in somehow.)

If a bad update breaks something or you mess up a setting, you can roll back to exactly how things were yesterday or the day before. Goes back up to 72 hours.

It's different from System Restore. System Restore only fixes system files. This restores your actual files too.

Right now it's only in the Insider preview builds. Coming to everyone sometime in 2026.

🤖 OneDrive gets AI Agents you can share

Microsoft just launched Agents in OneDrive. Think of it as a custom Copilot that only knows about your specific project files.

You pick up to 20 files, create an agent, and it becomes your project assistant. Ask it things like "What are the open action items?" or "Summarize the last three sprint reviews." It pulls answers from those files only.

The agent saves as a .agent file in OneDrive. You can share it with your team just like any other file, so everyone can ask the same agent questions instead of hunting through documents.

Good for project hubs, onboarding new people, or prepping for meetings when you need to pull info from multiple files fast.

You'll need a Microsoft 365 Copilot license. Available now in OneDrive on the web.

​

🤔 Did You Know?

You can add discreet tooltips to your Excel cells.

They'll pop up whenever someone clicks on the cells.

Useful when you need to add instructions or warnings.

The secret is Data Validation. And no, you don't have to create any rules.

🎥 Watch how to do this here​

​

🙌 Expected Python tricks. Mastered machine learning instead.

Congrats to Komal for crushing Python in Excel for the Real World!

She came in expecting Python syntax and Excel tricks.

She ended up building time series forecasts and machine learning models instead.

You go from "I can automate my reports" to "I can predict next quarter's trends before anyone asks for them."

Some of these skills you'll use next week. Some in three months when the right project lands on your desk. But they're there when you need them.

​

Me and my team are taking a short break to recharge (and cook up some exciting stuff for 2026).

Wishing you all a great holiday season. Here's to more wins and breakthroughs in the New Year.

​

Leila

​

Want more?

▶️ Subscribe on YouTube​

🖇️ Follow us on LinkedIn​

🥇 Join 400,000+ students in our courses​

📣 Want to sponsor Between the Sheets? Get in touch here.

📨 If you were forwarded this message, you can get the free weekly email here.

This newsletter contains affiliate links, which give us a small commission on any purchase made at no cost to you. This helps us run Between the Sheets and bring you updates like this. Thank you for your support!