Can you bulk link columns?

camr

I know you can bulk link multiple rows by selecting them all during the linking process.

Does this not work the same way with columns?

Thank you,

Cam

KPH

If you mean using "Link from Cell in Other Sheet" then yes, you can select multiple columns, right click, choose "Link from Cell in Other Sheet" and select multiple columns in the other sheet.

camr

When I select multiple cells across columns to link, only the first selection actually links.

Maybe I'm doing it wrong?

Genevieve P.

Hey @camr

The way I would do this is first right-click on the starting cell that you want to link into. Then in the pop-up window, select the cells either across one row or across a range that you want to link.

In my example, I've selected the first cell in the Primary column as the one to Cell Link in, then in my range I've selected all the cells from Name1 to F3:

This then links in all 12 cells in the same order:

Cheers,

Genevieve

camr

Thank you! I was trying to link a set of rows from a summary to a master sheet.

Seems that doesn't work, but when it's columns in a summary sheet, it does.

Columns to columns, rows to rows.

Thanks,

Cam