A new navigation pane debuts in Excel. It is a feature for people with low vision who are using Excel with a screen reader. Take a look at how you can easily make your workbook easier to navigate.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
MrExcel Excel Videos
Learn Excel from MrExcel - Excel tips and tricks from Bill Jelen.
You can build Lambda functions in Excel that support optional arguments. A new ISOMITTED function lets you check if the argument was supplied or not.
Three more of the new Lambda Helper functions in Excel: MAP, REDUCE, and SCAN. In today's episode, see three different ways to create a PRODUCTIF function in Excel using MAP, REDUCE, or SCAN.
Important points:
MAP can take one or more arrays.
MAP is looking at each individual cell, not just the values in the cells.
REDUCE does the same thing, but produces a single result.
SCAN is like REDUCE, but makes the intermediate results available.
Read more at: Re: Announcing LAMBDA Helper Functions: Lambdas as arguments and more
A first look at the new Excel functions BYROL and BYCOL. These functions, released to Insiders Fast this week are designed to be used with LAMBDA functions.
Read more about the 7 functions here:
https://techcommunity.microsoft.com/t5/excel-blog/announcing-lambda-helper-functions-lambdas-as-arguments-and-more/bc-p/2587253#M2240
I am launching a new add-in today for Excel 2000 through Excel 2010. Easy-XL adds 50 powerful data analysis tools to Excel.
Microsoft is releasing a new look for the Excel Quick Access Toolbar and Ribbon. The feature is rolling out slowly to beta Insiders now. Here is a first look at the QAT and Ribbon.
Can you sort one column in an Excel table using the Filters and not sort the other columns? This would be easy if it was a range. But it you press Ctrl+T, I am not sure of a good way.
So - the weekend challenge: Does anyone have a clever way of solving this?
A new feature debuting in Microsoft 365 Excel. If you save your file to OneDrive Excel will record every change anyone types in the workbook. You can then see those changes using Review, Show Changes, in Excel Online. It is tracking the changes anyone is making in Win32 Excel. This is HUGE!
New in Excel for Microsoft 365: Hold down Ctrl and Shift while scrolling the wheel mouse to scroll sideways.
