MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Clearing Contents

Posted by Jessica Garcia on July 19, 2001 10:42 AM

I once saw a worksheet that had a shaded bar at the end that said "clear". When you pressed this button it cleared certain portions of the worksheet out. Does anyone know how this is done?

Posted by Mark W. on July 19, 2001 10:51 AM

That would be the "Clear Contents" toolbar which
you can add using the View | Toolbars | Customize...
menu command. Look in the Edit Commands list. Drag
it to your existing toolbar.

Posted by Scott S on July 19, 2001 10:53 AM

Most likely, this was a button that executed a macro. If you would like to do this, and need instructions, let me know.