Mastering 3-D Range Names in Excel

Open the Name Manager, and click New. (correct)

Press the Shift key while selecting the new sheet.

Open the New Range window, and click 3-D.

Click a cell to insert the cell reference.

To open the New Range window.

To open the Name Manager.

To create a 3-D range name. (correct)

To insert a cell reference.

Open the Name Manager, and click New.

Open the New Range window, and click 3-D.

Click a cell to insert the cell reference. (correct)

Press the Shift key while selecting the new sheet.

<p>Open the New Range window, and click 3-D = First step Press the Shift key while selecting the new sheet = Not a step Open the Name Manager, and click New = Not a step Click a cell to insert the cell reference = Not a step</p> Signup and view all the answers