Hide Excel columns or sheets based on user in a OneDrive shared workbook

Hi Irgi,

Thanks for your query in our forum. Per your description, you want to hide or restrict some content of workbook to some specific users.

Due to the design features of Excel, you can protect some sheet, range in a workbook, but this is for all users and not for some users. When user want to access these parts, they all need to input password you set when you protect these areas.

For more information, please refer to:

Protect a worksheet   Lock or unlock specific areas of a protected worksheet

Another way may better suit your situation. The SharePoint online is a best place to share files with users in your organization.

You can save these sheets as a new workbook B which you don’t want to be accessed by guest. Other sheets are saved in workbook A. And save these workbooks in SharePoint site library. You can set the access permission to workbook B so that guest can’t access this workbook, but other users can access it.  As you already shared this workbook in OneDrive, save them in SharePoint library is a better choice for this scenario.

As guest B can access this library, you can stop inheriting permission of workbook B and share it to site members. Then the guest can’t access this workbook.

For your reference, please refer these articles:

Introduction to SharePoint Online     Customize permissions for a SharePoint list or library

If you only want to hide some contents to a specific user in Excel, we suggest you share this idea in Excel UserVoice, it’s a best place to collect user’s idea. The related teams will adapt high votes idea and improve our product. Your idea may convenient more users.

Please don't mind my long description. Appreciated for your patience. 

Best Regards,

Ivy