+ Reply to Thread
Results 1 to 4 of 4

Lock designed cells

  1. #1
    Registered User
    Join Date
    10-12-2012
    Location
    Göteborg, Sweden
    MS-Off Ver
    Excel 2010
    Posts
    48

    Lock designed cells

    Hi!

    This might be a easy fix but anyways,

    I doing some tables and giving them some kind of "design". What i wanna be able todo is that when pasting any
    information from an different excel with some other "design", i want my cells to locked how i designed them, no matter what im pasting.

    Example,
    my cells are in "tahoma size 8, light orange background and border thick border around it"

    and i'm pasting information from a table with comic sans size 20, purple background.


    Possible?

  2. #2
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: Lock designed cells

    Do Paste Special - Values instead of just paste.

  3. #3
    Valued Forum Contributor Harribone's Avatar
    Join Date
    02-24-2013
    Location
    Midlands, UK
    MS-Off Ver
    Excel 2019/365
    Posts
    570

    Re: Lock designed cells

    When you paste, select the top left corner of the area you're pasting into and right click and choose 'Paste Special Values' this will only paste the data and not the source formatting.
    Say thanks, click *

  4. #4
    Registered User
    Join Date
    10-12-2012
    Location
    Göteborg, Sweden
    MS-Off Ver
    Excel 2010
    Posts
    48

    Re: Lock designed cells

    Well, that was an really easy fix, but there is no way to lock the cells in someway?

    Thanks guys!

+ 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