A1:A5 contain =
APPLE
BOOK
TABLE
PENCIL
GLASS
define name A1:A5 = note
How to show define name 'note' to another cells? ex: on C6:C10 not from C1:C5
ex. on C6 =note > Enter so it will be paste note content to C6-C10
A1:A5 contain =
APPLE
BOOK
TABLE
PENCIL
GLASS
define name A1:A5 = note
How to show define name 'note' to another cells? ex: on C6:C10 not from C1:C5
ex. on C6 =note > Enter so it will be paste note content to C6-C10
Last edited by putritersenyum; 03-19-2016 at 05:13 AM.
Select C6:C10
Type =note and press Shift, Ctrl and Enter together.
thanks a lot jason.b75. it works.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks