• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

worksheet level names not appearing in Paste name dialog box

A

Abhay

New Member
Hi,

I have given a "Trial" as worksheet level name in Sheet 1. When I go to Sheet 2 and I want to enter that in a formula. I can manually enter this as "=Sheet1!Trial" in a particular cell.

My question is when I type"=" and then press F3 which displays "Paste Name" dialog box. This box does not show any sheet level names. It only shows workbook level and names if any in particular sheet in box.

Is there a way I can display sheet level names also in "Paste Name" dialog box prefixed with sheet names as identifier. This way I can just type "=" > press F3 > select a particular name > Press enter.

This something similar to auto formula complete / table name appears when we enter any particular formula.
 
Hi,

I think there is no direct approcah to show worksheet level named range in "Paste Name" dialog box.
 
You must log in or register to reply here.
Back
Top