How to Make a Slider with Percentages in Excel - Tutorial
To make a slider with percentages in Excel, you need to do a little extra formatting. This is because the slider (i.e., Scroll Bar) Form Control inputs only accept whole numbers.
In this tutorial, you'll see, step by step, how to create a Scroll Bar slider with percentages in Excel.
You'll then see how you can edit your slider to also display negative percentages.
Video Time Stamps:
00:16 Enable the Developer tab
00:35 Insert a Slider / Scroll Bar
01:16 Scroll Bar Form Control Fields
02:08 Create Reference To and Format Linked Cell to Display Percentage
03:11 Update Scroll Bar Form Fields to Also Show Negative Percentages
Click here to read our step-by-step article on this: https://yacostasolutions.com/slider-w...
If you liked this, make sure to get your FREE pdf list of top Excel keyboard shortcuts: https://yacostasolutions.com/newsletter/
*FYI:
This tutorial was created using the desktop version of Excel in Microsoft 365. You can upgrade to this version here: https://yacostasolutions.com/MS365
The screen recording + editing was done using Techsmith Camtasia. You can check it out here: https://yacostasolutions.com/camtasia
Thanks for watching this Microsoft Excel tutorial and, don’t forget, if you like this video, please “Like” and “Share” with your friends – it really helps us out 😊
To catch our Excel tutorials as they come out, subscribe to this channel by clicking: https://yacostasolutions.com/youtube
Thanks!
*DISCLAIMER: This video description contains affiliate links, which means that if you click on one of the product links, I’ll receive a small commission. As an Amazon Associate I earn from qualifying purchases. This helps support the channel and allows us to continue to make tutorials like this. Thank you for your support!
#YAcostaTutorials
