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.
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:
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
- To post as a guest, your comment is unpublished.· 5 months agoYou need to select a larger area before you enter the formula and hit the key combination. If you only select one cell, it will only show one cell.
- To post as a guest, your comment is unpublished.· 7 months agohi, when i click, shift+cntrl + enter i still only get the 1st row any ideas? note i have UK settings (semi colon delimiter, etc) thanks a million, this one is killin me
- To post as a guest, your comment is unpublished.· 5 months agoSelect a large range which can place all the values of the name, if you juse select single cell to place, only the first one shown.
- To post as a guest, your comment is unpublished.· 7 months agohello, when i try to display the range with cntrl shift enter i only get the 1st row, any ideas? THANKS