Protect Worksheet to share with older versions of excel

[VIPone]

Can you protect a sheet and workbook so that rows, columns and formulas
cannot be changed, but others can add data (filling cells with data), but
still have users with an older version of Excel be able to access them?

 

[trip_to_tokyo]

Yes, you can protect individual cells within a Worksheet whilst leaving other
cells within the same Worksheet open for amendment.

If my comments have helped please hit Yes.

Thanks.

 

[Eduardo]

Hi,
Highlight the cells you want to let users enter information, right click on
the mouse,
format cells, Protection, uncheck Locked, then protect the worksheet

if this helps please click yes thanks