way to delete the input area on several Excel spreadsheets

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to delete the data input area of several worksheets at the
same time using a macro maybe?
 
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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combine several spreadsheets with multiple worksheets into 1 file 5
USB input stopped working. 4
Can I save different print areas? 3
need to input alternate blank rows in spreadsheet 5
Need macro to post data from user input 3
Protecting/Unprotecting all sheets with macro leads to "image" iss 3
Use Go to function to identify dependent cells between worksheets 2
spreadsheet 1

Back
Top