If you have locked the file yourself, it might be because the file is open on a different device, or the previous instance of the file didn’t close properly. Tip: Sometimes a file may get locked if everyone editing isn’t using a version that supports co-authoring.
How do you unlock the locked Excel?
Just do any of the following:
- Right-click the sheet tab, and select Unprotect Sheet… from the context menu.
- On the Review tab, in the Changes group, click Unprotect Sheet.
- On the Home tab, in the Cells group, click Format, and select Unprotect Sheet from the drop-down menu.
How do you remove lock in Excel?
On the Review tab, click Protect Sheet or Protect Workbook. Click Unprotect Sheet or Protect Workbook and enter the password. Clicking Unprotect Sheet automatically removes the password from the sheet. To add a new password, click Protect Sheet or Protect Workbook, type and confirm the new password, and then click OK.
Why is my Excel spreadsheet locked up?
The file might be locked because: The file is shared and another user is currently editing it. An instance of the Office app is running in the background with the file already opened. The file has been marked as Final and can no longer be updated.
How do I hide formulas in Excel?
Prevent a formula from displaying in the formula bar
- Select the range of cells whose formulas you want to hide. …
- Click Home > Format > Format Cells.
- On the Protection tab, select the Hidden check box.
- Click OK.
- Click Review > Protect Sheet.
How do you unlock cells in Google Sheets?
(Optional) To unprotect cells in a protected sheet:
- Check the Except certain cells box.
- Click Select data range. .
- In the spreadsheet, highlight the range you want to unprotect and click Ok.
Why can’t I edit my Excel spreadsheet?
Enable or disable Edit mode
Click File > Options > Advanced. , click Excel Options, and then click the Advanced category. Under Editing options, do one of the following: To enable Edit mode, select the Allow editing directly in cells check box.
How to clear Excel cache?
Steps to Clear the Cache in Excel
- First, go to the file tab and open the Excel options.
- From there, go to the save option and scroll to the end of the dialog box.
- Now from the Cache Settings, click on the “Delete cached files”.
- After that, you get a dialog box to confirm if you want to clear the cached files.
How do I remove a file that is locked for editing?
Inactivate an add-in that’s causing the lock. Select File > Options > Add-Ins > Excel Add-ins > Go and then clear the check box for the add-in.
…
- If possible, remove password encryption from the file. …
- If possible, remove restricted access.
How do I lock cells in Excel?
Lock cells to protect them
- Select the cells you want to lock.
- On the Home tab, in the Alignment group, click the small arrow to open the Format Cells popup window.
- On the Protection tab, select the Locked check box, and then click OK to close the popup.
How do I lock a sheet in Excel?
Protect a sheet
- Select Review > Manage Protection.
- To turn on protection, in the Manage Protection task pane, select Protect sheet. …
- By default, the entire sheet is locked and protected. …
- Optionally, to require a password to edit a range, select Range password, enter and confirm the password, and then select Save.
How do I protect a cell in Excel?
Lock cells to protect them
- Select the cells you want to lock.
- On the Home tab, in the Alignment group, click the small arrow to open the Format Cells popup window.
- On the Protection tab, select the Locked check box, and then click OK to close the popup.
How do I permanently unlock an Excel spreadsheet?
On the Review tab, click Protect Sheet or Protect Workbook. Click Unprotect Sheet or Protect Workbook and enter the password. Clicking Unprotect Sheet automatically removes the password from the sheet. To add a new password, click Protect Sheet or Protect Workbook, type and confirm the new password, and then click OK.
How do I change the value of a formula in Excel?
To copy the actual value instead of the formula from the cell to another worksheet or workbook, you can convert the formula in its cell to its value by doing the following: Press F2 to edit the cell. Press F9, and then press ENTER.
Why can’t I open Excel files from Outlook?
Try the following suggestions: Check the file permissions for the document or drive. Make sure there is sufficient free memory and disk space. Open the file with the Text Recovery converter.
Can I delete Microsoft cache?
To fix this problem, try manually deleting your Microsoft Office Document Cache. Deleting the cache isn’t dangerous, and it might clear up the syncing problem. After you delete the cache, sync may happen automatically, or you may need to sync manually.
Why can’t I edit a Word document?
Follow these steps to edit: Go to File > Info. Select Protect document. Select Enable Editing.
How do I wrap text in Excel?
Wrap text in a cell
- In a worksheet, select the cells that you want to format.
- On the Home tab, in the Alignment group, click Wrap Text. (On Excel for desktop, you can also select the cell, and then press Alt + H + W.) Notes:
How do I lock an image in an Excel cell?
Please right-click the image and choose Size and Properties, then make sure that the Locked checkbox is checked.
How do I unlock an Excel file?
You can also press Ctrl+Shift+F or Ctrl+1. In the Format Cells popup, in the Protection tab, uncheck the Locked box and then click OK. This unlocks all the cells on the worksheet when you protect the worksheet.
How do I lock filters in Excel?
Click the Filter menu. Click Lock. A lock icon appears to indicate that the filter is locked. To unlock the filter, click on the menu, and select Unlock.
How do I protect cells in Excel?
Lock cells to protect them
- Select the cells you want to lock.
- On the Home tab, in the Alignment group, click the small arrow to open the Format Cells popup window.
- On the Protection tab, select the Locked check box, and then click OK to close the popup.
How do I Encrypt an Excel File?
Protect an Excel file
- Select File > Info.
- Select the Protect Workbook box and choose Encrypt with Password.
- Enter a password in the Password box, and then select OK.
- Confirm the password in the Reenter Password box, and then select OK.
How do I split text in Excel?
Try it!
- Select the cell or column that contains the text you want to split.
- Select Data > Text to Columns.
- In the Convert Text to Columns Wizard, select Delimited > Next.
- Select the Delimiters for your data. …
- Select Next.
- Select the Destination in your worksheet which is where you want the split data to appear.
How do I convert a text to number in Excel?
Use Paste Special and Multiply
Select the cells that have numbers stored as text. On the Home tab, click Paste > Paste Special. Click Multiply, and then click OK. Excel multiplies each cell by 1, and in doing so, converts the text to numbers.
Why can’t I paste data in Excel?
Cause: The Copy area and the Paste area are not the same size and shape. Solution: Select the upper-left cell instead of the whole range before you paste. Click the cell where you want the upper-left cell of the copied data to appear.
Excel PERSONAL XLSB is locked for editing
FAQs
How to unlock an Excel file that is locked for editing by another user? ›
Windows: If possible, remove password encryption or restricted access from the file. Go to File > Info > Protect Workbook and remove any passwords or restricted access settings.
How do I unlock XLSX? ›- Right-click the sheet tab, and select Unprotect Sheet… from the context menu.
- On the Review tab, in the Changes group, click Unprotect Sheet.
- On the Home tab, in the Cells group, click Format, and select Unprotect Sheet from the drop-down menu.
The file might be locked because: The file is shared and another user is currently editing it. An instance of the Office app is running in the background with the file already opened. The file has been marked as Final and can no longer be updated.
How do you unlock a locked Excel file? ›- On the Review tab, click Unprotect Sheet (in the Changes group). Click the Protect Sheet button to Unprotect Sheet when a worksheet is protected.
- If prompted, enter the password to unprotect the worksheet.
If you have received the message “The document is locked for editing by another user” when attempting to edit an Excel file, it could be due to one of the following reasons: The Excel file is password-protected. Microsoft Excel didn't close properly, and the owner file wasn't erased.
How do I fix a file is locked for editing by another user? ›- Quit all instances of Word. To do so, follow these steps: ...
- Start Windows Explorer, and then browse to the folder that contains the document file that you tried to open when you received the error message.
- Delete the owner file. ...
- Start Word. ...
- Open your document.
Open the workbook that you want to change or remove the password for. On the Review tab, click Protect Sheet or Protect Workbook. Click Unprotect Sheet or Protect Workbook and enter the password. Clicking Unprotect Sheet automatically removes the password from the sheet.
Why can't I edit my Excel spreadsheet? ›If a worksheet or presentation is locked for editing and can't be edited in the Windows desktop application, it may be that the file is already being edited by someone else, or they have the file checked out.
How do I unlock a file for editing? ›- Way 1: Save Read Only Word Document with Modify Password as another File.
- Way 2: Open the Locked Word Document with WordPad and Save the Changes.
- Way 3: One Click to Safely Remove Word Document Editing Password.
If F14 exists on your keyboard, but there is no Fn key, use the Shift + F14 shortcut to toggle the Scroll Lock on or off. Depending on your settings, you may need to press the CONTROL or OPTION or COMMAND (⌘) key instead of the SHIFT key.
Why is my Excel file XLSX? ›
In Microsoft Excel, workbooks are saved as Excel Workbooks (. xlsx) by default. You can change the default file format to any other file format that is supported in Excel. For example, if you frequently create macros in a workbook, you may want to automatically save a new workbook as an Excel Macro-Enabled Workbook (.
How do I enable an XLSX file in Excel? ›Use your mouse to right-click on the XLSX file and select the “Open with” option. A window will open recommending programs that could open the file. From there, click on Excel and the software will open the file. If you do not see Excel on the list, you probably have not installed it.
How do I fix an XLSX file? ›- Click File > Open.
- Click the location and folder that contains the corrupted workbook.
- In the Open dialog box, select the corrupted workbook.
- Click the arrow next to the Open button, and then click Open and Repair.
- To recover as much of the workbook data as possible, pick Repair.
Select File > Info. Select Protect Workbook, point to Restrict Permission by People, and then select Restricted Access. In the Permissions dialog box, select Restrict permission to this workbook, and then assign the access levels that you want for each user.
How do I enable editing on a locked document? ›On the Review tab, in the Protect group, click Restrict Editing. In the Editing restrictions area, select the Allow only this type of editing in the document check box. In the list of editing restrictions, click No changes (Read only). Select the part of the document where you want to allow changes.
How do I unlock my editor lock? ›Edit Lock facility is given in the PROGRAM ATTRIBUTES. The EDITOR LOCK is a check box given in the PROGRAM ATTRIBUTES. If this field is SET then the program gets locked and if this is Unchecked the the program is unlocked.
Why is my Microsoft Word locked and won't let me type? ›Simply select “Step Protection” button to unlock protected part of the document. In case the Word document is marked as final and you can't edit it. You just need to click the “Edit Anyway” button that highlight in the head of the page.
Can you kick someone out of Excel spreadsheet? ›For Teams, there is no feature that can kick a user out of a SharePoint excel document. I would suggest to submit feedback to the support engineer team so that they can add this in the future releases.
How do I force someone out of a shared Excel file? ›- On the Review tab, in the Changes group, click the Share Workbook button.
- On the Editing tab, select the name of the user you want to disconnect, and click the Remove User button.
- Go to File > Options.
- Select Trust Center > Trust Center Settings > Protected View.
- Clear the box for Enable Protected View for files originating from the internet.
How do I remove restricted access in Excel? ›
Go to the “Share” button in the upper-right side of Excel, or click on the “File” tab on the top menu and proceed to “Share” on the left sidebar. Find the user whose shared access you want to remove on the right pane. Right-click on the user and select “Remove User” from the drop-down menu.