It’s not easy working with Excel and really large numbers. In fact, Excel doesn’t do a great job with larger numbers. Up to 15-digit integers, Excel is fine, but once you go over that, it quietly rounds numbers. Basically, data above 15 digits stop being accurate. As a result, Microsoft hides that inaccuracy by displaying
In 2013 they discovered a new Prime number but not for Excel. The GIMPS project has discovered a new prime number – that’s a number that can only be divided by itself and one. The new arrival is a bouncing bonny number 257,885,161-1 which is 17 million digits long. Prime numbers
Outlook can setup an Out of Office response, depending on the type of email connection but there’s a better way that works for everyone. ‘Out of Office’ or ‘Vacation’ autoresponses will automatically reply to incoming messages. Clever systems have options like different messages for people inside or outside an organization
Which font to use if emulating a true laundry care or clothing text label in Word, PowerPoint or other Office program? We’ve already talked about how to put standard laundry care symbols in Word, Excel or PowerPoint but what about the text that usually goes with the icons? In our
A reminder that older versions of Outlook for Windows, including some Outlook 365 are ‘ending’ in November 2021, meaning they won’t connect with Microsoft hosted mailboxes, including Outlook.com Microsoft announced this many months ago however their latest list of affected software includes some older versions of Outlook 365 for Windows.
There’s a new generation growing up who see the Office ribbon differently from their parents. To some young people a floppy disk icon looks more like a vending machine! Check out this icon on the older Office ribbon …. To you, me and most people it means ‘Save’ because that’s
Microsoft PowerToys have fixed a glaring omission from Outlook, Windows and the Edge browser. PowerToys now lets Outlook preview PDF, Markdown and SVG attachments in the Reading Pane. For too long, the main way to get an Outlook preview of a PDF email attachment was to install the whole Adobe
Redo is the often-forgotten partner to Undo. It’s mostly used to ‘undo an undo’ or reverse the last ‘Undo’ action but ‘Redo’ has other uses in Word, Excel, PowerPoint and Outlook. In most cases, you use the redo button to revert to a previous state. For example, if you used
Back in 2010 an Office Watch reader drew our attention to this Microsoft Knowledge Base article 2008277 (update: after we published this article the KB article was totally removed by Microsoft). “Error message “The command cannot be performed because a dialog box is open” when opening a Word file from outside
An essential part of Word’s citations and bibliography feature is the Source Manager dialog – here’s how to, er, manage the Source Manager. Open the Source Manager from References | Citations and Bibliography | Manage Sources. There is a Current List (at right) which is saved in the current document.
The workload of students and academics has been made a lot easier with the arrival of Citation features in Word. They are useful for everyone, not just in academia. Citations are individual references to source material you’ve quoted in your document. A Bibliography is a list of citations and sources
How many rows and columns does Excel have now and in the last 25 years of Excel for Windows and Mac? All the talk about 64-bit versions of Office has raised the issue of maximum rows and columns in Excel. A few readers seem to believe that 64-bit Excel will
In Microsoft Outlook you can view two calendars ‘side-by-side’ or overlaid to look like a single calendar. Select two calendars from the left-side pane of a Calendar view. Choose from ‘My Calendars’ or ‘Other Calendars’. The selected calendars appear ‘side-by-side’ in different colors. Overlaid with other calendars Click on the
Excel has six different choices for removing content, formatting, comments or everything from cells. Five are on the ribbon plus another hidden away. Plus three useful keyboard shortcuts, one obvious and two very obscure. Home | Clear On the right of the Home tab is a selection of five ‘Clear’
Microsoft Word has three different keyboard shortcuts to clear formatting, each with its own special variation on how to remove things like bold, italics etc. from text. Choose from Ctrl + Space , Ctrl + Q or Ctrl + Shift + N depending on exactly what you want to remove
Sometimes text formatting can get confusing in Word, PowerPoint, Outlook, Publisher and OneNote. There are several ways to clear the additional formatting and return to original settings. The formatting styles in your text can be easily restored to their default settings by clearing all formatting. Users can waste a lot
There are many online tools that will summarize or paraphrase a long Word document into something shorter and more readable. These five tools also have other uses. Originally, Word 2007 had an Auto Summarize feature, but it was dropped in Word 2010, so Word users will need to rely on
There are several ways to add images into an Office SmartArt graphic; the official Microsoft way plus some others that aren’t usually mentioned for Word, PowerPoint and other Office apps. In the introductory piece, Much better lists with SmartArt , we looked at the SmartArt basics which are much the
SmartArt is available in all Office desktop programs for Windows and Mac. They let you turn a plain boring text list into something more compelling and understandable. SmartArt works and options do vary between the programs, especially PowerPoint. Office for Mac menus look a little different but the primary features
What can you do with a file attachment that has no file extension? Sometimes you get a file, probably an email attachment, that has no file extension. Without something after the dot/period (.doc .docx .xlsx .pptx etc.) Windows doesn’t know what program to use. This is most likely to happen
Improve your Word, Excel, Outlook or PowerPoint Quick Access Toolbar (QAT) beyond the small changes allowed by Microsoft directly. This works in all modern Office for Windows including Microsoft 365, Office 2016/2019/2021/LTSC. You’ll be able to shorten the overly long text labels or change icons (because too many are the
There’s another way you can force a page break before a paragraph in Microsoft Word. By setting this up, the page breaks can automatically appear without you having to worry. This is particularly useful if you have long documents with several different headings. Just simply modify the style to include
Interactive checkboxes can easily be added to your Word document for a variety of uses. Perhaps you need to create a to-do checklist to help monitor the completion of tasks on top of a collaboration document, or make it simpler for users to read and complete surveys or forms. Either way, we will provide
Here’s what you need to know about the two official international document formats, Microsoft’s OpenXML (.docx .xlsx etc) and Open Document Format (.odt .ods etc) both supported in Microsoft Office and most other office suite software. Each format has been recognized by international bodies so there are two ‘official’ document
