Permission & Access Issues

How to Format and Protect an Excel Table Shared on OneDrive

Nimra Malik Oct 12, 2026 870 views

Question details

The user needs to configure specific formatting and editing protections for an Excel table shared through OneDrive.

How to Format and Protect an Excel Table Shared on OneDrive

Product: Microsoft Excel / OneDrive
Device & OS: not provided
Scenario: Sharing a formatted and protected Excel workbook online for controlled user data entry.
Observed behavior: Seeking the correct configuration for date formats, conditional formatting, dropdowns, and restricting edits without losing format integrity on Excel for the Web.

Before you start

Before applying protections, ensure your workbook is fully formatted and saved to your local OneDrive folder so changes sync correctly.

Solution 1Recommended

Configure Protection and Formatting for OneDrive Sharing

Set up your workbook layout locally before uploading, as Excel for the Web has specific limitations regarding protection and views.

When sharing an Excel file via OneDrive, it is best to apply structural protection, dropdowns, and conditional formatting in the desktop version of Excel before sharing.

Note that Excel for the Web does not enforce custom browser views (like a fixed 90% zoom limit). If strict layout enforcement is required, an HTML-based solution might be better suited for your needs.

Format your data

Apply your desired regional settings (such as Australian date formats), cell borders, wrapped text, and alignment to the cells within the desktop application.

Set up Dropdowns and Conditional Formatting

Navigate to the 'Data' tab and select 'Data Validation' to create dropdown lists. Use 'Conditional Formatting' under the Home tab to automatically highlight specific entries.

Unlock input cells and Protect Sheet

Select the cells you want users to edit, right-click, choose 'Format Cells', go to the 'Protection' tab, and uncheck 'Locked'. Then, go to the 'Review' tab, select 'Protect Sheet', and ensure you check the boxes that allow users to select unlocked cells.

Upload to OneDrive

Save the configured file to your local OneDrive folder and share the link, ensuring you grant 'Can Edit' permissions to the required users.

Configure Protection and Formatting for OneDrive Sharing

Community Support: For highly specific or advanced script requirements, consider posting your exact layout needs in the Microsoft Excel Community or Microsoft Q&A.

Format and Protect Spreadsheets Easily

Format, Protect, and Share Spreadsheets with WPS Office

WPS Spreadsheet provides robust tools for formatting cells, creating dropdowns, and locking structural elements. You can easily protect your tables and share them securely for collaborative work.

1. Open your Spreadsheet: Launch WPS Spreadsheet and create your table with the desired borders, alignment, and formatting rules.
2. Apply Data Validation: Navigate to the 'Data' tab on the top ribbon and select 'Validation' to add dropdown lists or custom entry rules.
3. Lock Specific Cells: Select the cells you want to keep editable, right-click, choose 'Format Cells', go to the 'Protection' tab, and uncheck the 'Locked' box.
4. Protect the Sheet: Go to the 'Review' tab and click 'Protect Sheet'. Set a password to prevent unauthorized formatting changes from external collaborators.

Fully compatible with Microsoft Excel (.xlsx) formats.Advanced cell formatting and data validation tools.Secure sheet protection with granular permission settings.Free and lightweight alternative for seamless document management.

Frequently Asked Questions

Can I force a specific zoom level when sharing an Excel file via OneDrive?

No, Excel for the Web does not enforce a default browser zoom (such as 90%). The view depends on the individual user's browser settings. If strict layout control is necessary, consider using an HTML web page instead.

Will my conditional formatting work when users open the shared link?

Yes, most standard conditional formatting rules applied in the desktop application will function correctly when users view and edit the workbook online via OneDrive.

How do I ensure users can only edit specific cells in a shared table?

Before protecting the sheet, you must unlock the specific cells intended for user input by going to Format Cells > Protection and unchecking 'Locked'. Then, go to the Review tab, select Protect Sheet, and share the file.

Document & File Issues