ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Why can't I merge any cells in the workbook? (https://www.excelbanter.com/excel-discussion-misc-queries/43051-why-cant-i-merge-any-cells-workbook.html)

Excel User

Why can't I merge any cells in the workbook?
 
I tried pressing enter like the help assistant says but that didn't work.
None of the cells will merge. I wonder if it's because it's a shared
workbook but I don't know how it got shared in the first place.

Dave Peterson

Lots of features don't work with shared workbooks.

Look in excel's help for: Features that are unavailable in shared workbooks
for a big list.

If it's your workbook and it shouldn't be shared, you can use:

Tools|share workbook
to turn it off.

(If the workbook was developed for multiple users to share, don't do this.)

Excel User wrote:

I tried pressing enter like the help assistant says but that didn't work.
None of the cells will merge. I wonder if it's because it's a shared
workbook but I don't know how it got shared in the first place.


--

Dave Peterson

rog

same problem with me, even if I unshare it - i have the same problem. Cannot
(un)merge cells.


"Dave Peterson" wrote:

Lots of features don't work with shared workbooks.

Look in excel's help for: Features that are unavailable in shared workbooks
for a big list.

If it's your workbook and it shouldn't be shared, you can use:

Tools|share workbook
to turn it off.

(If the workbook was developed for multiple users to share, don't do this.)

Excel User wrote:

I tried pressing enter like the help assistant says but that didn't work.
None of the cells will merge. I wonder if it's because it's a shared
workbook but I don't know how it got shared in the first place.


--

Dave Peterson


Dave Peterson

Is the worksheet protected?

rog wrote:

same problem with me, even if I unshare it - i have the same problem. Cannot
(un)merge cells.

"Dave Peterson" wrote:

Lots of features don't work with shared workbooks.

Look in excel's help for: Features that are unavailable in shared workbooks
for a big list.

If it's your workbook and it shouldn't be shared, you can use:

Tools|share workbook
to turn it off.

(If the workbook was developed for multiple users to share, don't do this.)

Excel User wrote:

I tried pressing enter like the help assistant says but that didn't work.
None of the cells will merge. I wonder if it's because it's a shared
workbook but I don't know how it got shared in the first place.


--

Dave Peterson


--

Dave Peterson


All times are GMT +1. The time now is 10:59 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com