answersLogoWhite

0


Best Answer

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

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

Wiki User

11y ago

Fill without formatting. (for the crossword)

Do the copy in the normal way first and then select where you want to paste to. Then go to the Edit menu or right-click on the mouse and pick Paste Special. Then pick Values. Then click OK.That will paste without the formatting.

This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: Fill destination area with contents without formatting?
Write your answer...
Submit
Still have questions?
magnify glass
imp
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 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.


Fill destination area with series of months?

fill months