Paste Values in multiple sheets
 

I have a workbook with several tabs all with formulas. When I Distribute I
like to eliminate the formulas so I copy & paste the values. It just takes a
while since I have to do it for several tabs. Any way to do this for the
workbook in one shot?

Answer: Paste Values in multiple sheets
 

Yes, there is a way to paste values in multiple sheets at once in Excel. Here are the steps:

1. Select all the sheets that you want to paste values into. You can do this by clicking on the first sheet, holding down the Shift key, and then clicking on the last sheet.
2. Right-click on one of the selected sheets and choose "Select All Sheets" from the context menu. This will ensure that any changes you make will be applied to all selected sheets.
3. Go to the sheet that contains the formulas you want to replace with values.
4. Select the cells that contain the formulas you want to replace.
5. Press
   Formula:

   ---

   Ctrl+C 


   ---

   to copy the cells.
6. Right-click on one of the selected sheets and choose "Paste Values" from the context menu. This will replace the formulas in the selected cells with their current values.
7. Once the values have been pasted, you can deselect the sheets by right-clicking on one of the selected sheets and choosing "Ungroup Sheets" from the context menu.

That's it! Now you have replaced the formulas with their current values in multiple sheets at once. This should save you a lot of time compared to doing it one sheet at a time.

Paste Values in multiple sheets
 

Hi Dmag

See the macro examples
http://www.rondebruin.nl/values.htm

If you want to mail the workbook I have a Add-in that can do that
and mail the file


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Dmag" wrote in message ...
I have a workbook with several tabs all with formulas. When I Distribute I
like to eliminate the formulas so I copy & paste the values. It just takes a
while since I have to do it for several tabs. Any way to do this for the
workbook in one shot?

Paste Values in multiple sheets
 

You could also select multiple sheets, CTRL-A to select all, CTRL-C to copy,
then ALT, E,S,V to paste special values to overwrite all of your formulas.
Just be sure to save the file under a different name.
--
Tips for Excel, Word, PowerPoint and Other Applications
http://www.kan.org/tips


"Dmag" wrote:

I have a workbook with several tabs all with formulas. When I Distribute I
like to eliminate the formulas so I copy & paste the values. It just takes a
while since I have to do it for several tabs. Any way to do this for the
workbook in one shot?

Paste Values in multiple sheets
 

perfect, thanks! worked like a charm

"Ron de Bruin" wrote:

Hi Dmag

See the macro examples
http://www.rondebruin.nl/values.htm

If you want to mail the workbook I have a Add-in that can do that
and mail the file


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Dmag" wrote in message ...
I have a workbook with several tabs all with formulas. When I Distribute I
like to eliminate the formulas so I copy & paste the values. It just takes a
while since I have to do it for several tabs. Any way to do this for the
workbook in one shot?