Formula

T

T-Bone

I would like to take a large spreadsheet and add 0.01 to each cell in it
without that being visable to others when I distribute the spreadsheet to
others?

Thanks
 
S

Sheeloo

Not sure what you mean by not 'being visible'...

but to add 0.01 to all cells enter 0.01 in any unused cell
Copy the cell
press CTRL-A in the worksheet you want to select ALL
Right-click and choose Paste Special and choose ADD
Click OK
 
T

T-Bone

in Exel 2007 when I hit "paste special", it does not have the options it had
in excel 2003...all it has is paste as unicode text or text....am I insane or
did Microsoft move that feature?
 
S

Sheeloo

You are not insane... :)

Your workbooks must be open in two different instances of Excel 2007...

Open one and then open the other using Office Butto -> Open

To fix try
Close Excel first and On the Windows Taskbar

1) Start->Run-> excel.exe /unregserver ->OK.
2) Start->Run-> excel.exe /regserver ->OK.

See the space between exe and /regserver

You might have to designate a full path to excel.exe (most likely C:\Program
Files\Microsoft Office\Office12)

In that case Start->Run-> "C:\Program Files\Microsoft
Office\Office12\excel.exe" /regserver -> OK

Note that quotes are required because of spaces in the path
 
Top