Delete the formulas of webpage, copied & pasted on excel sheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using Office 2003 & would like to copy & paste on a Excel sheet a
webpage with coloums containing text but also with hidden formulas.

I would like the hidden formulas to be deleted from the excel sheet. due to
this hidden formulas the worksheet takes time to open as the size increases
to Mb.

Would apprecaite your help.
 
A possible solution is to replace all the formulae in the worksheet by their
values rather than searching throught the entire sheet looking for formulae:

Select all the cells in the worksheet
Edit > Copy
Select cell A1
Edit > Paste Special (check the value button)
 

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

Copy, paste 2
Copying cell formulas 1
Copy/Paste with Hidden Rows/Columns Excel 2007 3
COPY PASTE VALUES ONLY FROM/ON VISIBLE CELLS 6
Re-post: Code to make sheet very hidden based on date 1
Copy and Paste 2
copy formula - keep cell same but increment sheet numbers 5
Excel formula to copy/paste formula needed please. 4

Back
Top