Random numbers in Excel are easier than most people think, and you have three main tools to choose from: RAND() for decimals between 0 and 1, RANDBETWEEN() for whole numbers in a range, and RANDARRAY() for filling whole blocks of cells at once. This guide shows you how to make
Choosing 64-bit or 32-bit Office sounds like a decision that matters, but for almost everyone it does not. Since around 2020, Microsoft 365 and Microsoft Office have installed as 64-bit software by default, and that is the right choice for nearly every Windows PC. The 64-bit version is faster, uses
The Microsoft 365 Workplace Discount Program (WDP) cuts 30% off Microsoft 365 Premium, Family and Personal for employees of companies and government agencies that buy Microsoft volume licenses with Software Assurance. Formerly the Home Use Program, the WDP is now simple to claim: enter your work email, verify, and link
The Excel SUMIF function adds up only the numbers you choose, not everything in a range. Plain SUM() totals every cell with no filter, which is fine until you need the sales for one person, one month or one product. SUMIF fixes that by letting you set a condition first,
Outlook gives you two built in ways to save reusable email text, and both are frustratingly limited. My Templates only stores plain text, with no bold, links, images or tables. The other way works for new messages but not replies. So if you send the same content over and over,
If you bought Office 2019 for Mac outright, circle July 13, 2026 on your calendar. On that date Microsoft flips your paid apps into “reduced functionality mode,” really a kill switch that lets you open, view, and print in Word, Excel, PowerPoint, and Outlook but blocks all editing and new
The FIFA World Cup 2026 runs from June 11 to July 19, spanning 16 host cities across the US, Canada, and Mexico with 104 matches spread across four time zones. Keeping track of every kickoff time is a perfect job for Outlook’s calendar, which automatically converts match times to your
Excel formulas translate automatically when you share a workbook across languages, and most users never know it’s happening. Whether a colleague opens your file in French, German, Spanish, or Italian, they see the formula names in their own language. This quiet translation system is why an Excel workbook built in
Every Word, Excel, and PowerPoint file you save is actually a ZIP archive packed with small XML files. That means you can crack open any .docx, .xlsx, or .pptx file using nothing more than Windows Explorer or a free compression tool, no special software required. Whether you want to see
Microsoft Word knows more slang than you might expect. Words like zillion, jillion, squillion, gazillion, bazillion, and oodles are all recognized as correct spellings in Word’s US English dictionary, so you won’t get the dreaded red squiggly line if you drop one into a document. Word’s thesaurus even offers alternatives
Microsoft Word has not gone ‘woke’. Despite press stories claiming Word enforces ‘politically correct’ language, the truth is far less dramatic. The Inclusiveness grammar checks behind the headlines are optional, off by default, and have been part of Word since before 2020. They flag words like mankind, postman and showgirl
If you need an older version of Microsoft Office, like Office 2016, 2019 or 2021, your options have narrowed but they have not disappeared. Microsoft doesn’t sell perpetual licenses for past releases, but you may already own a transferable license, qualify for downgrade rights through a volume agreement, or find
If you see “Lifetime Microsoft Office” advertised for $20 or $40, ignore the word “Lifetime” entirely. Microsoft does not sell anything called “Lifetime Office”. That word is a marketing trick used by third party resellers, and it’s often a flag that the license is dubious or outright illegal. “Lifetime” Office
Wanna be a better, faster Office user? Impress your friends? Be the envy of women and men for miles around? Use simple keyboard shortcuts, called KeyTips, that you don’t have to memorize because they are on the screen. Instantly access Ribbon commands in Word, Excel, PowerPoint, and Outlook for Windows
ChatGPT, Copilot, Claude and Gemini can all write Microsoft Office VBA code for you, and they have improved dramatically. Ask any modern AI to write a Word macro, an Excel automation, a PowerPoint slide builder or an Outlook search routine and you will get working code in seconds. We tested
If you have a Markdown (.md) file and need it in Microsoft Word, you have more options than you might think. From pasting text directly into Word Online to letting an AI do the heavy lifting in seconds, each method has its strengths and sweet spots. This Office Watch guide
Need a bolder alternative to strikethrough? An overlaid X works far better than a thin line when you have large headings, signs, or slide text to cross out. This guide walks you through three reliable ways to overlay an X on text in Microsoft Word and PowerPoint: a quick image
Need to drop an X symbol in Word or PowerPoint to cross something out, overlay a “don’t do this” graphic, or just mark a spot? Microsoft Office gives you two solid sources built right into the apps, plus a fourth option that opens up the entire web. Each one comes
Clicking a link to a Word, Excel, or PowerPoint file should be simple, but Microsoft has turned it into a guessing game. Sometimes the document opens in your browser, sometimes in the desktop app, and the setting that controls it is scattered across Outlook, Office apps, and OneDrive options. This
AutoSave and AutoRecover sound like the same thing, but in Microsoft Office they do very different jobs, and only one of them is a real save. If you use Word, Excel or PowerPoint every day, knowing the difference is the line between recovering a crashed document and watching hours of
Microsoft Publisher will officially be discontinued in October 2026, marking the end of a decades-old desktop publishing tool used by millions. Depending on the Publisher version it will either stop working or keep running but without updates. If you rely on Publisher for newsletters, brochures, or other design projects, now
If you regularly need to type the Euro sign €, the Pound symbol £, or any other special character in Microsoft Word or Outlook, there is a faster way than clicking through Insert Symbols. The Alt + X keyboard shortcut lets you type any symbol’s Unicode value directly in your
If you have two lists in Excel and need to know what they share or where they differ, you are in the right place. Whether you are cross-checking a customer list against an invoice log, comparing a product catalog to a stock count, or reconciling two batches of data, Excel
Microsoft has confirmed it will end the Access Database Compare tool in June 2026, removing it from all supported versions of Office including Microsoft 365, Office 2024, Office 2021 plus Office 2019 . The deadline is June 20, 2026. If database comparison is part of your regular workflow for version
