If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Can I reverse a column ?
Is there a way to reverse all the plus in a column into negative and the
negative into plus? I mean a fast way, not manually all and every entry by hand. |
#2
|
|||
|
|||
Can I reverse a column ?
In an empty cell, enter the number -1. EditCopy. Select your numbers.
EditPaste Special, check Multiply. OK. -- Kind regards, Niek Otten Microsoft MVP - Excel "Karl" wrote in message ... Is there a way to reverse all the plus in a column into negative and the negative into plus? I mean a fast way, not manually all and every entry by hand. |
#3
|
|||
|
|||
Can I reverse a column ?
One way:
Enter -1 into a blank cell. Copy the cell. Select your column. Choose Paste Special, selecting the Value and Multiplication radio buttons. Click OK. Clear the cell with -1. Fast enough? In article , "Karl" wrote: Is there a way to reverse all the plus in a column into negative and the negative into plus? I mean a fast way, not manually all and every entry by hand. |
#4
|
|||
|
|||
Can I reverse a column ?
Thanks for the reply.
I use Excel 97 and I do not see Paste Special. I see Paste, but not special. Is 97 that different from 200 or 2002 ? Or I am to blame, I must say, I am very much a newbie as far as Excel goes. So additional help is very much appreciated. Thanks in advance Karolus "J.E. McGimpsey" wrote in message ... One way: Enter -1 into a blank cell. Copy the cell. Select your column. Choose Paste Special, selecting the Value and Multiplication radio buttons. Click OK. Clear the cell with -1. Fast enough? In article , "Karl" wrote: Is there a way to reverse all the plus in a column into negative and the negative into plus? I mean a fast way, not manually all and every entry by hand. |
#5
|
|||
|
|||
Can I reverse a column ?
I did find Paste Special but it has a Radio button for Paste and then to the
left Unicode Text. Is that what I should click on? "J.E. McGimpsey" wrote in message ... One way: Enter -1 into a blank cell. Copy the cell. Select your column. Choose Paste Special, selecting the Value and Multiplication radio buttons. Click OK. Clear the cell with -1. Fast enough? In article , "Karl" wrote: Is there a way to reverse all the plus in a column into negative and the negative into plus? I mean a fast way, not manually all and every entry by hand. |
#6
|
|||
|
|||
Can I reverse a column ?
Look in the Edit Menu
In article , "Karl" wrote: I use Excel 97 and I do not see Paste Special. I see Paste, but not special. Is 97 that different from 200 or 2002 ? Or I am to blame, I must say, I am very much a newbie as far as Excel goes. So additional help is very much appreciated. |
#7
|
|||
|
|||
Can I reverse a column ?
Try copying your cell again. Sounds like you copied from some other
text source. In article , "Karl" wrote: I did find Paste Special but it has a Radio button for Paste and then to the left Unicode Text. Is that what I should click on? |
Thread Tools | |
Display Modes | |
|
|