How to Make Smaller Columns Under the Main Column in Excel

Save

Excel 2013 doesn't offer an option to split columns to create smaller columns, but it does enable you to merge cells. Using this option, you can create a larger cell or column of cells situation above regularly sized columns. You can then shrink those columns so they appear smaller. If you need the smaller columns to appear within a dense data set, you might also need to add columns to the spreadsheet.

  • Click and drag your mouse over one or more top column letters to select each column. The number of columns you select should represent the number of smaller columns you want. New columns will be added immediately before the first selected column. As an example, if you wanted three new columns immediately to the right of column D, select column letters "E," "F" and "G."

  • Click the "Home" tab, and select "Insert" from the Cells group to add new columns. In the example, this adds three new columns that are labeled E, F and G.

  • Click and drag the divider line between any selected columns to resize the columns. Dragging to the left narrows the selected columns. In the example, you might drag the divider line between columns E and F to resize all selected columns.

  • Click and drag your mouse over each new column's cells in the first row. Continuing with the example, click and drag over cells "E1," "F1" and "G1" to select them.

  • Click the "Merge & Center" button in the Home tab's Alignment group to merge the selected cells and center data. Alternatively, click the "Merge & Center" drop-down arrow, and then select "Merge Cells" to merge the cells without centering the data.

  • Click and drag the cell's bottom right fill handle downward to create a column of larger cells above the smaller columns.

References

Promoted By Zergnet

Comments

Related Searches

Check It Out

Geek Vs Geek: Robot battles, hoverboard drag race, and more

M
Is DIY in your DNA? Become part of our maker community.
Submit Your Work!