How to insert or display named range on another sheet?
In some cases, you may want to insert or display a named range data in another sheet, but by default, when you type the formula =name(the range name), and press Enter key, it only inserts the first data of the named range as below screenshot shown. In this article, I introduce the way to quickly insert the whole data of the named range into another sheet.
Display named range on another sheet
Display named range on another sheet
To display a named range on another sheet, you just need to use the formula =name (the range name) and press Shift + Ctrl + Enter keys together.
Select a range which you will place the named range, and type the formula =name, the name is the named range you want to display, press Shift + Ctrl + Enter keys. See screenshot:
Relative Articles:
Best Office Productivity Tools
Supports Office/Excel 2007-2021 and 365 | Available in 44 Languages | Easy to Uninstall Completely
Kutools for Excel Boasts Over 300 Features, Ensuring That What You Need Is Just A Click Away...
Supercharge Your Excel Skills: Experience Efficiency Like Never Before with Kutools for Excel (Full-Featured 30-Day Free Trial)
Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier
- Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
- Open and create multiple documents in new tabs of the same window, rather than in new windows.
- Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day! (Full-Featured 30-Day Free Trial)






