Thread: copy worksheet
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
Gordon[_9_] Gordon[_9_] is offline
external usenet poster
 
Posts: 56
Default copy worksheet

"KRK" wrote in message
...
Hello

I have a workbook which contains several worksheets, all identical (except
for their input data). When I create (insert) a new worksheet I can copy &
paste cells from an existing sheet into the new one. This is fine, except
that the column widths & row heights dont come out right.

I can get over this OK, but is there a way to copy an old sheet into a new
one and preserve the rows & columns?



Have you tried right-clicking on the worksheet tab, and choosing Copy?

--
Asking a question?
Please tell us the version of the application you are asking about,
your OS, Service Pack level
and the FULL contents of any error message(s)