Jump to content


Clearing the Data

Clearing a program

  • Please log in to reply
1 reply to this topic

#1 JPK1066


    Advanced Member

  • Members
  • PipPipPip
  • 101 posts
  • LocationHilton Head SC

Posted 08 April 2018 - 09:00 PM

I have a program that downloads vast amounts of sports data. I would like to clear all the data on multiple worksheets while leaving the underlying format alone so I can start to download fresh data on to empty WS's. Is there an easy way to clear data from tens of thousands of rows?





#2 Jonathan


    Forums Administrator

  • Administrators
  • 888 posts

Posted 09 April 2018 - 11:39 AM



Deleting the contents of a cell doesn't usually affect the underlying formatting, so you should be able to clear the data by simply selecting the appropriate cells and pressing the <Delete> button on your keyboard.


If you're having trouble selecting all of the cells in a range, you might try using the <Ctrl>+<Shift>+<Down Arrow> shortcut key combination, which will select all cells that contain data below the current cell. You can also do the same thing using the other arrow keys on your keyboard to select data to the left, right and above the currently selected cell.


If you are using defined tables you shouldn't need to worry about formatting, as the table will automatically apply formatting as data is added. You should, however, be sure to keep at least one row in your table in order to preserve any formulas that you have defined.


You can see more about selecting cells in: Essential Skills Session 2: Doing Useful Work with Excel (Lesson 2-4: Select a range of cells and understand Smart Tags).


If this is a workbook that you use often, you might want to save it as a template to make it easier to create multiple copies of it in the future. You can see how to create templates in: Essential Skills Session 3: Taking Your Skills To The Next Level (Lesson 3-15: Create a template).


I hope this helps, but please feel free to reply if you need any more help with this.

Jonathan is part of the professional team who answer Excel-related questions posted on the ExcelCentral.com forums.
Jonathan also tests our courses prior to publication and has worked on all of our ten world bestselling Excel books for Excel 2007, Excel 2010, Excel 2013, Excel 2016 for Windows and Excel 2016 for Apple Mac. Jonathan has also worked on over 850 video lessons for or video courses covering Excel 2007, Excel 2010 and Excel 2013.
As well as extensive Excel knowledge, Jonathan has worked in the IT world for over thirteen years as a programmer, database designer and analyst for some of the world's largest companies.

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users