Google-sheets – Duplicating a set of columns with various widths within the same spreadsheet

google sheets

I'm trying to duplicate a set of 5 columns multiple times on the same sheet. For example, column A is wide, columns B & E are medium width and Columns C & D are narrow. I want to duplicate this width format multiple times in the adjoining columns. Is that possible without having to manually adjust each column?

Best Answer

It seems that Google Spreadsheets doesn't consider column width a format that can be copied. Paint format and selecting the entire column don't work.

Related Solutions

Google-sheets – Identifying and working with any cells that match

I'd suggest a pivot table and for this it may be a good idea to label your Original Table (say Fruit in A4 and Qty in B4) though not essential. Then select from A4 to as far down in B as you are likely to require (but can be changed later if still insufficient) and Data, Pivot table report..., click on - Add field next to Rows and select Fruit, click on - Add field next to Values and select Qty.

You can copy the resulting table back in to the original sheet if you wish.

Google-sheets – Case insensitive character string filter for multiple individual columns (dynamic input for each)

It appears that you are using regexmatch just to test string equality. This isn't necessary, equalities can be entered simply as Data!A:A = A1. You don't even need lower, because string comparison in filter is case-insensitive:

=filter(Data!A:R, Data!A:A = A1, Data!B:B = B, Data!C:C = C1)

(Also, there is no need for single quotes around sheet name when it does not contain spaces.)

Best Answer

Related Solutions

Google-sheets – Identifying and working with any cells that match

Google-sheets – Case insensitive character string filter for multiple individual columns (dynamic input for each)

Related Topic