how to block cells?

  • Thread starter Thread starter cgal
  • Start date Start date
C

cgal

hi
i am trying to block cells. i'm writing a form and i want the empty
cells to blocked (in order that u can fill in only the cells you need
and you cant even click on the empty cells)
does anyone knows how to do that?

thanks
 
You can lock all cells except those you want available
for input. (format;cells; protection). Then protect the
sheet. In XP, you can allow the user to only select
unlocked cells. I don't know if that feature is
available in 2000; I don't think it was available in 97.
 
Select the cell you want to block, go to format cell,
protection tab and select locked, as you can see this
protection has no effect unless the worksheet is
protected. choose protection from the tools menu, and
then choose protect sheet
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Change relative to absolute references in a block of cells 3
Sharing workbooks limitations - Merged Cells 12
fill any random cell in a column and block all other cells 5
Entering a cell with Criterias 5
How can I fill a block of 300 cells with non-repeating random #s 2
Behavior of text in cells..... 1
Excel validation input message not anchored to the cell 1

Back
Top