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
Recommended Productivity Tools
Office Tab: Bring handy tabs to Excel and other Office software, just like Chrome, Firefox and new Internet Explorer.Try now
Kutools for Excel: 200 new features for Excel, make Excel much easy and powerful, increase productivity immediately.Try now
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:
Navigation--AutoText (add usually used range cells to AutoText pane, one click to insert it to any sheets if you need.) |
Relative Articles:
Recommended Productivity Tools
Office Tab
Bring handy tabs to Excel and other Office software, just like Chrome, Firefox and new Internet Explorer.
Kutools for Excel
Amazing! Increase your productivity in 5 minutes. Don't need any special skills, save two hours every day!
200 New Features for Excel, Make Excel Much Easy and Powerful:
- Merge Cell/Rows/Columns without Losing Data.
- Combine and Consolidate Multiple Sheets and Workbooks.
- Compare Ranges, Copy Multiple Ranges, Convert Text to Date, Unit and Currency Conversion.
- Count by Colors, Paging Subtotals, Advanced Sort and Super Filter,
- More Select/Insert/Delete/Text/Format/Link/Comment/Workbooks/Worksheets Tools...
