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
Good news iOS users, if you’re a Microsoft 365 subscriber, you now have access the premium content library. Take your Word, Excel, and PowerPoint creations to the next level with thousands of royalty-free images, icons, stickers, and illustrations. Here’s how it works Tap Insert | Pictures | Stock Images on your iOS device,
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
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
All the talk about the major outage at Facebook overwhelmed the news that Microsoft had connection troubles of their own. The six hours offline at Facebook, Instagram and WhatsApp rightly attracted all the attention. It wasn’t just an inconvenience but crippling for many businesses that rely on Facebook to connect
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
All about Windows 11 software and accessory compatibility, promises of better and fewer updates and our view on whether Windows 11 is worth switching. See all the Office-Watch.com coverage of Windows 11 Software and accessory compatibility Underneath the changed desktop lies much the same core technology that’s in Windows 10.
From Tuesday 5 October 2021, a new look is be available to Microsoft 365 and Office 2021. Don’t worry, it’s not a major change. Everything on the tabs, ribbon and dialogs remains exactly where they are. Microsoft grandly calls it a ‘visual update’ we call the changes ‘a new coat
Numbered or bullet lists don’t have to look the way Microsoft sets automatically here’s how to change them to suit your needs and style. In Microsoft Word, it is simple to create a numbered or bullet list. Simply select your text | Home Tab | Paragraph Group| Select the Numbering
Organizations need to start work now to reduce the impact of coming price rise. Microsoft 365 enterprise licenses can increase by up to 25% on 1 March 2022 . Here’s some tips to keep the costs of Microsoft 365 down, despite Redmond’s efforts to get more money from customers. Individuals
Skype is getting a surprise makeover with improved group calling views, display customization, two camera support and even translation on calls to regular phone lines. Microsoft calls these changes, we’re not kidding, ‘buttery smooth’. The announcement is a surprise because all the indications have been that Skype is on its
There are two exponential function options in Excel. Like many things in Excel, what looks simple has some traps for the unwary. We’ll explain why the Power() and ^ don’t always give the same or even correct result. Exponentiation is an operation in mathematics, written as an, involving the base
Let’s imagine you’re in Word’s Print Preview and you’ve suddenly noticed an error in your document. You close print preview to make the change, then you go back to print preview again or you can discover Print Preview Edit Mode. Print Preview in Word has all sorts of goodies for
The Search box in the title bar of Excel 365 is getting access to Stock and other linked data types with Word 365 and PowerPoint 365 promised soon. You’ll be able to find and insert linked data direct from the top Search box. The modern Office Search box doesn’t just
XMatch() function in Excel locates an item in an array or range of cells, then returns its position relative to the item. It’s similar to XLookup() which returns the cell value while XMatch returns a relative position in the array. Syntax =XMATCH(lookup_value, lookup_array, [match_mode], [search_mode]) Arguments Lookup_value – the value to find. Lookup_array
Excel can use past data to project possible future results with the Forecast feature. It’s a very simple version of statistical ‘modelling’. The Forecast function will let you predict future values and data trends, such as consumer trends, future sales and or inventory needs, based on seasonality. Here’s a simple guide on how to use the Forecast feature. Although
Previously we talked about How to add a Drop-down List in Word, but you can also work more efficiently in Excel worksheets by making use of drop-down or pull-down lists. We will show you how to use Microsoft Excel’s data validation function to create useful lists within your spreadsheets. How to avoid the trap that lies waiting for the unwary
As if Lambda() was already a great addition to Excel 365, Microsoft is adding what they call ‘helper’ functions to add even more abilities. Here’s a very short overview of each helper function with links to more information. In some cases, the helper functions are a new and better way to do things already
Excel 365’s nifty LAMBDA feature is getting an interesting, literally optional, improvement plus ‘Helper’ functions to extend its usefulness. LAMBDA, a powerful tool that allows users to create their own Excel 365 custom functions without VBA. The feature allows longer formulas to be written once then referenced in a worksheet to a shorter name of the user’s choosing. LAMBDA isn’t just another Excel function, it’s an important change in how
