Reference a range of cells on all sheets in Excel
Fresh3 days ago
Mar 15, 202629545 viewsConfidence Score0%
0%
Problem
In Excel, references an entire column on the current sheet while references that entire column on explicitly. Is there a way to reference column on all sheets without manually typing all the sheet names?
Error Output
=$J:$J
Unverified for your environment
Select your OS to check compatibility.
1 Fix
Canonical Fix
Unverified Fix
New Fix – Awaiting Verification
Fix for: Reference a range of cells on all sheets in Excel
Low Risk
You can try using 3D cell references. Select the cell in which you'd like to place the reference. Type . While holding Shift, click the first sheet and then click the last sheet. Select the column that you want to reference. You'll end up with somet…
Awaiting Verification
Be the first to verify this fix
Sign in to verify this fix