worksheet copy problem

J

jim apostolidis

Hi everyone...
I need to know if its possible to save a worksheet to another worksheet
without saving the formulas, just values (and the format of the cells )
Thanks anyway
 
P

Peo Sjoblom

One way,

right click the sheet tab and select move or copy, select create a copy,
move it to desired location in the workbook, select the whole copied sheet
by clicking the select all button or by pressing ctrl + a,
do edit>copy and while still selected do edit>paste special and select
values and number formats
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Coding Help for Beginner 0
Drop down list control value in vba 2
Close all without saving and exit without prompts 8
Autonumber field in Excel that behaves the same as Access 0
Syncing between source worksheet and dependent worksheets 0
Protected Sheet - Using Groups without a Macro 1
Is a combination of INDIRECT with INDIRECT.EXT, a component ofmorefunc.xll by Laurent Longre, valid? 1
Newbie Help - IF Yes No Function 0

Top