Every time (many days a year) I train people in Excel, someone ask why there is no button or shortcut to obtain a number format with "thousand separator and no decimals". At least - in northern Europe - this is the most common used number format. If "button-solution" not possible for Microsoft in order to have common buttons world-wide, at least a shortcut for this has been much appreciated. (Note that the current button for thousand separator and two decimals could not be used, though the alignment in that format are not disired/good and two decimals used).
Today I teach student to:
1) be quick to hit Ctrl+1 -- Tab - down arrow -- Tab -- downarrow -- Tab -- space -- Enter
2) Use my macro button - but hornestly, I hate to have macro for something common and simple due to lack of "undo".
3) Maybe some day (and I said that for 10 years now) Microsoft will do it :-)

Custom Margin Settings for 2 Excel files were both set this way:

Top: 0.5
Bottom: 0.5
Left: 0.7
Right: 0.7
Header: 0
Footer: 0
*no other settings modified

First Excel File

View > Workbook Views > Page Layout
Highlighted first 20 Rows > Home > Cells Section > Format > Row Height > Set Row Height from 0.21" to 0.50"
Which results in row 21 showing up on the first page,

Second Excel File

View > Workbook Views > Page Layout
Highlighted first 20 Rows > Home > Cells Section > Format > Row Height > Set Row Height from 0.21" to 0.51"
Which result in first 20 rows to fit on 1 page

This has been a bug (in my mind) forever. For some reason, if you have an Excel shape nicely formatted and you go to link it to a cell to make the text dynamic, all the text formatting gets reset. This is really extremely annoying if you are creating a visually stimulating dashboard and want to duplicate a bunch of perfectly formatted shapes. Proceeding to link the shapes to various cells so that they display your data completely resets the formatting.

I created a VBA workaround to make it seem like the text format is retained, but this functionality should really be integrated into Excel itself.

Link to VBA workaround: https://www.thespreadsheetguru.com/blog/retain-font-formats-after-changing-excel-shapes-formula-link

When you use the "Index" function it returns a value but it would be very useful to be able to return the format of the cell that is matched too.

So, for example: If I look up a risk in a table (see attached file) then I get the value as "High", "Medium", "Low" and then based on that I have to create a conditional format whereas if the cell that I am referring to already has a format then I could just use it.

A bonus would be changing the colours would only have to be done in one place.

It would be handy for some conditional formatting tasks to have the text not show in some circumstances. This could either be accomplished by having the option to set the text 'colour' to transparent/no colour or to automatically set it to the same colour as the current cell background. The aim is not to hide the text per se but to improve readability of a document. For example if you have an invoice you may want to not show the text in the date column if it is the same as the date above so that it is more obvious that a group of entries are for a single date.
You can obviously hide the contents of a cell, but I don't think you can do it with a conditional formatting rule, and if you are using a table with different background colours for each line you can't just set the font colour to the same as the background.