Question about Microsoft Excel for PC
How to protract a single row or single colum in excel 2007
Posted by Anonymous on
1. First Select entire sheet -->Right click on any cell -->Cell formatting --> Protection -->Uncheck Lock
2. Now Select the desired row -->Right click -->cell formatting -->Protection -->Check Lock cell
3. Click review tab -->Select Protect Sheet --> Give Password twice
Posted on Sep 16, 2017
Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
Here's a link to this great service
Posted on Jan 02, 2017
Start by selecting the entire sheet, right clicking, going to "Format Cells", "Protection" and clearing the "locked" checkbox.
Then select the rows or cells you want to protect and turn "locked" on for them.
Finally, go to Tools->Protection->Protect sheet and enable protection - setting a password might be a good idea.
Posted on Jul 04, 2009
SOURCE: MS EXCEL
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.
Posted on Apr 21, 2010
Tips for a great answer:
Jun 30, 2014 | Computers & Internet
on Nov 23, 2010 | Computers & Internet
Aug 14, 2013 | Microsoft Office Computers & Internet
Jun 22, 2011 | Microsoft Office Excel 2007 Full Version...
Feb 22, 2010 | Microsoft Excel for PC
Jul 04, 2009 | Microsoft Excel for PC
Nov 19, 2008 | Microsoft Computers & Internet
Nov 14, 2007 | Computers & Internet
Jan 28, 2016 | Microsoft Excel for PC
Dec 12, 2013 | Microsoft Excel for PC
158 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: