Excel 2010 select all data

Dick7Access

Dick S
Local time
Today, 10:43
Joined
Jun 9, 2009
Messages
4,340
Is there any way in Excel 2010 to select all data, so I can delete all the data at one time without deleting the field (if that’s what they are called in Excel) without having to scroll thru 1000’s of records? You know, like in word select all.
 
Hi Dick7Access,

There's more than one way;

Easiest click on the corner of the spreadsheet between Column 'A' & Row '1' & it will select the whole spreadsheet, then hit the Delete key.

OR

Use VBA as per the below for the whole sheet & then for one Column (depending on what you need).

Sub Delete_Whole_Sheet_Data()

Cells.Select
Selection.ClearContents

End Sub
--------------------------------------------------
Sub Delete_Col_H_Data()

Columns("H:H").Select
Selection.ClearContents

End Sub

HTH
 

Users who are viewing this thread

Back
Top Bottom