+ Reply to Thread
Results 1 to 2 of 2

format cells

  1. #1
    Registered User
    Join Date
    02-15-2010
    Location
    Greece
    MS-Off Ver
    Excel 2007
    Posts
    31

    Arrow format cells

    Hello
    I need to format some cells in a worksheet in order to have them looked like a form.
    I need the cursor to go only in predefined cells where I have to write the desired values.
    In the worksheet I have in cell A1 a title and in A2 I need to right a value. In A3 I also have a title and in A4 I have to write a value, etc. Therefore I need a way to bypass cells A1, A3, etc. and when I press enter the cursor to go to A2, A4, etc.

    Thank you in advance for your help

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,596

    Re: format cells

    Select cells you want to use then right click -> format cells -> Protection

    And uncheck locked box.

    After that go to Rewiev tab - Protect sheed and uncheck Select locked cells.

    You can also put password to unprotect sheet.

+ 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