How-To Geek on MSN
I stopped manually naming ranges in Excel—this little-known shortcut does it in seconds
Create dozens of named ranges at once, write clearer formulas, and even update existing formulas automatically.
How-To Geek on MSN
Your Excel workbook has a game-changing productivity tool you've probably never used
Use Excel's overlooked Name Box to jump between worksheets, select huge ranges, create named ranges, and organize even the ...
Microsoft Excel’s Name box is a powerful tool for its size. Use it to move around, create range names and even enter functions. Scrolling around a large sheet can be tedious, awkward, and occasionally ...
Please note: This item is from our archives and was published in 2022. It is provided for historical reference. The content may be out of date and links may no longer function. Using range names in ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results