M mahan8 Jul 29, 2008 #1 I am tring to lock only one cell in excel 2007 not the whole workbook. Can any one help?
R Ron de Bruin Jul 29, 2008 #2 Hi mahan8 For every sheet in the workbook do this Click on the space above the first row header and on the left of the first column header. All cells on the sheet are selected now Ctrl 1 to open the format cells dialog on the protection tab uncheck locked After you do this select the cell you want to lock Ctrl 1 to open the format cells dialog on the protection tab check locked Now protect every worksheet
Hi mahan8 For every sheet in the workbook do this Click on the space above the first row header and on the left of the first column header. All cells on the sheet are selected now Ctrl 1 to open the format cells dialog on the protection tab uncheck locked After you do this select the cell you want to lock Ctrl 1 to open the format cells dialog on the protection tab check locked Now protect every worksheet
M mahan8 Jul 29, 2008 #3 Thank you it worked like a charm. Ron de Bruin said: Hi mahan8 For every sheet in the workbook do this Click on the space above the first row header and on the left of the first column header. All cells on the sheet are selected now Ctrl 1 to open the format cells dialog on the protection tab uncheck locked After you do this select the cell you want to lock Ctrl 1 to open the format cells dialog on the protection tab check locked Now protect every worksheet Click to expand...
Thank you it worked like a charm. Ron de Bruin said: Hi mahan8 For every sheet in the workbook do this Click on the space above the first row header and on the left of the first column header. All cells on the sheet are selected now Ctrl 1 to open the format cells dialog on the protection tab uncheck locked After you do this select the cell you want to lock Ctrl 1 to open the format cells dialog on the protection tab check locked Now protect every worksheet Click to expand...
