Select the range to copy
Edit|copy

Select the top left corner of the range to paste
Edit|paste special|click the transpose button.

StephenF wrote:

I have cells in worksheets sheets Jan to Dec stored in columns that I wish to
have copied across to a summary sheet and store them in rows.

Is it possible to do this?

--

Dave Peterson