To decrease the font size use Ctrl + Shift + combination To quickly create a table type a plus sign (+) then press Tab key again type a plus and again press Tab key do this as many times as the number of cells you want in your table. If the text is too wide to fit the column width but don’t want that text to spill over into adjacent cells, you can use either the Wrap Text option or the Shrink to Fit option to accommodate that text. Excel 2010 automatically recognizes all the Ctrl shortcut keys that were used in legacy versions of Excel. Unmerge Cells − Unmerges the selected cells. Merge Cells − Merges the selected cells without applying the Center attribute. Merge Across − When a multi-row range is selected, this command creates multiple merged cells - one for each row. The Home » Alignment group » Merge & Center control contains a drop-down list with these additional options − In Excel, you can select multiple non continuous ranges in a sheet. To merge cells, select the cells that you want to merge and then click the Merge & Center button.Ĭhoose Alignment tab of the Format Cells dialogue box to merge the cells. There is an easy way to access the tab Merge and Center command using the Alt key. You can merge cells by various ways as mentioned below.Ĭhoose Merge & Center control on the Ribbon, which is simpler. Rather, you combine a group of cells into a single cell that occupies the same space. When you merge cells, you don’t combine the contents of the cells. MS Excel enables you to merge two or more cells.
0 Comments
Leave a Reply. |