Excel has three different ways to see a partial formula result to help you locate and fix a problem or understand how a formula works. Two methods have been in Excel for some time and there’s a new tooltip feature. Evaluate Formula The full Evaluate Formula has been around since
Excel has a simple way to understand or fix a complex formula. Evaluate Formula lets you calculate parts of a formula and see interim results that make up the final value that appears in the cell. It’s on the Formulas tab under Formula Auditing. Evaluate Formula isn’t new, just little
Word will automatically adjust or Autofit the width of table columns and the space within cells to fit the content that you are entering. Sometimes you don’t want this and want to be able to control the column widths yourself. AutoFit for Word tables is great but sometimes gets too
Microsoft Word has two ways to put text at any diagonal angle you like from a slight tilt to a steep incline for both regular text or a ‘watermark’ effect. It’s a simple trick to enhance a graphical presentation, make your Word document more appealing, Look no further, in Microsoft
Insert the Rotated Heavy Black Heart Bullet ❥ into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. As the term ‘bullet’ suggests Rotated Heavy Black Heart Bullet ❥ symbol is intended for bullet lists. Looking for other heart symbols? Five+ heart ❤ symbols
Create more interesting and engaging bullet lists in Microsoft Word or PowerPoint, use symbols or emojis for a touch of creativity and visual appeal. Here are some different symbols that can be used in bullet lists: Define New Bullet Word has some default symbols that are seen in too many
Here’s the ‘old-fashioned’ way to make a list of worksheet tab names. It’s old because the formula uses ” Get.Workbook() ” which is an Excel 4 macro function that’s now blocked in modern Excel for security reasons. See Excel 4 macros are now blocked and about time tooWe’re including this
The famous Art Deco font used in US National Park posters is available free for Word, Excel or PowerPoint. National Parks Traveller has an interesting article on the history of US National Parks posters. Original posters now sell for four figure prices, not bad for things that were once thrown
Type Loudly Crying Face 😭 emoji into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. In mid-2011 Loudly Crying Face 😭 was the most popular emoji in the world. Alternative names are; Crying, Sobbing, Sad Tears, Bawling, uncontrolled laughter or even overwhelming joy. How
Insert the Down arrow ↓ into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Down arrow ↓ symbol is used for all sorts of things including a bullet symbol. How Down arrow ↓ looks in different fonts. Here’s some examples of how Down
Is it possible to use very old versions of Microsoft Office like Office 2000, Office XP (2002) or Office 2003 on Windows 10 or Windows 11. Should you even try? Office Watcher, Clyde R asks: “What is the oldest version of Office which would be loadable on Windows 10 Pro,
Insert the Rolling on the Floor laughing 🤣 emoji into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Rolling on the Floor laughing 🤣 emoji is commonly used, sometimes using the acronym ‘ROFL’ or ‘Hysterical Laughter’ Not to be confused with Face with rolling
Type the Beta – lower case β into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Beta – lower case β symbol is the 2nd letter of the Greek Alphabet. Within finance, it is used as a measure of investment portfolio risk. Within statistics,
If you have Office VBA you’re trying to understand, ChatGPT can help. ChatGPT can take some VBA code and explain it in plain human language. This is very useful for digging into poorly documented or undocumented code. Also for beginners trying to get a handle on how Office VBA works.
What Microsoft Word calls “Total Editing Time” isn’t what you might think and it really doesn’t mean anything at all. We’ll explain how Word calculates “Editing Time” and why it’s not to be trusted. What seems like a simple thing “Total Editing Time” has hidden complexities. That should not surprise
Microsoft Word has quite clever options for printing selected pages or document sections in any order you want. Office Watch has already talked about printing a selection from a document. Print pages Word has options to print page combinations other than the default ‘Print All Pages’. Print Current Page Use
Insert the Heart ❤ as a symbol, emoji, icon or shape into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Of course, the heart symbol has come to mean love or affection. Less romantically it’s a “plane curve” in geometry called a cardioid.
There are many ways to enter the latest date or time into Excel, depending on exactly what you need. A fixed date/time at the moment you type into the cell or a date/time which Excel updates automatically. This works on Excel for Windows or Excel for Mac. There are combinations
Once you start delving into Microsoft Word, you find it can do all sorts of things that you wouldn’t expect. One of these is that it can be used to create barcodes, and it’s surprisingly easy to do. Once you’ve made your barcodes, they can be scanned with any barcode
Type the Eta – lower case η into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Eta – lower case η symbol is the 7th letter of the Greek alphabet. The symbol is used within various contexts. In Economics, it represents elasticity. To
Microsoft has released a quick ‘TikTok style’ video which is strange and not that helpful at showing some good Excel and Office features. We’ll explain what the video is trying to show off (Excel Conditional Formatting) and some more Office tricks too! We found it in one of Microsoft 365’s
Find and add the Australian National flag, Aboriginal flag and other Aussie ensigns (Boxing Kangaroo or Eureka flags) into Office documents, Word, Excel or PowerPoint, then use some Office picture tools to enhance the image. The same help can be used for any other national flag, just look for a
Type the Prescription Take Rx ℞ into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Prescription Take Rx ℞ symbol is for a medical prescription. It is commonly seen on doctor’s prescription pads and in pharmacies. How Prescription Take Rx ℞ looks Here’s
There’s a curious Microsoft update which is checking for older versions of Office that are either out of support (Office 2007, Office 2010) or will soon stop getting updates (Office 2013 expires in April 2023). Microsoft isn’t being entirely open about the update and the private data being grabbed from
