Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
|
|||
|
|||
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:
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.
__________________
I am not human. I am an Excel Wizard |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
find values in multiple cells and paste row values | Excel Discussion (Misc queries) | |||
SUM VALUES on MULTIPLE SHEETS | Excel Worksheet Functions | |||
copy all and paste values for all sheets in a workbook | Excel Worksheet Functions | |||
How do I paste multiple values into one cell? | Excel Worksheet Functions | |||
Can you paste values on multiple worksheets at one time? | Excel Worksheet Functions |