Тёмный

How to Make a Slider with Percentages in Excel - Tutorial 

Y. Acosta Excel Tutorials
Подписаться 25 тыс.
Просмотров 22 тыс.
50% 1

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: yacostasolutio...
If you liked this, make sure to get your FREE pdf list of top Excel keyboard shortcuts: yacostasolutio...
*FYI:
This tutorial was created using the desktop version of Excel in Microsoft 365. You can upgrade to this version here: yacostasolutio...
The screen recording + editing was done using Techsmith Camtasia. You can check it out here: yacostasolutio...
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: yacostasolutio...
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

Опубликовано:

 

5 окт 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 12   
@CorvoFG
@CorvoFG 3 года назад
I don’t know who you are but you’ve just saved me a massive headache and made me look great in front of my new boss! Here, you deserve these! 💐💐
@YAcostaSolutions
@YAcostaSolutions 3 года назад
That's the goal! I'm excited for you with your boss and thank you so much 🙂
@rickvenables7648
@rickvenables7648 3 года назад
This was super helpful. Thank you very much!
@YAcostaSolutions
@YAcostaSolutions 3 года назад
That’s great, Rick! I’m happy this helped you 🙂
@Sabir__
@Sabir__ 4 года назад
Nicely explained Useful function
@YAcostaSolutions
@YAcostaSolutions 4 года назад
Thank you so much. I'm happy this is helpful for you 🙂
@staticsyzygy
@staticsyzygy 3 года назад
Thank you
@YAcostaSolutions
@YAcostaSolutions 3 года назад
Thank you too! I'm glad you liked this 🙂
@lairdhepburn5795
@lairdhepburn5795 2 года назад
Formula error. Please check...=IF(Sheet2!A2>100,Sheet2!A2/100-1, -(1-Sheet2!A2/100))
@TammyPeters33
@TammyPeters33 2 года назад
I have all the steps but the Total cell doesn't update. Is there a formula in this cell?
@dianariroriz4284
@dianariroriz4284 3 года назад
I tried but dont work '=IF($D$4>=100;$D$4/100-1;-$D$4/100)
@zuhairalmutawa9941
@zuhairalmutawa9941 3 года назад
Thank you
Далее
Find The Real MrBeast, Win $10,000
00:37
Просмотров 22 млн
EASILY Make an Automated Data Entry Form in Excel
14:52
The Excel Dashboard Trick Almost Nobody Talks About
10:25
Option Buttons with Formulas in Excel
8:44
Просмотров 91 тыс.
Excel Scrollbar - Change from Integer to Decimal
5:20
Просмотров 4,8 тыс.
Most important tools in Excel -  Malayalam Tutorial
17:04
Dependent Drop Down List in Excel Tutorial
11:10
Просмотров 634 тыс.
Better Looking Excel Charts in 4 Simple Steps
9:08
Просмотров 4,1 тыс.
Find The Real MrBeast, Win $10,000
00:37
Просмотров 22 млн