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

Tip # 6: Select multiple specific ranges

If you type A1:B10,D1:E10 in the name box and press enter key you will select two ranges separately i.e. A1 through B10 and D1 through E10. Pay attention to placement of colon and comma.

name 6

<< Tip# 5 | Tip# 7 >>

Excel Linked Objects - Making Excel Reports that Spread the Word
Excel ALTernate 'Powercut' - One key to rule ALL shortcut keys
Profile photo of 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!

Find ME on Google+

Leave a Reply

You must be logged in to post a comment.

Read previous post:
Why YOU! So miserable? - 3 lessons to learn from an 8 years old Kid to LIVE what you LOVE

The Curious Case of Miserable YOU! Just in case you are guessing what's wrong with the website today then don't worry...

Close