madocar Member Aug 4, 2013 #1 Hi there, Is it possible to remove all the cells at the table at once? Final table should only consists of numbers. http://www50.zippyshare.com/v/43643456/file.html Thanks
Hi there, Is it possible to remove all the cells at the table at once? Final table should only consists of numbers. http://www50.zippyshare.com/v/43643456/file.html Thanks
Hui Excel Ninja Staff member Aug 4, 2013 #2 Madocar Select anywhere in the Table Ctrl A Ctrl F Find What: Delete Find All Select one of the entries in the Bottom of the Find Dialog eg: $C$2 Then Ctrl A again Now Close the Dialog All the Deletes will be selected Press Delete
Madocar Select anywhere in the Table Ctrl A Ctrl F Find What: Delete Find All Select one of the entries in the Bottom of the Find Dialog eg: $C$2 Then Ctrl A again Now Close the Dialog All the Deletes will be selected Press Delete