Inserting a new Worksheet

G

Guest

i have an Excel file which already has about 7 worksheets, and i want to add
another one and the 'insert worksheet' option is grayed out and i don't know
why. how can i fix this?
 
G

Gord Dibben

Could be the Workbook...........not Worksheet......... is protected under
Tools>Protection.


Gord Dibben MS Excel MVP
 
D

David Biddulph

Look at the workbook protection options. Also look at whether the file is
read-only.
 

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

Inserting sheets into Excel workbook 6
Cannot insert new worksheet 6
Worksheet Problem 2
Excel won't allow me to delete a worksheet. Why? 1
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Insert Worksheet 2
Cannot copy worksheet to another file 2
worksheet renames - specific 0

Top