COLUMN FORMAT

J

jobaram

I AM USING OS 10.5.2 AND EXCEL 12. WHEN I TRY TO DEFINE A FORMAT for a column I select the column at the top (alphabet id) (i.e. DATE, Currency, etc.) and the format applies to cells that have entries, but does not carry thru to cells that don't have entries. With my previous version of EXCEL I could define for the complete column and it held for all cells.
 
C

closethipster

I'm seeing a similar thing with Excel 2008 and 10.4.11. The only difference is the formatting DOES carry through to cells that have no data UNTIL I close and reopen the file.
 
Top