 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / August 2007remove data
How do I remove the data without removing the formulas? Thanks. F5 - click on Specials - check Constants - click OK - Delete Ed Ferrero www.edferrero.com > How do I remove the data without removing the formulas? > > Thanks. That doesn't seem to work. Is there perhaps another step that needs to be taken? -- alan > F5 - click on Specials - check Constants - click OK - Delete > [quoted text clipped - 4 lines] >> >> Thanks. Hi Alan, Works for me (in Excel 2003 and 2007), what version of Excel do you use? Ed Ferrero > That doesn't seem to work. Is there perhaps another step that needs to be > taken? [quoted text clipped - 9 lines] >>> >>> Thanks. Like make a selection first. -- HTH, David McRitchie My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm > That doesn't seem to work. Is there perhaps another step that needs to be > taken? [quoted text clipped - 9 lines] >>> >>> Thanks. Aha --- now it works. My problem had not been a failure to make a selection, but rather that, having seen that my selection of the formula cell had moved to the two prior cells, I had RE-selected the formula cell before hitting Delete. It works. But --- now I have another question. Is there any particular advantage doing it as Ferrero had suggested, versus using fewer keystrokes and mouse-clicks and just selecting the first two cells and hitting Delete? -- Alan > Like make a selection first. > -- [quoted text clipped - 15 lines] >>>> >>>> Thanks. If you only have two cells with constants that you want to delete, then go ahead and select them manually. If you have 200 cells scattered all over the worksheet... Ed Ferrero > Aha --- now it works. My problem had not been a failure to make a > selection, but rather that, having seen that my selection of the formula [quoted text clipped - 26 lines] >>>>> >>>>> Thanks. Hi Alan, I think your question is a bit too ambiguous to answer that. If it is only two cells you want to delete than you would select them. Ed is giving you a means to clearing a lot of cells in a selection. Don't know if this would be of interest to you or not, but it provides a means of inserting rows the same as the row of the active cell below that row, retaining formulas and deleting constants, as you might want for a check book balance Insert a Row using a Macro to maintain formulas http://www.mvps.org/dmcritchie/excel/insrtrow.htm -- HTH, David McRitchie, Microsoft MVP -- Excel My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm > Aha --- now it works. My problem had not been a failure to make a > selection, but rather that, having seen that my selection of the formula [quoted text clipped - 26 lines] >>>>> >>>>> Thanks. Mr McRitchie and Mr Ferrero, thank you both for explaining that. Yes, I do see the advantage in a more complex workbook. It finally makes sense to me. And thanks Mr McRitchie for the info on the row insertion. -- Alan > Hi Alan, > I think your question is a bit too ambiguous to answer that. If it is [quoted text clipped - 46 lines] >>>>>> >>>>>> Thanks. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.