#Digitaltechnepal #Howto
In this video you will learn...
How to enable merge and center in Excel 2010|2019

Chander has a worksheet in which he Excel to apply Merge and Center to a selection. However, the tool is continually grayed out on his worksheet and Paul can't figure out why. He wonders if there is some combination of formats or settings that disables the tool.
If you turn off sharing (if it is on) and disable protection (if the worksheet is protected), then the tool should once again be available.
The third potential cause is if the cells you've selected are in a table, instead of a range of cells. If the cells are part of a formatted table (the Format as Table tool, on the Home tab of the ribbon was used), then you cannot merge cells within the table. The only solution in this case is to convert the table to a range, and then you can once again access the tool.
Actually, there are at least three conditions that can cause the Merge and Center tool to be unavailable. You should check, first, to see if your worksheet is protected. Second, you should check to see if the workbook is shared. Both protection and sharing have been discussed in other issues of ExcelTips, and both of them happen to disable Merge and Center. (Actually, they disable a lot of other commands in addition to Merge and Center.)
In many instances, your best bet is to simply not use the Merge and Center tool. Instead, check to see if Center Across Selection will do the trick for you. Many Excel users (and most longtime Excel users) consider Center Across Selection to be far superior to Merge and Center. You can use this setting by selecting the cells you want to center across and then using the Horizontal drop-down list on the Alignment tab of the Format Cells dialog box.


how to enable merge and center in excel table
How to enable merge and center in excel 2010 using
how to enable merge and center in excel 2016
merge and center in excel shortcut
how to merge cells in excel without using merge and center
how to merge rows in excel
how to merge columns in excel
merge and center greyed out in excel


Copyright Disclaimer Under Section 107 of the Copyright Act 1976, allowance is made for 'Fair Use'
for purposes such as criticism, comment, news reporting, teaching, scholarship, and research,
Fair use is a permitted by copyright statute that might otherwise be infringing,
Non-profit, educational or personal use tips the balance in favor of fair use


Social Link:-
[ Ссылка ]
[ Ссылка ]
[ Ссылка ]
[ Ссылка ]
[ Ссылка ]
[ Ссылка ]

свернуть