Excel f(x)s = Excel Functions
Excel recently started to show cells with formulas scratched (see screenshot). Looks like this new feature to tell user that these cells will have new values and they are in the process of getting calculated. If you want to disable that feature, uncheck “Show stale values” in “Calculation Options” in “Formula” bar (Screenshot)
One of many tricks that we overlook due to the huge number of possibilities in Excel and its functions.
This one I wanted to keep helping me as reference, it is how to change a number in range of cells by copying another value OVER it with ‘Paste Special’. Checkout screenshot.
An easy way to scroll through set of data in a graphic way without graphs.
A-pure-formula xlsx workbook. These were done using formulas, conditional formatting, and ActiveX control.
This is only available in Microsoft 365 Enterprise version, an application that can compare two workbooks in all objects. This includes cells (values or formulas) in all sheets, VBA objects and macros. Bug: I noticed that even if VBE project in a workbook is protected, it will still open it and show you all macros,…
This guy has nothing to stop him
Looks like there is a change coming. Excel started adding the symbol @ to some formulas, not sure why only those, but we are waiting to start using this new feature.
It is official and looks better now, I know it might be confusing, but I liked it so far
Excel now has “Comments”, the classic Comments are now called “Notes”
I used Notes a lot, mainly to remind me of certain expectations of some cells, or guide the user to some additional info about some cells, so got confused when I tried to insert Comment into cell.
A trick learned awhile ago. Creating shapes connected to cell, that updated automatically.
When following steps attached, you will be able to connect any shape to any cell in away making it “linked”, so when cell changes the shape will also get updated.
Used it to enlarge or track user attention to a certain value, or sometimes to format certain text in a free way outside cells limitations.
Just a quick find I noticed few days ago.
If you notice, the & inside cell has turned into an underline of the letter after
CQ – G&A has turned to CQ – GA
This is a programming technique we used to apply in Menus to allow users to execute a shortcut, looks like here Excel got it inherited
On your daily work, in Excel, you have had the need to redo actions, simple same action to multiple areas perhaps Or apply similar format to more than 1 region, or repeat actions, the last action you did In all these scenarios, use CTRL+Y It is like a mini-macro to repeat last action taken on…
Formula Beautifier
http://excelformulabeautifier.com/
