Why Grouping Is Better Than Hiding Before I show you how to create column groups in Excel, let me explain the many benefits of using this method over hiding and unhiding columns.

To make all cells the same size in Excel and Google Sheets, select all the columns/row and then click on the Format tool to change the Column width or Row height.