deleting data

skalavati · Apr 18th, 2002, 11:36 PM

A set of formatted data with borders is deleted with the help of the delete button, only the data gets deleted, is there a way where i can delete the whole thing at one stroke,

nisht · Apr 18th, 2002, 11:51 PM

will you please explain.. what the delete button is.. and what exactly you do..

nishith desai

eliW · Apr 18th, 2002, 11:54 PM

Quote:

On 2002-04-18 22:36, skalavati wrote:
A set of formatted data with borders is deleted with the help of the delete button, only the data gets deleted, is there a way where i can delete the whole thing at one stroke,

Hi skalavati,
Yes you can do it. You have to put on your Toolbar the "Clear all"* command.
Right click on empty space on your toolbar
choose Customise, Commands, Edit and drag the "Clear all"* Button to your toolbar.

*Hope this is clear as I translated some terms.
Eli

Ivan F Moala · Apr 18th, 2002, 11:58 PM

Tools > Clear > All

should be Std on your Menu.
If not then do as above.

Apr 18th, 2002, 11:58 PM	#4
Ivan F Moala MrExcel MVP Join Date: Feb 2002 Location: Auckland, New Zealand Posts: 4,209	Tools > Clear > All should be Std on your Menu. If not then do as above. __________________ Kind Regards, Ivan F Moala From the City of Sails

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 18th, 2002, 11:36 PM	#1
skalavati Board Regular Join Date: Apr 2002 Posts: 55	A set of formatted data with borders is deleted with the help of the delete button, only the data gets deleted, is there a way where i can delete the whole thing at one stroke,

Apr 18th, 2002, 11:51 PM	#2
nisht Board Regular Join Date: Feb 2002 Location: Ahmedabad Gujarat Posts: 303	will you please explain.. what the delete button is.. and what exactly you do.. nishith desai