I want to copy a portion of a sheet to another part of the same sheet. pls see the attached file. I want to copy and paste from A1:G11. When I select A1:G11 and paste the format is lost,the row height is lost and the shape is lost. When i select row A1:A11 and paste I do get all . But this is not accetable since there may be some data after the G column and I don't want to copy these cols. kindly help
Bookmarks