ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   merge cells disabled how do I enable (https://www.excelbanter.com/excel-worksheet-functions/180171-merge-cells-disabled-how-do-i-enable.html)

Gary

merge cells disabled how do I enable
 
I have an xcel spreadsheet that has merge cells button disabled. How do I
enable this button?

Sean Timmons

merge cells disabled how do I enable
 
Is the workbook shared? If so, you would need to unshare it first.
If not, is it protcted? May want to unprotect it first...

"Gary" wrote:

I have an xcel spreadsheet that has merge cells button disabled. How do I
enable this button?


Don Guillett

merge cells disabled how do I enable
 
That's a GOOD thing. Use center across instead

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Gary" wrote in message
...
I have an xcel spreadsheet that has merge cells button disabled. How do I
enable this button?



[email protected]

merge cells disabled how do I enable
 
Don't know if this helps but I got confused because I expected the merge cells to be enabled when I multi-select cells via click and not drag. You need to actually drag to trigger merge cell to be enabled, which is indicated by the difference in how the cell borders are highlighted. But, it was confusing because I expected it to be there as long as the cells were selected, whether individually or together :)


On Saturday, March 15, 2008 at 7:04:59 AM UTC-7, Don Guillett wrote:
That's a GOOD thing. Use center across instead

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Gary" wrote in message
...
I have an xcel spreadsheet that has merge cells button disabled. How do I
enable this button?



[email protected]

merge cells disabled how do I enable
 
On Wednesday, September 2, 2015 at 9:08:39 PM UTC+2, wrote:
Don't know if this helps but I got confused because I expected the merge cells to be enabled when I multi-select cells via click and not drag. You need to actually drag to trigger merge cell to be enabled, which is indicated by the difference in how the cell borders are highlighted. But, it was confusing because I expected it to be there as long as the cells were selected, whether individually or together :)


Wow! That's it, I had no idea there was a difference, thanks!

[email protected]

merge cells disabled how do I enable
 
On Thursday, September 3, 2015 at 12:38:39 AM UTC+5:30, wrote:
Don't know if this helps but I got confused because I expected the merge cells to be enabled when I multi-select cells via click and not drag. You need to actually drag to trigger merge cell to be enabled, which is indicated by the difference in how the cell borders are highlighted. But, it was confusing because I expected it to be there as long as the cells were selected, whether individually or together :)


On Saturday, March 15, 2008 at 7:04:59 AM UTC-7, Don Guillett wrote:
That's a GOOD thing. Use center across instead

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Gary" wrote in message
...
I have an xcel spreadsheet that has merge cells button disabled. How do I
enable this button?


Thanks buddy, It worked

Auric__

merge cells disabled how do I enable
 
narendra.jangir wrote:

On Thursday, September 3, 2015 at 12:38:39 AM UTC+5:30,
wrote:
Don't know if this helps but I got confused because I expected the
merge

cells to be enabled when I multi-select cells via click and not drag.
You need to actually drag to trigger merge cell to be enabled, which is
indicated by the difference in how the cell borders are highlighted.
But, it was confusing because I expected it to be there as long as the
cells were selected, whether individually or together :)

On Saturday, March 15, 2008 at 7:04:59 AM UTC-7, Don Guillett wrote:
That's a GOOD thing. Use center across instead

"Gary" wrote in message
...
I have an xcel spreadsheet that has merge cells button disabled. How
do I enable this button?


Thanks buddy, It worked


You replied to 2-1/2-year-old reply to a ***TEN-YEAR-OLD*** post with what
amounts to "me too". ****ing Google groupies. If you don't have something
meaningful to add to a thread, DON'T ****ING POST!

--
He showed the grace and elegance of the Incredible Hulk at a tea-party.

Bernard Etienne Fety

merge cells disabled how do I enable
 
Le jeudi 12 avril 2018 Ã* 09:20:31 UTC+2, Auric__ a écritÂ*:
narendra.jangir wrote:

On Thursday, September 3, 2015 at 12:38:39 AM UTC+5:30,
wrote:
Don't know if this helps but I got confused because I expected the
merge

cells to be enabled when I multi-select cells via click and not drag.
You need to actually drag to trigger merge cell to be enabled, which is
indicated by the difference in how the cell borders are highlighted.
But, it was confusing because I expected it to be there as long as the
cells were selected, whether individually or together :)

On Saturday, March 15, 2008 at 7:04:59 AM UTC-7, Don Guillett wrote:
That's a GOOD thing. Use center across instead

"Gary" wrote in message
...
I have an xcel spreadsheet that has merge cells button disabled. How
do I enable this button?


Thanks buddy, It worked

You replied to 2-1/2-year-old reply to a ***TEN-YEAR-OLD*** post with what
amounts to "me too". ****ing Google groupies. If you don't have something
meaningful to add to a thread, DON'T ****ING POST!

--
He showed the grace and elegance of the Incredible Hulk at a tea-party.

It is helpfull


All times are GMT +1. The time now is 05:22 PM.

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