How would I go about writing code to check an entire spreadsheet (every tab,
every cell that is not blank) for text/values that do not fir into a cell
(and are therefore not fully displayed. Also, to check that the same font is
used in the same tab. Once this has been detected I would like to
automatically create a summary sheet that lists the location of cells that
are not fully displayed.

Thanks