Microsoft Office Forums - View Single Post - [Solved] Transposing a worksheet

Thread: [Solved] Transposing a worksheet

View Single Post

Old

04-23-2017, 12:31 AM

xor

xor is offline

xor uses Windows 10

Windows 10 xor uses Office 2016

xor uses Office 2016

Office 2016

Expert

Join Date: Oct 2015

Posts: 1,100

xor is a name known to all

xor is a name known to all

xor is a name known to all

xor is a name known to all

xor is a name known to all

xor is a name known to all

Default

Press Formulas (on the Ribbon) then Name Manager. Press New and write name (for example d) in the Name field. Select the Refers to field and select the relevant range (for example b_1!$A$1:$S$10) and press OK.

Reply With Quote