15+ Uses of Excel Name Box - The ‘nothing’ box that has a ‘name’ is nothing like what you believe

By Hasaan Fazal on September 19, 2014

Tip # 4: Select cells in addition to active cell

If you are in B1 and you type B10 into the name box, press and hold down the Ctrl key and press enter you will select only two cells i.e. B1 and B10. Remember SHIFT key will select the range whereas CTRL key will select only the cell you mentioned in the name box. Check previous tip to make sure.

name 4

<< Tip# 3 | Tip# 5 >>

Pages: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17

Posted in Excel | Leave a response

Hasaan Fazal

Teaching professional business subjects to the students of FIA, ACCA, CIMA, CA etc. He also found ACCA LIVE which is Pakistan's first portal to provide online classes and distance learning solutions to FIA/ACCA students. At PakAccountants.com he is busy making study material for different qualifications. Beside writing articles he answers questions asked using ASK TUTOR!