Permission & Access Issues

Fix Apple Pencil Cannot Edit Protected Excel Worksheets

Elise WilliamsElise Williams Oct 15, 2026 871 views

Question details

Users are unable to edit protected Excel worksheets using an Apple Pencil, even though standard keyboard input continues to work normally.

How to Fix Apple Pencil Cannot Edit Protected Excel Worksheets
Product
Microsoft Excel
Device & OS
iPadOS
Scenario
Attempting to write or enter data into specific unlocked cells on a protected worksheet using an Apple Pencil on an iPad.
Observed behavior
The Apple Pencil does not respond or fails to enter data on the protected sheet, while the on-screen or physical keyboard functions without issue.
Before you start

Ensure that the specific cells you intend to edit with the Apple Pencil are formatted as 'Unlocked' before the worksheet protection is applied.

Solution 1Recommended

Enable 'Edit Objects' During Manual Protection

Adjust the worksheet protection settings manually to allow objects, including Apple Pencil inputs, to interact with the spreadsheet.

When Excel protects a sheet, it often locks object interactions by default. Because Apple Pencil input can be treated as an object interaction (such as inking), you need to explicitly allow this permission.

1
Select and unlock target cells

Highlight the cells you want to edit. Right-click (or tap and hold), select 'Format Cells', navigate to the 'Protection' tab, and uncheck the 'Locked' box.

2
Open protection settings

Navigate to the 'Review' tab on the Excel ribbon and select 'Protect Sheet'.

3
Allow object editing

In the protection dialog box under 'Allow all users of this worksheet to:', scroll down the list and check the box next to 'Edit objects'.

4
Apply and test

Enter a password if required and click 'OK'. Test the unprotected cells with your Apple Pencil to confirm it now registers input.

Enable 'Edit Objects' During Manual Protection
Validation Step: If configured correctly, both your keyboard and Apple Pencil will be able to edit the designated unlocked cells without triggering a protection error.
Seamless iPad Spreadsheet Editing

Edit Spreadsheets Effortlessly on iPad with WPS Office

WPS Office provides a highly compatible and mobile-friendly spreadsheet experience for iPad users, fully supporting stylus input and robust worksheet protection features without the hassle.

  1. 1. Install WPS Office: Download and install WPS Office for free from the App Store on your iPad.
  2. 2. Open your Excel file: Launch the app and open your existing .xlsx workbook directly.
  3. 3. Manage protection settings: Navigate to the 'Review' tab in the tools menu to easily unprotect or adjust sheet protection settings.
  4. 4. Edit with Apple Pencil: Use your Apple Pencil naturally to write, select, and enter data into unlocked cells without interaction errors.
Fully compatible with Microsoft Excel (.xlsx) formats and protection rulesSeamlessly integrates with Apple Pencil for smooth handwriting and cell selectionLightweight application with an intuitive, mobile-first interfaceEasily manage cell locking and worksheet protection on the go
microsoft office alternative - wps office

Frequently Asked Questions

Why does my Apple Pencil work on some Excel sheets but not others?

This usually occurs because certain worksheets have protection enabled with strict settings. If the 'Edit objects' permission is disabled during sheet protection, touch-based inking or Apple Pencil inputs are blocked, even if keyboard input is allowed.

How do I unlock specific cells for editing before protecting a sheet?

Select the target cells, right-click and choose 'Format Cells'. Under the 'Protection' tab, uncheck the 'Locked' box. Once done, you can protect the worksheet, and those specific cells will remain editable.

Can I change VBA protection settings directly on my iPad?

No, iPadOS versions of spreadsheet applications do not support modifying VBA macros. You will need to open the workbook on a desktop or Mac version of Excel, adjust the 'DrawingObjects:=False' parameter in the VBA editor, and then save the file back to your iPad.