Paste Special

  • Thread starter Thread starter David
  • Start date Start date
D

David

Hello All,
Can anyone tell me if there is any difference with the
right-click Paste Special on Excel 97 and Excel 2000 or XP?
I have 2000 and XP. I don't used 97 any more so thats why I
asked. I need to know what 97 has. I need to make sure a
User can paste a whole sheet results but not the formulas
in 97.
One other question:
Is there a name for the square to the left of Column A and
above Row 1? Its the one when you click on it, it displays
in the name box '65536R x 256C'. I want the User to click
on that to select the whole sheet and paste special/ values
only to save results to another workbook.
Thanks,
David
 
Yes you can use paste special in 97 to paste only values,
or formulas, or formats, or what ever.

The square you refer to, according to the 2K help file, is
called the Select All button.
 
Mike,
Thanks for the response!
'Select All', so simple! LOL
Thanks again!
David
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Paste Special Values 2
Paste Special problems 6
Camera Icon and picture updates automatical as information changes 4
Paste Special not working 4
i need to find the exact location of macro to paste in the existing macro need to get the out put co 0
Paste Special Formula Multiply feature doesn't work anymore 2
paste special problem 2
I can't copy and paste equations 0

Back
Top