Cool Keystroke

[lj]

Hi,

I stumbled accross a cool keystroke today that coudl be very helpful
for me but I can't replicate it. Here's what I did. I was pasting a
row of data into excel and I somehow pasted in negative signs in front
of all of the data at the same time. What is the key stroke to do
this? Is there a way to enter in /1000 for a large chunck of data?
This is something I deal with all the time and would be super
helpful. Thanks for your help.

Lisa

 

[Warrior]

This one is quite simple. When you paste the row of numbers, just choose
"Paste Special" and under Operation, choose Subtract. Voila, all negative
signs.

Steve

 

[lisaj]

This one is quite simple. When you paste the row of numbers, just choose
"Paste Special" and under Operation, choose Subtract. Voila, all negative
signs.

Steve








- Show quoted text -

Oh, that IS easy. Thanks!

 

[Shane Devenshire]

Hi,

Regarding you second question - if you are trying to divide by 1000 then
enter 1000 in an empty cell and copy it. Highlight all of the cells you want
to change and choose Edit, Paste Special, Divide.