View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Studebaker Studebaker is offline
external usenet poster
 
Posts: 57
Default What does InsertNameLabel & InsertNamePaste do?

I typed in a label in B1 called My Sales. I used InsertNameCreate to create
a named range for B2 to B10 with the My Sales label I typed as the named
range.

I understand that if I click InsertNameApply it will replace the B2 to B10
range I have already used in a formula with the name, My Sales. So what does
InsertNamePaste do?

Also, what does InsertNameLabel do? I thought I created labels just by
typing them into the spreadsheet at the top of the column of data I want to
label.

Thanks