Names of workbook cell ranges not accepted with some signs

Z

zzxxcc

I have named a range of cells based on the top row in each column. S1:CR20.
Some names need signs like"/" and "-" and """, etc. This doesen work with
conditional validation. In A1 i use Validation>List> =S1:CR1. In B1 i use
Validation>List> =indirect(A1) and conditional formating. Is there a way to
make this work? I mean: To make Excel accept the different signs.

Also is there a way to delete all names in the workbook in one operation? I
am familiar with Insert>Name>Define>(select one)>Delete.

Thanks,
zzxxcc
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top