How to move rows or columns up, down or across an Excel worksheet. There’s a quick way but it’s not obvious. Excel has a variety of different ways in doing this, but it’s important to know the fastest and easiest way, to save you a lot of time and hassle.
Word has many calendars in the File | New templates supplied by Microsoft. Search for “calendar” in the File | New pane then make simple changes to suit you. In Microsoft Word’s File | New pane, search for ‘calendar’. There are two basic calendar designs: Start of Week Some have
Here’s how to choose good looking font pairs for your Word headings and body text or PowerPoint titles and text. We’ve shown you how to use Google Fonts in your Office documents. The Google Fonts site itself is little help but others have curated suggested pairings. Most of the suggested
WOFF are a new-ish type of font that you might have seen mentions or downloads. Here’s how to use them in Microsoft Office; Word, Excel or PowerPoint. WOFF is Web Open Font Format designed to be compact and easy to download. WOFF is for web sites and mobile apps, not
There’s a strange, almost prudish, feature in the Microsoft Word spell checker aka Microsoft Editor that’s used in many of the company’s products. We’ll explain Microsoft seeming avoidance of ‘Naughty Bits’ and why it’s happening. Warning! This article is unusually explicit (NSFW) for Office Watch. If sexually explicit but standard
Type Up Down Arrow with Base or underline ↨ into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. How Up Down Arrow with Base ↨ looks in different fonts. Here’s some examples of how Up Down Arrow with Base / Underline ↨ looks
Is it possible to share or send a single Excel tab or worksheet from an entire spreadsheet? Sharing a single worksheet or tab isn’t possible. Excel’s sharing features work on the workbook or entire document level. But it is possible to send out or share a single worksheet/tab with a
There are three symbols that Microsoft won’t put in their fonts for Windows and Office. They are obscure and you’re unlikely to need them. It’s an interesting bit of trivia and example of the differing corporate cultures and judgements. (This article includes an image that might offend some people. NSFW,
Only for a few hours, Amazon is running their Microsoft 365 Family plus gift card deal potentially saving $50 but there’s also traps to be aware of. The offer is “Microsoft 365 Family 12-month subscription with Auto-Renewal + $50 Amazon Gift Card” our bold text. Check out the deal at
An important Microsoft Office related security bug fix has been bypassed by hackers in an embarrassingly simple way. Back in September 2021, Microsoft released a fix for a security bug which involved accessing a web page within a Word document (docx or rtf). That web page then downloaded and ran
Outlook replies can be a problem of invisible or hard to read text when the incoming email has a color background. We’ll explain the problem and how to fix your reply email. Messages with colored backgrounds might look OK to the sender but are a pain when you try to
If you want to change the background color on an email, Outlook’s option to do that has changed name and location. At least Windows users can change background color, Outlook for Mac users lost this option at few years ago! A color background can be nice in an email but
Looks like many people will be using Zoom, Facetime, Skype or Teams to meet up with family and friends over Christmas. Take a few moments to get ready, look and sound your best for family and friends. All through 2020/2021, Office Watch expanded its coverage to include no-nonsense guides to
How to insert either of the Tilde ~ ∼ symbols into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Tilde ∼ symbol is easy on some keyboards but for other keyboards, there’s no specific key for Tilde. The two Tilde symbols There are
Microsoft loves tinkering with WordArt and in Word 2010 the entire feature was expanded to Text Effects and split into two features on different tabs. Here’s how to find all the old WordArt features plus a lot more. Back in Office 2007 there was one WordArt feature on the Insert
Microsoft’s Clippy, the source of many jokes and frustration is being trademarked, almost 25 years after it was released in Office 97. Why? Hopefully not the first step in a revival of the hated little paperclip? Clippy was the overly persistent helper in Office 97 that kept popping up at
The new look Office 365 (and Office 2021) is coming. For the moment you might have the option to try it or not. Here’s how. Look for the megaphone If a megaphone appears on an Office app title bar, you can try the new look Office for Windows. Click on
We’ve looked at design and typography in 2001: A Space Odyssey and how to use the ‘2001’ look in Microsoft Office. Two readers asked about some curious kerning in our version of the title font.Maybe you’re not interested in the fine detail of the text in a fifty year old
Use Word tables to do formatting tricks, make complex formats easily and solve Word formatting problems. There’s more to Word tables than just showing grids of information like this: Tables have all sorts of little tricks in them and let you do clever things in Word. Here’s a look at
There are many ways to add common sound effects and background music to your PowerPoint videos. But what if you wanted audio from an online source like YouTube? You can copy from online to an audio file, save it to your computer then link into a slide deck. There are many tools to ‘rip’ a video with audio from
Type the Up Down Arrow ↕ into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Up Down Arrow ↕ symbol is a vertical line with arrowheads on both ends, pointing up and down. How Up Down Arrow ↕ looks in different fonts. Here’s some examples of how Up Down Arrow ↕ looks in common Office fonts. Up
Pantone has announced their “Color of the Year” for 2022 and, as usual, we’ll explain how to use those exact colors in Word, Excel, PowerPoint and Outlook. For 2022, the new color will also be appearing in Microsoft products with a nice PowerPoint template with extra color palettes. The color
The Financial Modelling World Cup or Excel esports Final was held a few days ago and you can watch the whole event. There were eight finalists from the USA, Canada, UK, India and Australia. If you can’t get enough of Excel champs at work, check out the earlier rounds. Last
In January 2022 there are important changes to the volume licence Business and Enterprise plans for Microsoft 365, Office and Windows. Monthly plans will cost 20% more, making annual plans more enticing. Microsoft says “introduces a monthly term option that will enable partners to provide customers with flexibility at a premium price,” However, the option to
