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

Still curious? Ask our experts.

Chat with our AI personalities

LaoLao
The path is yours to walk; I am only here to hold up a mirror.
Chat with Lao
ReneRene
Change my mind. I dare you.
Chat with Rene
ProfessorProfessor
I will give you the most educated answer.
Chat with Professor
More answers

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.

User Avatar

Wiki User

12y ago
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