named ranges question

C

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 ?
 
G

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
 
Top