How to use Format Painter in Excel?
Applying formatting to several cells at once is easy with the Format Painter. Copying the formatting of a specific cell or range to another location in your spreadsheet is simple with this helpful function.
Step 1: Click on a cell with the style
Pick out the cell that features the style you wish to copy.
Step 2: Locate the Format Painter section at Home
Go to home and find the Format Painter section.
Step 3: Click on it
Click on the format painter when you find it.
Step 4: Click on the cell for the same style
Select the cells you want to format or a range of cells, and then click and drag to apply the style.
Step 1: Copy formatting from the first cell.
Like the other cell, the format of the selected one will be modified.
Excel: Formatting Cells
Excel Formatting Shortcuts
If you have closely followed the previous parts of this tutorial, you already know most of the Excel formatting shortcuts. The table below provides a summary.
Shortcut Format
Ctrl+Shift+~ General format
Ctrl+Shift+! Number format with a thousand separators and two decimal places.
Ctrl+Shift+$ Currency format with two decimal places and negative numbers displayed in parentheses
Ctrl+Shift+% Percentage format with no decimal places
Ctrl+Shift+^ Scientific notation format with two decimal places
Ctrl+Shift+# Date format (dd-mmm-yy)
Ctrl+Shift+@ Time format (hh: mm AM/PM)
Excel opens with all the cells looking the same. Things can get hard to understand if you have a lot of them. Changing Excel’s look is as simple as changing the font and size parameters to modify the appearance of your written work. The key points become more apparent, and the material becomes more accessible.
Excel also lets you choose whether the numbers are money ($) or percentages (%). Then, it will know just what to display to them. After these easy changes, your Excel file will look better and be easier for everyone to understand.
Contact Us