All about Microsoft Office for Apple Mac. Word, Excel, PowerPoint and Outlook on macOS
Microsoft 365 for Mac, Office 2021 for Mac and earlier versions.
Adding the Argentina flag to Word, Excel or PowerPoint should take thirty seconds, but Argentina sets a trap that most countries do not. There are officially two national flags, the ceremonial one with the golden Sun of May and a plain version without it, and picking the wrong one is the giveaway that you grabbed […]
Adding the French flag 🇫🇷“Le Tricolore” to Word, Excel or PowerPoint looks like the easiest job in Office. It is three colored bands. What could go wrong? Quite a lot, as it turns out. There are two official French blues in circulation and the French state has switched between them, the white middle band disappears […]
Adding the England flag “St George’s Cross” to Word, Excel or PowerPoint should take thirty seconds, but most people get it wrong twice. Here is where to get a proper scalable graphic of the England flag, the exact hex colors, insert and enhance it in Office, and why the England flag emoji will look broken […]
Splitting text in Excel used to mean wrestling with nested LEFT, RIGHT, MID and SEARCH formulas. Not any more. Excel 365 and Excel 2024 have three functions that do the job in one step: TEXTBEFORE, TEXTAFTER and TEXTSPLIT. TEXTBEFORE grabs everything before a delimiter, TEXTAFTER grabs everything after it, and TEXTSPLIT breaks a whole string […]
Excel Flash Fill is one of the fastest ways to split, join and reformat text in Microsoft Excel without writing a single formula. Type one or two examples of the result you want and Excel spots the pattern, then fills the rest of the column automatically. It works on Windows and Mac in Excel 2013 […]
