By default, if you filter using the Excel slicers, then you may find that the slicers move around when you filter. If you’d like to make sure that the slicers stay in one location, then here is the settings to allow you to do just that. Why is it important to ‘lock’ the Excel slicers into place?
In order to maximise consistency, it is useful to ‘lock’ the Excel slicers into place so that there is no additional step of separation between the user and the activity that they would like to undertake.
2. A dialog box will appear, called ‘Size and Properties’.
3. Click on ‘Properties’ on the left hand side.
4. Under ‘Properties’, choose the setting ‘Don’t move or size with cells’. This can be seen in the image below:
5. Click ‘Close’.
That’s it! The Excel slicers will be anchored to the location that you use to set them. This will help the user, who could be frustrated by the additional step of separation between themselves and the filtering activity that they would like to undertake.
To summarise, Excel slicers are a great idea for users, and their flexibility can be maximised in order to ensure that good design principles are maintained for users.