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.
 
Back
Top