Double click on the format painter button to change multiple cells at one time. It will copy the formatting of any cell you choose, and pressing it again while on the target cell will transfer the format.
Save yourself the irritation of repeating a cumbersome three- or four-step format process via the dropdown menus with the Format Painter button.
Copy formatting using the format painter function (F4) Whether you stick to basic functions, or are a macro-writing, pivot-table-creating, multi-referential workbook workhorse-these 11 tips might yet turn you into an Excel superstar. But working with data and multiple sheets can also represent a significant time suck, with most of us only ever using 10 per cent of what Excel has to offer. It’s no secret that CPAs make good use of the almighty Excel spreadsheet program it’s an invaluable tool that helps us process complicated data sets and communicate large amounts of information to clients and colleagues.
