Hi I've got a big spreadsheet running on a very slow machine and I need to
paste a lot of info into it from many different sources all by different
authors, the last thing I need to be doing is adjusting the formatting after
each paste or going through the "paste special" menu and selecting "text" for
each one.

So the question is: can I make the formatting of the cell take precedence
over that of the copied text?

Wouldn't it be simpler to do all the pasting and forget about the format.

Then select all of the pasted range and just format it the way you want?

(I guess that assumes that all the cells that you pasted get the same format.)

Karsa wrote:

Hi I've got a big spreadsheet running on a very slow machine and I need to
paste a lot of info into it from many different sources all by different
authors, the last thing I need to be doing is adjusting the formatting after
each paste or going through the "paste special" menu and selecting "text" for
each one.

So the question is: can I make the formatting of the cell take precedence
over that of the copied text?

--

Dave Peterson

Well yeah, that's one way of doing it, but if I take a 150 - 250 entry sheet
doing match functions on 3 other sheets with somewhere between ~400 and
~10,000 entries, and that's conservative, select the lot and hit "Ctrl 1" my
poor little work machine will melt through the desk.

"Dave Peterson" wrote:

Wouldn't it be simpler to do all the pasting and forget about the format.

Then select all of the pasted range and just format it the way you want?

(I guess that assumes that all the cells that you pasted get the same format.)

Karsa wrote:

Hi I've got a big spreadsheet running on a very slow machine and I need to
paste a lot of info into it from many different sources all by different
authors, the last thing I need to be doing is adjusting the formatting after
each paste or going through the "paste special" menu and selecting "text" for
each one.

So the question is: can I make the formatting of the cell take precedence
over that of the copied text?

--

Dave Peterson