Yet I have tried to code this and VS complains at all the different ways I. Surely I should just be able to Loop round the columns in an Excel file and read the Column headers or names or whatever they are called.

To expand or shrink the row yourself, click on the line after the column or row that you want to resize and drag it up/down or left/right. To make the column or row expand itself to whatever the biggest cell is, double click on the right of the column or row. In the Split Cells dialog, select the number of columns and rows that you want and then click OK.In the table, click the cell that you want to split.Then the minus sign is displayed on the left of selected rows, or displayed at the top of the selected columns.įurthermore, how do I split a cell in half in Excel? Split cells Select the entire rows or columns you need to hide or unhide with plus or minus sign, then click Group in the Outline group under Data tab. Just so, how do you insert a plus sign in Excel to hide columns?