Situatie
If you have ever pasted a new data set into your carefully formatted spreadsheet, you will have no doubt had to spend some time re-formatting all the data so that it looks consistent with the rest of the information you have entered.
Solutie
To quickly format any data in cells and rows to your current design, using the Format painter will save you a lot of time.
First click on a cell that has the correct formatting for your spreadsheet. Then in the ‘Home’ tab in the top ribbon, select ‘Format Painter’ under the clipboard section.
Once you do this, you will notice that your cursor will have a small paintbrush next to it.
Now simply highlight the cells or cells you want to fit the format a click.
This will change them to match your selected formatting.
Leave A Comment?