How do I lock a sheet in Excel 2007?

Answer Without using VBA, all you can do is hide the sheet and protect the whole workbook. This is different from protecting just a sheet, since there is almost no indication that the sheet is there. Only... Read More »

Top Q&A For: How do I lock a sheet in Excel 2007

Excel 2007: How to Import Data From One Excel Sheet to Another?

In computing terms, a "spreadsheet" is a type of large table that is used to display information. Microsoft Excel 2007 is just one of the many programs that is capable of creating and working with ... Read More »

How can I lock a sheet in Excel?

Since you did not specify a version, I will assume it to be MS-Excel 2003 or earlier.There are various ways to do this, but we will assume that you are wanting just the basic method: • From th... Read More »

How do i add lines on an excel 2007 sheet?

Click on the "Insert" tab. Go to the "Illustrations" panel. Click on the down arrow beside "Shapes." Click on the diagonal line under the "Lines" row. The cursor will become a cross. Click and drag... Read More »

How to Lock Excel 2007 Cells?

According to the University of Wisconsin-Eau Claire's LTS Online Help Documentation website, locking the cells in your Excel 2007 document can protect them from accidental changes. The website also... Read More »