Results 1 to 7 of 7

how to copy a portion of a sheet?

Threaded View

  1. #1
    Forum Contributor
    Join Date
    02-28-2012
    Location
    india
    MS-Off Ver
    Excel 2019
    Posts
    545

    how to copy a portion of a sheet?

    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
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Copy and paste the template to the next portion of the screen, VBA
    By Lifeseeker in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-13-2012, 12:26 PM
  2. cut a portion of a cell's contents and paste the cut portion into the net column
    By NJEvan in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-12-2010, 05:08 AM
  3. Copy portion of filtered list
    By tcowen61 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-07-2009, 01:31 PM
  4. Replies: 2
    Last Post: 12-06-2008, 02:41 AM
  5. [SOLVED] Buttons in lower portion of workbook appear in upper portion
    By ToferKing in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-22-2006, 01:50 PM
  6. [SOLVED] how do i copy only a portion of a spreadsheet
    By tazsdad in forum Excel General
    Replies: 3
    Last Post: 12-05-2005, 07:20 PM
  7. copy only a portion of a spreadsheet
    By tazsdad in forum Excel General
    Replies: 0
    Last Post: 12-05-2005, 06:15 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1