• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 322
  • Last Modified:

removing formulas from excel 2007

Dear Sir ,
               i have  a excel sheet in which i have made some rows and columns and given some formulas , i have copied same excel sheet and want to remove the existing formulas .on second sheet
how can i do that ? please advice
0
sanjeevkmrs
Asked:
sanjeevkmrs
  • 2
  • 2
  • 2
  • +2
1 Solution
 
barry houdiniCommented:
If you want to remove the formulas but leave the values derived from those formulas try this:

Copy whole range of data (whole sheet if required)

Keep that range selected then use

Edit > Paste Special > Values > OK > ESC

regards, barry
0
 
sanjeevkmrsAuthor Commented:
where is edit option
0
 
ib02012005Commented:
If you want to remove only formulas from the worksheet when someone copies the data of your sheet then try this:

Select the cells which have formulas in it.

then press ctrl + 1

then go to protection tab and select hidden

Now select raw data cells and press Alt + t + p + a

then click new and press ok again ok

Now press Alt + t + p + p and press ok

Then save the file now your formulas will not be copied

This is an alternative way from the one which is suggested by Mr. barry and it will keep your formulas hidden when anyone else views your worksheet.

Have fun
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
ib02012005Commented:
Hi Mr. Sanjeev,

If you are not getting edit option then try this shortcut

Alt + E + S + V

then press enter and escape

Have fun
0
 
sah18Commented:
If you'd like to retain only the results of the formulas, and not the formulas themselves, do the following:

In your worksheet with the formulas, press Ctrl + A to select the entire worksheet.
Then, press Ctrl + C to copy the whole sheet.
Then, click on the worksheet you'd like to copy these to (on the tabs at the bottom, ex: Sheet2).
Click in cell A1 to select it.
Then, right-click in cell A1 (in Sheet2), Paste Special, Values.

Please let me know if you need any further clarification!
Take care.
0
 
barry houdiniCommented:
>where is edit option

...sorry, that's Excel 2003 - in 2007 you can select the "Paste" option to the left of the Home ribbon then use "Paste Special" from there - although I see other good suggestions using shortcuts etc....

regards, barry
0
 
Richard DanekeCommented:
A great way to select your formulas is to press F5 and choose the Special... button.  Then, choose Formulas - this will highlight only the formulas.
If you want to replace the forulas with their results, use the Paste Special... as suggested.
If you want to clear the formulas, press the delete key.
0
 
sanjeevkmrsAuthor Commented:
Thanks
0

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

  • 2
  • 2
  • 2
  • +2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now