named ranges question

[Chris]

I have a sheet that has formatted boxes of information in it. I would
like to carry over the entire format to another sheet using the name
of the range. Is this possible without VBA ?

 

[Gary''s Student]

Yes it is. Once you have named the range of cells, you can:

Edit > Goto... and pick the name. The its just copy, move to the
destination, and paste/special/formats

 

[Don Guillett]

or f5