Special Paste confusion

I have been told to use Special Paste, here is what I have been told

The paste special command is a very
useful command which you should add to your collection of basic Excel
techniques. As you might have noticed you can Add, Subtract, Multiply or
Divide as well as many other options.



The problem is when I select special paste I only get

http://www.eaglepi.com/images/special.jpg

Paste Special provide different options if you are copying from within an
Excel file that is part of your current application vs. what you can select
when copying from an outside file.

I am currently unable to view outside web pages, but assume you can only
select from Text, HTML, etc.

If you copy a cell within your current ecel sheet and choose paste special,
you will see the options mentioned below.

You can always paste from your outside source to a balnk excel workbook,
then so your paste special from there if desired.

Important note, if you open two instances of Excel (From your Start menu),
you will not be able to use the paste special you are looking for. You must
open your new file from within your current escel workbook.

Hope that all made sense!

"Nobody" wrote:

I have been told to use Special Paste, here is what I have been told

The paste special command is a very
useful command which you should add to your collection of basic Excel
techniques. As you might have noticed you can Add, Subtract, Multiply or
Divide as well as many other options.



The problem is when I select special paste I only get

http://www.eaglepi.com/images/special.jpg

This sounds like homework!!

Try copying something before selecting pastespecial from the menu and see
what you get

Mike

"Nobody" wrote:

I have been told to use Special Paste, here is what I have been told

The paste special command is a very
useful command which you should add to your collection of basic Excel
techniques. As you might have noticed you can Add, Subtract, Multiply or
Divide as well as many other options.



The problem is when I select special paste I only get

http://www.eaglepi.com/images/special.jpg

Do the odd problems only from section 2-3 and show your work. No partial
credit is given.

"Mike H" wrote:

This sounds like homework!!

Try copying something before selecting pastespecial from the menu and see
what you get

Mike

"Nobody" wrote:

I have been told to use Special Paste, here is what I have been told

The paste special command is a very
useful command which you should add to your collection of basic Excel
techniques. As you might have noticed you can Add, Subtract, Multiply or
Divide as well as many other options.



The problem is when I select special paste I only get

http://www.eaglepi.com/images/special.jpg

You have two instances of excel open.

Close one instance.
Then in the other, use File|Open (or ctrl-o) to open the second workbook.

Then do the copy|paste special.

Nobody wrote:

I have been told to use Special Paste, here is what I have been told

The paste special command is a very
useful command which you should add to your collection of basic Excel
techniques. As you might have noticed you can Add, Subtract, Multiply or
Divide as well as many other options.

The problem is when I select special paste I only get

http://www.eaglepi.com/images/special.jpg

--

Dave Peterson

Huh?
"Sean Timmons" wrote in message
...
Do the odd problems only from section 2-3 and show your work. No partial
credit is given.

"Mike H" wrote:

This sounds like homework!!

Try copying something before selecting pastespecial from the menu and see
what you get

Mike

"Nobody" wrote:

I have been told to use Special Paste, here is what I have been told

The paste special command is a very
useful command which you should add to your collection of basic Excel
techniques. As you might have noticed you can Add, Subtract, Multiply
or
Divide as well as many other options.



The problem is when I select special paste I only get

http://www.eaglepi.com/images/special.jpg

This is what I was trying to do

I have a worksheet that has a column for quantities, I have to subtract 1
from the quantity of 120 rows. Other than doing it manually can I select
those rows and do something that will subtract 1 from each of the cells I
select.

In other words if a cell currently has 9 and need it to be changed to 8

This is what I was told



"Assuming all cells in your range are numbers, and all numbers need to be
decreased by 1.
Type -1 in a cell, copy that cell
Select your range, Paste Special -- Add

Voila!
--
John C"



But all I ever get is the what I showed in mt original post in this thread



"Mike H" wrote in message
...
This sounds like homework!!

Try copying something before selecting pastespecial from the menu and see
what you get

Mike

"Nobody" wrote:

I have been told to use Special Paste, here is what I have been told

The paste special command is a very
useful command which you should add to your collection of basic Excel
techniques. As you might have noticed you can Add, Subtract, Multiply or
Divide as well as many other options.



The problem is when I select special paste I only get

http://www.eaglepi.com/images/special.jpg

Same thing Mike



"Mike H" wrote in message
...
This sounds like homework!!

Try copying something before selecting pastespecial from the menu and see
what you get

Mike

"Nobody" wrote:

I have been told to use Special Paste, here is what I have been told

The paste special command is a very
useful command which you should add to your collection of basic Excel
techniques. As you might have noticed you can Add, Subtract, Multiply or
Divide as well as many other options.



The problem is when I select special paste I only get

http://www.eaglepi.com/images/special.jpg

Figured out my problem, my worksheet was a csv not xls, can you convert a
csv to xls and then make the changes using paste special then convert it
back to csv ?

My import for the program I use only accepts csv format

"Dave Peterson" wrote in message
...
You have two instances of excel open.

Close one instance.
Then in the other, use File|Open (or ctrl-o) to open the second workbook.

Then do the copy|paste special.

Nobody wrote:

I have been told to use Special Paste, here is what I have been told

The paste special command is a very
useful command which you should add to your collection of basic Excel
techniques. As you might have noticed you can Add, Subtract, Multiply or
Divide as well as many other options.

The problem is when I select special paste I only get

http://www.eaglepi.com/images/special.jpg

--

Dave Peterson

Yes. Use Save As...