0
No, you can not password protect only a part of a worksheet, you must protect the entire worksheet. However, you can format everything, except the section you want to protect, to unprotect. That way, when you turn the worksheet protection on you can set the protection status to allow access only to unprotected cells.
Wiki User
∙ 14y ago
Add your answer:
Earn +20 pts
What is a model in excel?
A spread sheet
How do you unlock the Excel sheet without password?
You can't. You need the password to unlock it.
What is the difference between Excel sheet and spread sheet?
They are the same thing, excel is Microsoft's spreadsheet programme.
How many coulms are there in Microsoft Excel?
the column in Ms excel are 16,384 and 1048,576 rows and 17,179,869 cell in one spread sheet. The spread sheet ends with the letter XFD.
Does micro soft excel deal with spread sheet?
yes > >
How is PowerPoint different from Excel?
Excel is a spread sheet programme, PowerPoint is more of a movie programme.
What format does us bank statement display in?
excel spread sheet
What is Microsoft excel windows?
it is a spread sheet application arranged in rows and columns
What removes cells rows and columns from a spread sheet in Excel?
The Delete command.
How do you insert a photo in Excel when the sheet is protected?
You do not enter anything into a worksheet that is protected, unless the protection settings allow you to do so. You need to unprotect the sheet, insert the photo, then protect the sheet again. If the protection is locked with a password, then you need to contact the spreadsheet author to get the password. There are many ways to remove the password from an Excel workbook, but I will not discuss that topic here.
Other than on the Microsoft site where can one find Excel templates?
Skabelon Design, Free Spread Sheet, Spread Sheet Store and Crystal Graphics all offer Excel templates that work with windows. Free Excel Templates also offers them in a wide selection of categories.
How do you recover the lost password in a protected Excel work sheet?
Suppose you have to view an important excel sheet data but you have forget the password then you need to do excel password recovery, unfortunately MS excel doesn't offer any option for password recovery. You can try the following steps but it will work in MS excel 2007 only. 1) Change file extension .zip from .xls/xlsx. 2) Extract this zipped file. 3) Go to the extracted files and navigate to the .xml for the target sheet (found in the 'xl\worksheets' directory) like filename.xml 4) Open this .xml file in to xml editor and file and find <sheetProtection password="CC58" sheet="1"/> line and remove it. 5) Now save this file and change extension back to .xlsx from .zip. You will be able to open your file successfully without any password.
