+ Reply to Thread
Results 1 to 4 of 4

Keeping cell formatting when copying

  1. #1
    Forum Contributor
    Join Date
    11-14-2009
    Location
    Midwest
    MS-Off Ver
    Excel 2003/2007
    Posts
    103

    Keeping cell formatting when copying

    Is there a way to keep formatting the same, specifically row and column size, when copy/pasting a section of cells in excel? Basically, I have a page formatted the way I want it and now want to duplicate it in the same sheet. Any thoughts?

  2. #2
    Valued Forum Contributor Miraun's Avatar
    Join Date
    04-03-2009
    Location
    New England
    MS-Off Ver
    2003, 2007, 2010, 2013
    Posts
    554

    Re: Keeping cell formatting when copying

    Hey Bibleguy;

    Of course there is!

    There are a couple of ways to accomplish this.

    After you've copied your data to the clipboard, instead of doing the Ctrl + V to paste, use Alt, E, S. (sequential) This will being up the Paste Special bar. Here, you can select exactly what you want to paste from the original array. You can select the formats, the values, whatever you want that apply!

    Alternative!

    On 2007, check out the Home ribbon, and on the far left, next to the copy/paste area, there is a paintbrush. This is the Format Painter. Clicking on this, and then selecting the formatted array that you want to copy will allow you to paste that formatting to another area. I'm not sure of an alternative way to explain it if that didn't make sense, but if you play with it, I'm sure you'll see what I mean.
    Going for Guru! Click the Star to the bottom left of this post if I helped!

  3. #3
    Forum Contributor
    Join Date
    11-14-2009
    Location
    Midwest
    MS-Off Ver
    Excel 2003/2007
    Posts
    103

    Re: Keeping cell formatting when copying

    Thanks for the suggestions, however neither one affected the size of the rows and columns, which is what I'm really after. With the normal paste function all the formatting stayed the same except for the height of the rows and the width of the columns. Any other ideas? I am on Excel 2003 by the way, if that helps.

  4. #4
    Registered User
    Join Date
    02-03-2015
    Location
    mi
    MS-Off Ver
    14.4.1
    Posts
    1

    Re: Keeping cell formatting when copying

    I use a mac's version of office not sure if that makes a difference, but I had to do a special paste with just column withs and then do a regular paste with the date. That was the only way I could paste the info with out it changing the cell with.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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