Tip #155_Excel

Excel: Extend Formatting

 

SCENARIO

You have a table of data that you have formatted using various formatting attributes: maybe with grid lines; maybe some Currency; etc.

 

Now you add more records (either by typing or pasting) beneath the table – but the new records lack the formatting of the rest of the table.

 

Full tip: Excel tip