way to delete the input area on several Excel spreadsheets

M

MarcelMarceau

Is there a way to delete the data input area of several worksheets at the
same time using a macro maybe?
 
G

Gord Dibben

You can group the sheets by CTRL + click on sheet tabs.

On active sheet select the range to delete and hit delete button.

All grouped sheets will have that range deleted.

You may want to select all cells on the active sheet and F5>Special>Constants

This will leave formulas intact.

DO NOT FORGET to ungroup the sheets when done this operation.


Gord Dibben MS Excel MVP
 
R

ryguy7272

1) Click on the tab of one of the sheets that you want to delete data on.
2) Select the range that you want to delete.
3) Hold down the Ctrl key and then click on other sheets that contain the
information that you want to delete.
4) Hit the Delete key.
 
Top