Make Columns Release For Free

About This Article Click the Data tab. Click Group. Select Columns and click OK. Click ? to collapse. Click + to uncollapse.

Combine data from 2 columns into 1 column Select the cell where you want to put the combined data. Type = and select the first cell you want to combine. Type & and use quotation marks with a space enclosed. Select the next cell you want to combine and press enter. An example formula might be =A2&" "&B2.

Double-click the item that you want to expand or collapse. Right-click the item, click Expand/Collapse, and then do one of the following: To see the details for the current item, click Expand. To hide the details for the current item, click Collapse.

Applying Keyboard Shortcut Click on any cell of Column D. Press the CTRL + SPACEBAR at the same time. It will select the entire column. Now, press the SHIFT key and click on the right arrow key from the keyboard twice. ... Last but not the least, press CTRL + 0 from your keyboard, and your columns will collapse.

In case you want to unfreeze the columns, open the View tab, open the Freeze Panes options in the Window group, and click Unfreeze Panes.

Freeze columns and rows Select the cell below the rows and to the right of the columns you want to keep visible when you scroll. Select View > Freeze Panes > Freeze Panes.

The best shortcut to collapse groups in Excel is to use the keyboard shortcut "Alt + Shift + Left Arrow". This shortcut collapses the selected group to its summary row or column. If you want to expand the group again, you can use the "Alt + Shift + Right Arrow" shortcut.

If you have an Excel table where multiple columns are hidden and want to show only some of them, follow the steps below. Select the columns to the left and right of the column you want to unhide. ... Go to the Home tab > Cells group, and click Format > Hide & Unhide > Unhide columns.