May 15, 2018 How to Create Named Ranges in Excel on PC or Mac. This wikiHow teaches you how to name a range of cells in Microsoft Excel for Windows or macOS. Open Excel on your PC or Mac. It's in the Start menu on a PC (usually in the All Apps folder). Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project. Open and create multiple documents in new tabs of the same window, rather than in new windows. Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!
Hi everyone,
I want to allow users to edit some ranges after protecting and sharing the work book. In the sample file which i have attached whatever the cell highlighted background with light violet color should be allowed for the users to edit and only some specific people in my work group.
In this file i have just given 2 ranges (Bay 1 & 2) where as in my original file i have around 11 ranges (Bay 1 to 11) each with 50 rows.
The pre defined option for this feature is having some limitation which i couldnt utilize it in this sheet.
Someone please help me..
![Mac Mac](https://www.e-iceblue.com/images/art_images/Allow-users-to-Edit-ranges.png)
- Allow Users to Edit Ranges.xlsm (48.3 KB, 11 views)
In this article, we will learn how to share and allow users to edit changes in Microsoft Excel 2010.
Microsoft Excel allows multiple users to modify the data in a worksheet simultaneously. You can create a shared workbook & place it on a shared location where many people can make the changes of the contents of the file at the same time. If an employee is working on multiple projects, and needs to update the status of the task as it finishes so that the information will be passed to the group members who are working along with. It will minimize any chance of two people doing the same task. All persons involved can enter the information for their projects in the same workbook.
The owner of a shared workbook can manage it by removing users from the shared workbook and resolving any conflicting changes. After doing all the changes, you can stop sharing the workbook.
Share a Workbook
1) Create a new workbook or open an existing workbook that you want to share to multiple users to modify any changes.
There are some limitations in a shared workbook & all the features are supported.
The following features are not working in a shared workbook:
- Conditional Formatting
- Data Validation
- Create or change Charts
- Pictures
- Merged cells
- Hyperlinks
- Objects including drawing objects
- Scenarios
- Outlines
- Pivot Table Report
- Subtotals
- Data Tables
- Workbook and Worksheet Protection
- Macros.
You cannot make changes to these features after sharing the workbook.
If you want to include any of the above listed features, then you should add them before you save the workbook as a shared workbook.
Steps to Share Workbook
- Click on Review ribbon
- In the Changes group, click on Share Workbook
If you see this information then
- You need to Click on File ribbon
- Select Trust Center
- Click on Trust Center Settings
- Uncheck the “Remove personal information from file properties on save”.
- Click on OK
- You will be able to share workbook
- Check the box “Allow changes by more than one user at a time. This also allows workbook merging”.
- Click on Advanced tab & select the options that you want to use for tracking & updating changes.
![Allow Users To Edit Ranges In Excel For Mac Allow Users To Edit Ranges In Excel For Mac](https://support.content.office.net/en-us/media/a78fd1e9-0d9c-41cf-9170-cbe8136bcfff.png)
- Click on OK
- You will see the dialog box appearing & asking: Do you want to continue sharing the workbook?
- Click on OK.
- After that, you will notice that the file has been shared