• The Workbook
  • Posts
  • “I’m tired of typing manually in Excel” 😩

“I’m tired of typing manually in Excel” 😩

Introducing Excel’s Format Cells Dialog box ✨

July 10, 2025

Hey there! Tired of spending hours creating reports in Excel that still look…meh? 🫠 I’m hosting a free, one-hour power-packed Excel class where I’ll reveal the exact process I use to create jaw-dropping reports and dashboards that actually save time instead of stealing it. 

If you’re ready to cut your time in Excel down (like, way down) and impress your boss, be sure to register today—you won’t want to miss it!

Add Text to 100s of Cells (Without Losing Your Mind)

POV: You’re working on the monthly inventory report with your coworker, Sarah. But when you look at Sarah’s screen, you see she’s manually typing “units” in. every. single. cell. 🫠

At this rate, you two will be in the office until 7 PM finishing something that should have taken two minutes. Let’s bring out the Format Cells dialog box, shall we? 

Here’s how it works: 

Step 1) Select your data (in our case, that’s C2:C26). 

Step 2) Press CTRL + 1. This shortcut displays the Format Cells dialog box. 

💡Excel Tip: The Format Cells Dialog box sets the formatting options (font color and size, background, borders, alignment, etc.) for your cells. Think of it as your cell’s personal stylist. 

Step 3) Go to Custom 

Step 4) Next to General, type “Units” 

Step 5) Press “Ok” and you’re set! 

Want to Keep Avoiding Your Manual Tasks in Excel?

Adding text to cells isn’t the only thing you can automate in Excel. 👀 

Come to my free Excel class and learn how to build dashboards and reports that practically update themselves (and watch your boss's face when your reports magically refresh while everyone else is still copy-pasting ✨ ).

As Jaymie will tell you, you’ll leave with techniques you can start using today:

If you’re ready to save hours this summer by investing just one hour in yourself, save your seat today!

The Luck Razor ☘️

In 2007, two broke roommates in San Francisco had a choice: Stay home and stress about rent, or take a wild shot at renting out air mattresses to strangers coming to town for a design conference for extra cash. 

Brian Chesky and Joe Gebbia chose the latter, and that decision paved the way for Airbnb (now worth a casual $84 billion). Writer George Mack calls this the Luck Razor: 

  • Luck Razor: When stuck between two choices, choose the one that’s more likely to create luck down the line by exposing you to new people, opportunities, and discomfort (like letting strangers crash on your floor 😅). 

I used this concept in 2020 when I was debating whether to post a TikTok about Excel. One voice said, “You have a corporate job, don’t embarrass yourself online.” But the other voice said, “This video could open new doors.” (Spoiler: It did.)  

Here’s the thing about luck: Lucky people aren’t born different. They just place themselves in more situations where good things can happen. They say yes to coffee chats, put themselves out there, and pursue ideas some people might classify as weird. 

I’m not saying you need to be a yes-person to everything (boundaries matter!), but when you’re unsure between two choices, ask yourself: Which choice gives me the biggest surface area for some good luck? 

Chances are, it’ll be the one that feels slightly uncomfortable. Luck strikes when you’re creating motion in the world—not in your comfort zone. 

Thanks for reading! Here’s your friendly reminder to save your worksheets in Excel just in case something goes wrong. 👀

Stay Exceling,

Kat