Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old February 17th 05, 12:41 AM
Jack
 
Posts: n/a
Default how do I delete data from a worksheet without deleting the formul.

I am trying to clear just the data from a large sheet, and I want to keep the
formulas. This has to be possible, right?

  #2   Report Post  
Old February 17th 05, 01:25 AM
Gord Dibben
 
Posts: n/a
Default

Jack

Select all cells with CTRL + A(twice in 2003)

OR possibly you don't want to touch titles so select just the range to clear.

F5SpecialConstants. Check or uncheck what you want to find/keep and OK.

EditClearContents.


Gord Dibben Excel MVP

On Wed, 16 Feb 2005 16:41:03 -0800, "Jack"
wrote:

I am trying to clear just the data from a large sheet, and I want to keep the
formulas. This has to be possible, right?




Reply
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
Weekly Transaction Processing Ralph Howarth Excel Worksheet Functions 4 January 19th 05 05:37 AM
Pulling data from 1 sheet to another Dave1155 Excel Worksheet Functions 1 January 12th 05 05:55 PM
URGENT Please... new worksheet with copied formats but no data. DarrellK Excel Worksheet Functions 2 December 1st 04 07:11 PM
Reference Data in Moved Worksheet tommcbrny Setting up and Configuration of Excel 1 December 1st 04 06:49 PM
Automatically pull data into another worksheet within the same fil TJess Excel Worksheet Functions 1 November 15th 04 08:00 PM


All times are GMT +1. The time now is 02:26 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017