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.
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,…
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/
If formula results in “”, then that cell will not be empty.When copy and paste as values, it will not be empty either.VersusWhen we use VBA (Macro command) Range.value = Range.value For that “” cell, it will make destination cell as empty. Sorting table will consider cells with “” as 0, while empty cells are…
Issue found several times in xls or xlsx, to get it fix https://www.mrexcel.com/forum/excel-questions/637277-excel-converting-numbers-dates.html
