How to add a bullet point in Excel "•"
In this video I will show you how to add bullet points to yout lists in Microsoft Excel.
For a faster learning experience please put this video on 1.5X. ✌️
This tutorial shows five ways that we could use to insert a bullet point in Excel.
These are by using the shortcut ALT+7, by inserting a symbol using the Symbol button, by copy/pasting it from somewhere else, by using the =CHAR(149) function that returns our bulletpoint and concatenating it our list items or by appling the custom format from below to our whole list.
This tutorial also shows:
how to use the CHAR function
how to apply a custom format
how to insert a symbol in Microsoft Excel
👉 THE CUSTOM FORMAT
● General;● General;● General;● General
👉 DETAILS ABOUT THE CHAR FUNCTION
https://excelx.com/formula/list
🔴 RECOMMENDED VIDEOS/PLAYLISTS
🎥 Financial functions: • 💰 Compound interest calculator templa...
🎥 Common errors: • 🚨 How to solve the #DIV/0! error in E...
🎥 How to tutorials: • How to use UPPER in Excel
🎥 Regular functions explained: • BASIC EXCEL FUNCTIONS
★ TABLE OF CONTENTS ★
• 00:00 Intro
• 00:27 Exploring our options
• 01:53 ALT + 7
• 02:25 Insert a symbol
• 03:08 Copy and pasting your symbol
• 03:25 Using the CHAR function
• 04:22 Applying a custom format
• 05:15 Begging for a like 🥺
🔴 ** BE MY FRIEND **
✅ Facebook Group: / 908205936677735
✅ Facebook Page: / excel-cog-tutorials-100301111901420
🔴 ** ABOUT THE CHANNEL **
I use Excel for many things in my day to day life, such as bugeting, expense and income tracking, portfolio management, bodyweight tracking and lots and lots of planning and I want you to get as much from this tool as I do.😍
Unfortunately, I don't use Excel in my daily work anymore and I don't want my skills to fade away because I spent many many years aquiring them. 🦸♂️
And what better way to maintain or improve a skill if not by teaching others? 🤔
With that said, my goal for this channel is to help you get as much value from Excel as possible.
💡 TOPICS IN THIS VIDEO 💡
• microsoft excel tutorials beginners
🔎 HASHTAGS 🔎
#microsoftexcel #exceltutorialsbeginners #excelbeginners
🔎 VIDEO OUTLINE 🔎
You created a to-do list or a list of goals that you want to achieve for today and then you notice that your list would look a lot better if it had some bullet points to it, but unfortunately there's no easy way to do that in Excel like in Word or other Microsoft tool so for that I’m going to show you five ways that you could use to insert a bullet point into your lists in Microsoft Excel.
The first three options are a variant of each other, the first one is using ALT + 7, this is a shortcut that will insert a bullet point, the second one is inserting the symbol by following a few steps and I’m going to show you the steps in the video and whenever you're going to need to insert a different symbol you could just follow those steps and the third one is copy pasting it from somewhere else. You can get it from Word or from the Internet and you could do that with pretty much any symbol in Excel.
The last two options: the fourth one involves the CHAR function, you're going to need a table that explains which number stands for which symbol in excel and we use this function and we concatenate it with our list and we get a new list that has bullet points.
The last option is by applying a custom format to our list. Find the steps in the video.