software

I was given a formated spreadsheet and needed to make changes. One change
was to merge a few cells. when I opened the format cells menu the merge
cells check box was greyed out. I can't find how to enable this function.

If the workbook is shared, you won't be able to merge cells.

To turn off sharing, choose Toolsgt;Share Workbook, and remove the check
mark from 'Allow changes by more than one user at a time.'

pm wrote:
gt; I was given a formated spreadsheet and needed to make changes. One change
gt; was to merge a few cells. when I opened the format cells menu the merge
gt; cells check box was greyed out. I can't find how to enable this function.--
Debra Dalgleish
Excel FAQ, Tips amp; Book List
www.contextures.com/tiptech.htmlThanks for your reply Debra, but the workbook indicates that it is allowing
changes by more than one user.

quot;Debra Dalgleishquot; wrote:

gt; If the workbook is shared, you won't be able to merge cells.
gt;
gt; To turn off sharing, choose Toolsgt;Share Workbook, and remove the check
gt; mark from 'Allow changes by more than one user at a time.'
gt;
gt; pm wrote:
gt; gt; I was given a formated spreadsheet and needed to make changes. One change
gt; gt; was to merge a few cells. when I opened the format cells menu the merge
gt; gt; cells check box was greyed out. I can't find how to enable this function.
gt;
gt;
gt; --
gt; Debra Dalgleish
gt; Excel FAQ, Tips amp; Book List
gt; www.contextures.com/tiptech.html
gt;
gt;

That's the problem. By allowing multiple people to update the file (also known
as sharing the file), there are features that aren't available.

You have to decide to unshare the workbook (like Debra wrote) or decide to not
merge anymore cells.

pm wrote:
gt;
gt; Thanks for your reply Debra, but the workbook indicates that it is allowing
gt; changes by more than one user.
gt;
gt; quot;Debra Dalgleishquot; wrote:
gt;
gt; gt; If the workbook is shared, you won't be able to merge cells.
gt; gt;
gt; gt; To turn off sharing, choose Toolsgt;Share Workbook, and remove the check
gt; gt; mark from 'Allow changes by more than one user at a time.'
gt; gt;
gt; gt; pm wrote:
gt; gt; gt; I was given a formated spreadsheet and needed to make changes. One change
gt; gt; gt; was to merge a few cells. when I opened the format cells menu the merge
gt; gt; gt; cells check box was greyed out. I can't find how to enable this function.
gt; gt;
gt; gt;
gt; gt; --
gt; gt; Debra Dalgleish
gt; gt; Excel FAQ, Tips amp; Book List
gt; gt; www.contextures.com/tiptech.html
gt; gt;
gt; gt;

--

Dave Peterson

Thanks Dave. I had not seen this happen before and have used files people
sent to me.

quot;Dave Petersonquot; wrote:

gt; That's the problem. By allowing multiple people to update the file (also known
gt; as sharing the file), there are features that aren't available.
gt;
gt; You have to decide to unshare the workbook (like Debra wrote) or decide to not
gt; merge anymore cells.
gt;
gt; pm wrote:
gt; gt;
gt; gt; Thanks for your reply Debra, but the workbook indicates that it is allowing
gt; gt; changes by more than one user.
gt; gt;
gt; gt; quot;Debra Dalgleishquot; wrote:
gt; gt;
gt; gt; gt; If the workbook is shared, you won't be able to merge cells.
gt; gt; gt;
gt; gt; gt; To turn off sharing, choose Toolsgt;Share Workbook, and remove the check
gt; gt; gt; mark from 'Allow changes by more than one user at a time.'
gt; gt; gt;
gt; gt; gt; pm wrote:
gt; gt; gt; gt; I was given a formated spreadsheet and needed to make changes. One change
gt; gt; gt; gt; was to merge a few cells. when I opened the format cells menu the merge
gt; gt; gt; gt; cells check box was greyed out. I can't find how to enable this function.
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; --
gt; gt; gt; Debra Dalgleish
gt; gt; gt; Excel FAQ, Tips amp; Book List
gt; gt; gt; www.contextures.com/tiptech.html
gt; gt; gt;
gt; gt; gt;
gt;
gt; --
gt;
gt; Dave Peterson
gt;