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
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’
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
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
Microsoft has confirmed the prices for Office 2021 to consumers and announced some ‘extras’ which aren’t really anything new and, in one case, self-serving for Microsoft. Office 2021 prices Office 2021 is the new perpetual license, single payment or non-subscription version of Microsoft Office. The replacement for Office 2019. It
Here’s the new and improved features in Office 2021 and Office LTSC which apply across all the major apps; Word 2021, Excel 2021, PowerPoint 2021 and Outlook 2021. We’ve checked Microsoft’s list of new Office 2021 features against the actual software. See all about Office 2021 for Windows & Mac plus The good and bad in Office LTSC
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
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
In addition to the general Office 2021/LTSC features there are some useful additions to Excel 2021/LTSC including the dynamic array functions, improved XLookup()/XMatch() and Let() but sadly no Lambda(). All these features are in Excel 2021 and Excel LTSC for both Windows and Mac in addition to the overall updates
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
Microsoft has announced that Office desktop apps (Windows and Mac) can now co-author encrypted documents. Until now, encrypted docs could only have shared editing using Office on the web. What’s in the fine print is often overlooked, this feature isn’t for everyone. The announcement in bold from Microsoft has got
There are many API’s available on the Internet that can provide great and timely data in ways that Excel can understand, here’s how you can do it. We’ve recently received emails asking how to use Excel to import data from specific API’s. Always we have the same answers because most
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
Excel’s PivotTable allows you to evaluate trends, comparisons, and patterns within datasets. Once a PivotTable is setup, you can filter “Drill down” into it to focus on key information. These days there are several ways to filter a PivotTable, Slicers (which Microsoft loves to boast about), AutoFilter and by Field
The September 2021 release preview has a lot more than usual new and updated features in Office 365 for Windows. Almost as if Microsoft has been saving them up for a bumper surprise! It’s all in the ‘Current Channel (Preview)’ release v2109 build 14430.20088 that’s out now. This is the
If you’re not willing or able to spend the money, there are several ways you can access Microsoft Office for free. These tips are just good for saving money. Some are useful standby’s to keep in mind if you can’t use the full Microsoft 365 desktop programs. Maybe your computer
Now you know how to insert checkboxes in Excel, here are some ways to use check box cells in Excel. Counting the checked/unchecked boxes, calculate percentage checked and even showing a separate list of items based on their checked status. A cell with a check box has two values: TRUE – checked FALSE – UNchecked
