Cell merge & Validation Break??

zaphod86

New Member
Joined
Dec 30, 2005
Messages
2
This happens to nearly every spreadsheet I make.

After a couple weeks of use, I'll never be able to merge or unmerge cells (the checkbox is blocked with an ominous grey block)

With that same spreadsheet (I wanted to add drop-down lists after I saw MR.Excels's demo on Call for Help) Validation is also greyed-out...

With a new spreadsheet, I'm able to merge and validate lists to my heart's content, however I'm perplexed to why those features "break"

It's annoying having to paste everything over into a fresh spreadsheet just to get the those functions to work again.

Help would be appreciated.. - thanks
 

Some videos you may like

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).

Barry Katcher

Well-known Member
Joined
Feb 25, 2002
Messages
4,053
Hi, zaph. Welcome to the Bored.

This may be too simplistic, but let me ask you: have you protected your worksheet? If so, the merge and validation options WILL be greyed out.
 

zaphod86

New Member
Joined
Dec 30, 2005
Messages
2
That was it - sharing the sheet.

It was the "share workbook" option that allows multiple users to access the sheet simultaneously. When I uncheck that option, I can again merge cells and make changes to data validation.

Thanks.
 

Watch MrExcel Video

Forum statistics

Threads
1,119,002
Messages
5,575,504
Members
412,672
Latest member
vitaminshop20
Top