Need to type a degree sign, Euro symbol or other special characters in Word, Excel or Outlook? Here’s how to insert symbols in Microsoft Office — from one-off use to fast shortcuts for characters you need every day. Degree mark for temperature. Has no special shortcut but you can make one (see below). Currency symbols. […]
Dates imported or pasted into Excel often arrive as text — they look like dates but Excel can’t use them in formulas or sorting. One quick fix is the Paste Special Add Zero trick. It forces Excel to convert text into a real date value by adding zero, which changes the data type without changing […]
Juggling a work login, a personal Microsoft account and maybe a volunteer role? You don’t need to sign out and back in to Word, Excel or PowerPoint. Microsoft 365, Office 2024, Office 2021 and earlier for Windows lets you switch Microsoft accounts in Office with two clicks from the account menu at the top right […]
Excel cells can now hold a list of values instead of just one, a major change in how Excel behaves. A single cell can store several names, dates or times that formulas treat as separate items. It’s in preview for Microsoft 365 Insiders on Windows and Mac only, so for most people the advice is […]
Microsoft has partly fixed their Excel copy paste bug in some versions of Office but left others broken or with an incomplete fix. Microsoft’s documentation is more than a little confusing but it seems most versions of Excel have been fixed. Microsoft 365 was never affected. Confused? Here is the full list so you can […]
