LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Gary's Student
 
Posts: n/a
Default

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)
--
Gary's Student


"Mustafa Abedin" wrote:

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.



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Find and delete part of formula for multiple formulas? coal_miner Excel Worksheet Functions 1 June 17th 05 05:41 PM
Delete all data (formulas) below a desired row. JMSimms Excel Discussion (Misc queries) 2 May 16th 05 08:56 PM
How to remove hidden grapics from copied web page pasted in Excel. Crake Excel Worksheet Functions 0 January 24th 05 04:47 AM
how do I lock formulas, but I can still delete data? Dave Excel Worksheet Functions 2 January 2nd 05 06:02 PM
delete values in several cells without deleting the formulas dranreb Excel Discussion (Misc queries) 4 December 9th 04 01:15 AM


All times are GMT +1. The time now is 02:36 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"