+ Reply to Thread
Results 1 to 5 of 5

How to lock cell width and height for an entire worksheet

  1. #1
    Registered User
    Join Date
    03-11-2010
    Location
    Orange City, Iowa
    MS-Off Ver
    Excel 2004
    Posts
    4

    How to lock cell width and height for an entire worksheet

    Hello everyone!

    I'm trying to figure out how to lock the width and height of all cells in a worksheet. I have a lot of charts and graphs as well as lots of other data that is updated on a monthly basis. If the column width or row height is messed with, the worksheet gets all wonky and the charts spaz out.

    I'd like to keep the document editable, but I need to keep the cells from changing in dimension. Anyone have the answer for me?

  2. #2
    Forum Expert Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,885

    Re: How to lock cell width and height for an entire worksheet

    Hi Vaughahue, welcome to the forum.

    You should be able to unlock any cells that you want users to be able to edit, but then protect the sheet so they can't change formatting.

    Select the cells they should be able to edit, right-click and choose Format Cells. On the Protection tab un-check 'Locked' and click OK. Protect the sheet and they can enter data/formulas but not change any formatting.

  3. #3
    Registered User
    Join Date
    03-11-2010
    Location
    Orange City, Iowa
    MS-Off Ver
    Excel 2004
    Posts
    4

    Re: How to lock cell width and height for an entire worksheet

    Worked like a big load of pure, unadulterated awesomeness. Thanks!

  4. #4
    Registered User
    Join Date
    05-31-2018
    Location
    Bangalore
    MS-Off Ver
    2016
    Posts
    1

    Re: How to lock cell width and height for an entire worksheet

    I want to know that how to lock particular cell area that means if I enter long sentence in C12 then the width of other cells i.e C11,C10,C9 & so on, will not be change.
    Every cell will not disturb by another cell value.

  5. #5
    Forum Expert dominicb's Avatar
    Join Date
    01-25-2005
    Location
    Lancashire, England
    MS-Off Ver
    MS Office 2000, 2003, 2007 & 2016 365
    Posts
    4,867

    Re: How to lock cell width and height for an entire worksheet

    Good afternoon getsanskarsing

    Welcome to the forum.

    Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

    If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

    Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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