+ Reply to Thread
Results 1 to 3 of 3

Can I lock the size of the cell?So the cells can be edited but sheet stays the same size

  1. #1
    Registered User
    Join Date
    03-03-2016
    Location
    London
    MS-Off Ver
    2010
    Posts
    2

    Can I lock the size of the cell?So the cells can be edited but sheet stays the same size

    Creating a sheet that needs to be completed weekly by employees. I want them to be able to edit data within the sheet but not to alter the size of the rows and columns.It is perfectly formatted to fit on one side of A4 I don't want this to change.??

  2. #2
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Can I lock the size of the cell?So the cells can be edited but sheet stays the same si

    You can "lock" the size of the cells on the worksheet by using the Protect Worksheet on the Review tab.

    Select the cells that you want the employees to have access to for entry of data, right click, choose Format Cells. Click on the Protection tab and deselect the LOCKED box and click OK.

    Size all cells to the size and format that you want. Go to the Review tab, click on Protect Worksheet, Select Protect Worksheet and Locked Cells, enter a password and select what you want the employees to have access to. In this case only UNLOCKED cells is the likely choice. Click OK. The worksheet should be protected to prevent the changing of format or cell sizes.

    This workbook has a blank password so you can unprotect the worksheet just by going to the Review tab, click on Unprotect Worksheet and click OK. I have formatted cell width, cell height, colour, and formatted the available cells as currency. You can see that only the grey area is available to be edited.
    Attached Files Attached Files
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

  3. #3
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    14,224

    Re: Can I lock the size of the cell?So the cells can be edited but sheet stays the same si

    newdoverman's solution will prevent users from changing the column width manually. However, I note that the column width can still change due to Excel's (accursed) "auto column width" feature/bug. In newdoverman's spreadsheet, if I enter a 10 digit number (1234567890), then Excel will automatically widen the column to accommodate the large number. Of course, the programmer needs to set the column width wide enough to account for any number that might be entered. This might apply if the user inadvertently enters and invalid number or something. If needed, it might be valuable to include some kind of "data validation" to make sure that the user does not inadvertently enter a number that will cause the auto column width feature to kick in. I don't know if that will apply to the OP's scenario, but it might be worth considering.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Change font size keeping the cell size fixed
    By mayurpatil in forum Excel General
    Replies: 1
    Last Post: 07-09-2015, 01:52 PM
  2. computer says same size cells are not the same size
    By rgrstvr in forum Excel General
    Replies: 3
    Last Post: 11-23-2014, 02:55 PM
  3. Lock range of cells until a single cell is edited
    By pritesh118 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 09-10-2014, 12:11 PM
  4. Replies: 6
    Last Post: 01-20-2013, 09:52 AM
  5. Size a cell depending on a TextBox size.
    By Wizz in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-04-2007, 04:50 PM
  6. Auto Size Phot to Cell Size
    By Corey in forum Excel General
    Replies: 1
    Last Post: 05-30-2006, 04:55 AM
  7. [SOLVED] Cell size? Or size limit for Text data type?
    By CClem in forum Excel General
    Replies: 0
    Last Post: 04-21-2006, 11:15 AM

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