Tip: Other languages are Google-Translated. You can visit the English version of this link.
Log in


How to copy cell format from one cell (one sheet) to another cell (sheet)?

In some cases, you may want to copy one cell format only which you have specified already to another sheet cells without the cell contents, how can you quickly handle this job? In this article, I introduce two ways can copy the whole cell format or only part of the cell format from one specific cell to another cell(s).

Copy the whole cell format from one cell to another with Format Painter

Copy part of the cell format from one cell to another with Copy Cell Formattinggood idea3

Tabbed browsing & editing multiple Excel workbooks/Word documents as Firefox, Chrome, Internet Explore 10!

You may be familiar to view multiple webpages in Firefox/Chrome/IE, and switch between them by clicking corresponding tabs easily. Here, Office Tab supports similar processing, which allow you to browse multiple Excel workbooks or Word documents in one Excel window or Word window, and easily switch between them by clicking their tabs. Click for free 45-day trial of Office Tab!

ot excel

Copy the whole cell format from one cell to another with Format Painter

The Format Painter can copy the specific cell format to the cell or ranges.

1. Select the cell which contains the format you want to use, click Home > Format Painter.
doc copy cell format 1

2. Then the cursor is changed to a paint brush, go to select the cells you want to paint with the specific cell format.
doc copy cell format 2

Copy part of the cell format from one cell to another with Copy Cell Formatting

But if you just want to copy part of the specific cell format to the cells, the Format Painter cannot help you. In this case, the Copy Cell Formatting utility of Kutools for Excel can do you a favor.

Kutools for Excel, with more than 200 handy Excel functions, enhance your working efficiency and save your working time.

After free installing Kutools for Excel, please do as below:

1. Select the cell you want to use its part of format, click Kutools > Format > Copy Cell Formatting.
doc copy cell format 3

2. Then in the Copy Cell Formatting dialog, all the formatting types of the cell are listed, you can check the formats you want to use in the dialog.
doc copy cell format 4

3. Click Ok, a dialog pops out to remind you select cells to apply the formats.
doc copy cell format 5

4. Click OK, now the cells have been formatted with part of format based on the specific cell.
doc copy cell format 6

Recommended Productivity Tools for Excel

kte tab 201905

Kutools for Excel Helps You Always Finish Work Ahead of Time, and Stand Out From Crowd

  • More than 300 powerful advanced features, designed for 1500 work scenarios, increasing productivity by 70%, give you more time to take care of family and enjoy life.
  • No longer need memorizing formulas and VBA codes, give your brain a rest from now on.
  • Become an Excel expert in 3 minutes, Complicated and repeated operations can be done in seconds, 
  • Reduce thousands of keyboard & mouse operations every day, say goodbye to occupational diseases now.
  • 110,000 highly effective people and 300+ world-renowned companies' choice.
  • 60-day full features free trial. 60-day money back guarantees. 2 years of free upgrade and support.

Brings Tabbed Browsing and Editing to Microsoft Office, Far More Powerful Than The Browser's Tabs

  • Office Tab is designed for Word, Excel, PowerPoint and Other Office Applications: Publisher, Access, Visio and Project.
  • Open and create multiple documents in new tabs of the same window, rather than in new windows.
  • Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!
Say something here...
symbols left.
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.

Be the first to comment.