How to Copy Format Changes From One Table to Another in an Excel Spreadsheet. Microsoft Excel lets you format tables, adding borders and colors, and lets you format the text in them, editing font ...

Click the "Home" tab at the top of the Excel 2007 window. Click "Format Painter" in the Clipboard section at the top and the cursor changes to a paintbrush.

A. Yes, there is, but before I show you, I want readers to understand how to use Format Painter , which is in your Word and Excel toolbar and looks like a paintbrush. Let’s say you have a word (or a ...