answersLogoWhite

0

Copy the range you would like to use. Move to the new location. Instead of just using paste, select Past Values. This will fill the destonation area with the values of the original cells, without also filling with the origin formats.

User Avatar

Wiki User

15y ago

What else can I help you with?

Related Questions

What is a filled destination are with contents without formatting called?

fill without formatting


Fill destination area using format of source area?

fill formatting only


What auto fill option fills the destination area using the format of the source area no content is filled?

fill formatting


How do you fill a destination aarea using the format of the source area no content is copied?

You can use the Format Painter to do it or the Fill formatting Only option.


What fills a destination area using the format of the source area?

Fill Formatting only or the Format Painter tool.


How do you use Auto fill to copy a set of cell values but not the formatting?

The Auto Fill Options button that appears after you release the mouse button lets you specify what is copied. Clicking this button provides a list of Auto-Fill options. Select the Fill Without Formatting option copies the content but not the formatting.


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.


Why the value doesn't change when i Fill Without Formatting in Excel?

It will depend on what you are filling and how you are doing it. Normally, Fill Without Formatting does fill new values. So it could be something else that you are doing wrong, like the way you are selecting the values to start the fill.It will depend on what you are filling and how you are doing it. Normally, Fill Without Formatting does fill new values. So it could be something else that you are doing wrong, like the way you are selecting the values to start the fill.It will depend on what you are filling and how you are doing it. Normally, Fill Without Formatting does fill new values. So it could be something else that you are doing wrong, like the way you are selecting the values to start the fill.It will depend on what you are filling and how you are doing it. Normally, Fill Without Formatting does fill new values. So it could be something else that you are doing wrong, like the way you are selecting the values to start the fill.It will depend on what you are filling and how you are doing it. Normally, Fill Without Formatting does fill new values. So it could be something else that you are doing wrong, like the way you are selecting the values to start the fill.It will depend on what you are filling and how you are doing it. Normally, Fill Without Formatting does fill new values. So it could be something else that you are doing wrong, like the way you are selecting the values to start the fill.It will depend on what you are filling and how you are doing it. Normally, Fill Without Formatting does fill new values. So it could be something else that you are doing wrong, like the way you are selecting the values to start the fill.It will depend on what you are filling and how you are doing it. Normally, Fill Without Formatting does fill new values. So it could be something else that you are doing wrong, like the way you are selecting the values to start the fill.It will depend on what you are filling and how you are doing it. Normally, Fill Without Formatting does fill new values. So it could be something else that you are doing wrong, like the way you are selecting the values to start the fill.It will depend on what you are filling and how you are doing it. Normally, Fill Without Formatting does fill new values. So it could be something else that you are doing wrong, like the way you are selecting the values to start the fill.It will depend on what you are filling and how you are doing it. Normally, Fill Without Formatting does fill new values. So it could be something else that you are doing wrong, like the way you are selecting the values to start the fill.


What is the auto fill option that fills the destination area using the using the format of the source area no content is filled?

The auto fill option you’re referring to is typically known as "Format Only" or "Fill Formatting Only" in spreadsheet applications like Microsoft Excel or Google Sheets. This feature allows users to copy the formatting (such as font style, color, borders, etc.) from a source cell or range to a destination cell or range without transferring any of the actual content. It’s useful for maintaining a consistent visual style across different parts of a spreadsheet.


What does fill formatting only do?

It applies the formatting from what you are filling from onto the other cells, but does not fill what is in the cell like values of formulas.


What is a button that allows you to choose weather to copy the values from the source to the destination area with formatting without formatting or copy only the format?

After you paste your text into the new cell, before you click away from it there should be a small picture of a clipboard that pops up next to the pasted text. When you click on that it will give you the different formatting options.


What is fill formating in Excel?

Fill formatting allows you to take just the formatting from a cell and put it into a load of other cells, similar to using the Format Painter. You could have a cell with particular formatting on it, and drag it down and pick just to take its formatting, not its value or formula, and fill that into the other cells.