answersLogoWhite

0


Best Answer

ctrl-1 will copy the format of the selected cell then you will have to select the cell in which you want to change. On the menu bar there is a icon that looks like a paint brush. You can select this icon to copy a cells format as well but you will have to still select the cell in which you want the change to happen.

User Avatar

Wiki User

13y ago
This answer is:
User Avatar
More answers
User Avatar

Wiki User

14y ago

After you copy the cell with the formatting you want, go to the cell (or cells) where you want to copy the formatting select Paste and choose "Paste Special," then select Formats.

Menu Path: Paste | Paste Special | Formats

This answer is:
User Avatar

User Avatar

Wiki User

11y ago

You can use the Format Painter tool or you can use Paste Special and pick the option to paste the formatting.

You can use the Format Painter tool or you can use Paste Special and pick the option to paste the formatting.

You can use the Format Painter tool or you can use Paste Special and pick the option to paste the formatting.

You can use the Format Painter tool or you can use Paste Special and pick the option to paste the formatting.

You can use the Format Painter tool or you can use Paste Special and pick the option to paste the formatting.

You can use the Format Painter tool or you can use Paste Special and pick the option to paste the formatting.

You can use the Format Painter tool or you can use Paste Special and pick the option to paste the formatting.

You can use the Format Painter tool or you can use Paste Special and pick the option to paste the formatting.

You can use the Format Painter tool or you can use Paste Special and pick the option to paste the formatting.

You can use the Format Painter tool or you can use Paste Special and pick the option to paste the formatting.

You can use the Format Painter tool or you can use Paste Special and pick the option to paste the formatting.

This answer is:
User Avatar

User Avatar

Wiki User

11y ago

You can use the Format Painter tool or you can use Paste Special and pick the option to paste the formatting.

This answer is:
User Avatar

User Avatar

Wiki User

12y ago

Format Painter

This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: How do you copy formatting of a cell in Excel?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

What does formatting only in Excel mean?

It is possible to copy just the formatting of one cell on to others. Normally when you copy you copy the formula, but sometimes you may just want to use the formatting from one cell. So you can take the "formatting only" and apply it to the other cells. This will change the format of the cells, but not what is actually in them.


In addition to creating a series of values dragging the fill handle instructs Excel to the formate of a cell to range?

When you use the fill handle it will copy what is in the cell including the formatting.


What is the excel feature by which a cell takes on the formatting of the number typed into the cell?

A number typed in a cell has no formatting of its own. Formatting is determined by the format set for the cell. You may be asking about conditional formatting, but it is difficult to tell from your question.


How do I retain Excel cell formatting during mail merge into a table in Word?

Merge brings one to several individual cells from Excel into Word. The formatting in the merged Word document depends on Word, not Excel. If you would like to retain the same formatting as you had in Excel, then format the target location in Word to match the cell from Excel.


Bold Italic and Underline are what in excel?

cell formatting options


What is the name of the button in excel that allows you to copy values with or without formatting?

Paste Special allows copying with or without formatting


Does Excel have two types of conditional formatting?

You do Conditional Formatting based on a cell value or based on a formula.


The excel feature by which a cell takes on the formatting of thenumber typed into the cell?

format as you type


What affects the data in the cell on Microsoft Excel?

Formatting can change the look of a cell and its contents.


Button that allows you to copy values with or without formatting?

It is the Auto Fill Options button that lets you copy values with or without formatting. Microsoft Excel is a spreadsheet application.


A specific way in which excel dispalays numbers in a cell is referred to as?

Formatting.


What are predefined set of characteristics that can be applied to cell contents in excel?

Formatting.