Copy format with autofill
How do you use autofill so work in Excel goes faster. Here is an example. Imagine that you have a header row in a table in Excel. You have filled out multiple columns and they are not in the same format. Right-click the autofill spot and drag it over the cells that need the format. Release and select “Fill only formatting” in the menu.
See the video below to understand better.