how can this be done?

S

sam

I have an excel sheet that I update and want others to view it only(view
permissions only).

My Question is:

Can myself and other person edit the sheet at the same time?

Can I assign certain certain rows, columns only that someone can
edit(insert, update data)?

Can I make certain fields(columns/rows) mandatory while editing.
For eg, If I have a sheet with columns Name, City, St, Address, Zip
Can I make data in Zip column mandatory? (it has to be
populated)?

Thanks in Advance
 

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

Is this possible in excel? 2
can it be done in excel? 1
making some fields mandatory in access data table 2
Many sheets, one DB? 1
can this be done? 1
can it be done in access? 5
Macros to check whether all cells are filled 0
Unclear change tracking process 0

Top