Results 1 to 5 of 5
  1. #1
    Star Lounger
    Join Date
    Jan 2002
    Location
    Minneapolis, Minnesota, USA
    Posts
    54
    Thanks
    4
    Thanked 0 Times in 0 Posts
    Part of my worksheet is formatted with All Borders. Some of the cells have a fill. When I move cell contents, either by cutting or by dragging, the formatting comes with it, and is removed from the original cell. Is there a way to apply or lock formatting so this won't happen?

    I've looked at using the "Format as Table" feature, but I can't get the borders and shading I want, even if I create a new table style.

    I could copy, paste values, then clear the original cells, or I could create a VBA macro, but I would think there should be a simpler way to do this, since it seems like a common problem.

    -Stuart

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    If you cut or drag, you are moving the actual cell, so the formatting goes too.
    Regards,
    Rory

    Microsoft MVP - Excel

  3. #3
    Star Lounger
    Join Date
    Jan 2002
    Location
    Minneapolis, Minnesota, USA
    Posts
    54
    Thanks
    4
    Thanked 0 Times in 0 Posts
    Thanks for the reply. I'm surprised that Excel doesn't provide a simple way to do this. A lot of people format spreadsheets with borders and fill, and then cut/copy/drag information. I would think there would be a lot of requests for this. Oh, well. I guess Bill G. knows best about what we should and shouldn't want..

    -Stuart

  4. #4
    5 Star Lounger
    Join Date
    Jan 2004
    Location
    Praha
    Posts
    990
    Thanks
    56
    Thanked 106 Times in 91 Posts
    There are so many possible results that users might want when dragging cells - MS had to choose one and I suppose its inevitable that that doesn't please everyone.

    However there's an easy workaround - juts use the Format Painter to restore the formatting which is your particular requirement. That;s exactly what it is provided for.

  5. #5
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts
    You might find it preferable to use Copy/Paste Special. There are a number of options in the dialog box that should give you what you want.
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

Posting Permissions

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