Insert the Degree Celsius / Centigrade ℃ into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Degree Celsius ℃ is a single character symbol is used to refer to a specific temperature on the Celsius or Centigrade scale. Centigrade was the original name for
Microsoft has added SketchUp 3D graphics (.skp files) to the models inserted into Word, Excel, PowerPoint, and Outlook. SketchUp is a 3D graphics program where you can create shareable designs such as architectural models and graphics used in industrial design, product design, and civil and mechanical engineering. SketchUp Free is
The Smithsonian has millions of images and 3D models available online to add something great and different to Microsoft Office including PowerPoint slides and Word documents. The Smithsonian Institution has been a US cultural, scientific and historical resource for the last 170 years. No visit to Washington DC is complete without
Microsoft has reversed course on their proposed changes to the Quick Access Toolbar (QAT) in Microsoft Office 365 apps. The current defaults remain for new installs with ‘below the ribbon’ available as an option. In other words, common sense has prevailed. Microsoft wanted to move the Quick Access Toolbar from
Amazingly, a simple color can be trademarked and using one in a Word, PowerPoint or Office document can be illegal. We’ll explain why and a list of some colors you might need to avoid. Companies can trademark a color that’s associated with their product or logo. If you’re designing a
OneNote is getting a new and faster way to delete digital ink using the ‘scratch out’ or scribble gesture. As usual, there’s devil in the details to keep in mind. The basics are simple, so simple that it’s a little surprising that the erase gesture isn’t already available. To delete
Microsoft’s AI is available to use now to search or summarize web pages, PDF or any Office document. Use Bing as a peek at the future CoPilot AI system might do for Microsoft Office. Bing Discover is available in the latest Edge browser (Windows or Mac). It opens up two
You can tell Microsoft Word to start an ordered or numbered list from any number or letter you like. Not just start an ordered list with 1 or A. Lists can also restart numbering after a break. Creating a numbered list There are different ways for creating a numbered list
Even after 15 years, there’s still misinformation about the ‘new’ Office document formats .docx .xlsx etc. We’ll explain these myths and how you can easily disprove them yourself. Most of these myths surround the use of ZIP compression to make the document files smaller. Folks have jumped to wrong conclusions
Microsoft has confirmed that their AI helper tools, called CoPilot will be added to OneNote. Here’s some ideas of what the AI system will add to OneNote. CoPilot will be interesting and useful in many ways but the Microsoft Hype ™ is getting way ahead of reality. The OneNote with
How to insert the Vertical Bar | into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Vertical Bar | symbol (technically a glyph) has many uses in computing, physics, maths and typography. In some programming languages | has a special meaning, for example
Excel’s Round () function rounds a number to a specified number of digits. It might seem like the choice for your rounding needs but there are NINE more rounding functions that might be better and even that’s not enough to cover all rounding needs. Round () basics Round() is pretty
Here’s how to round numbers more accurately than Excel’s in-built Round() and other functions. This method uses the internationally recognized standard for rounding (yes, there is one), we’ll show the long formula, how it works plus the Let() and Lambda() versions that can make your worksheet easier to deal with.
Excel’s Round() function is not totally accurate. There’s a lot more to rounding numbers than we were taught in school and how Microsoft’s Round() function works. What we learned in school and Round() is OK. But if you’re dealing with larger groups of numbers, narrow rounding ranges or should be
Microsoft Word’s ‘Line Between’ option for multiple columns can replaced and formatted to a different color or other types of line. Word’s standard ‘line between’ column setting has no formatting. All you can do is choose ‘Line Between’ and no more. There’s no known way to change the look of
In Adding Vertical Lines in Word we looked at the many common choices for lines down the page. Moving beyond that, let’s look at other, more interesting and creative vertical non-line choices to spice up a Microsoft Word document. Sidebars Sidebars are the starting point for many different design element
There are at least six ways to add a vertical line in Microsoft Word. Vertical lines can help accentuate a piece of text in Word, but adding them is not as obvious as adding a horizontal line. These are most common options available. With all the features in Word there
You’re not stuck with the Microsoft Office automatic settings when inserting a new text box. Change the Text Box defaults to whatever you like for faster text box formatting in Office; Word, Excel, PowerPoint or Outlook. There are TWO ways to add a Text Box in Word and Outlook –
As well as links to web sites, Word lets you make ‘internal’ links to other parts of the same document in at least three different ways. Longer documents can benefit from internal links that let you and readers jump within the document. Insert Hyperlink – Place in this document The
Microsoft Word has vital but hidden options for making a better PDF file from your document. PDF’s made from Word can be smaller than usual for faster sending or to get under size limits that apply to email or messaging services. There are choices for including better navigation (like the
A quick guide to reading and searching PDF files on an iPad, either with the Books app or the Adobe PDF viewer. There are many apps that can view PDF files on portable devices. They all have the same basic features (more or less). View Table of Contents (Bookmarks in
A close and in-depth look at what Microsoft Word does and doesn’t flag with the sometimes controversial Gender Specific Language setting in the ‘Grammar & Refinements’ section. Microsoft doesn’t reveal much (or anything) about the Inclusiveness options in Word so we’ve decided to look closely at what they do. We
Excel has two functions that round numbers to either the next Even or Odd numbers – these functions are called … wait for it … Even() and Odd()! Both Odd() and Even() round positive numbers UP to the next odd/even number. Negative numbers are always rounded DOWN to the next
Excel’s Ceiling() and Floor() function rounds a number up or down to the nearest specified multiple. The most common use is to match prices to denominations of coins or notes. Ceiling() is similar to MRound() except that MRound() rounds to the nearest multiple, Ceiling() always rounds UP. The reverse is
