Hard cells

  • Thread starter Thread starter Stephen
  • Start date Start date
S

Stephen

Hi,

I have a wookbook, say it is Workbook A, in which the
cells take calculations from another workbook, say
Workbook B. So A3 in Workbook A may read as 334.40 but
it is really a combination of A4 and A6 in Workbook B.

Here is my delimma. I want to email Workbook A to
someone but email not Workbook B.

Is there some way to turn A3 in Workbook A into a hard
number, 334.50, so that it will read that number when
they receive it?

Thanks a lot,

Stephen
 
Copy the cell, then choose Edit/Paste Special and select the Values
radio button.
 
Select the sheets in workbook A, select all sheets by holding down shift
key
while clicking on the last sheet tab, press ctrl A to select all cells, do
edit>copy,
now do edit>paste special as values. Done, all formulas are now are now hard
coded
values w/o now click in the first sheet, to remove the all cells selection,
then right click any sheet tab and select ungroup sheets. Save the workbook
and email it
 
Back
Top