To copy only the visible cells, select the entire range of data, including the grouped and hidden rows. Then press F5 (or Fn + F5) to open the Go To dialog box. Alternatively, you may press Ctrl ...

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.