26- Changing the Default Font in MS Excel | Cell Formatting In Excel | Format Data In Excel
In Microsoft Excel, a user can change the properties of text in any cell, including font type, size, color, and make it bold, italic, or underlined. A user can also change the color of a cell's background and the border around a cell. The following picture is a graphic illustration of the font and cell format bar in Excel with a description of each option.
So friends in this today's video will be going to learn how we can do formatting the data in Excel and in this section we will talk about Font block or Group which comes under Home Tab which provides access to all the Characters Formatting commands.
Excel 2007 | 2010 | 2013 | 2016 | 2019
When you enter data in a worksheet, Excel automatically uses the Calibri font style in size11 but if you prefer a different font style or size, you can learn in this video.
1) Font - Drop-Down. Provides a list of all the available fonts (based on your current printer selection).
2) Font Size - Drop-Down. Lets you adjust the character size (based on your current printer selection).
3) Increase Font Size - Increases the font size of the current selection to the next larger size in the Font Size box.
4) Decrease Font Size - Decreases the font size of the current selection to the next smaller size in the Font Size box.
5) Bold - (Ctrl + B). Toggles bold on the current selection.
6) Italic - (Ctrl + I). Toggles italics on the current selection.
7) Underline - (Ctrl + U). Button with Drop-Down. The button toggles bold on the current selection. The drop-down contains the commands: Underline and Double Underline.
8) Borders - Button with Drop-Down. The button applies a border to the current selection. The drop-down contains the commands: Bottom, Top, Left, Right, No, All, Outside, Thick Box, Bottom Double, Thick Bottom, Top and Bottom, Top and Thick Bottom, Top and Double Bottom, Draw Border, Draw Border Grid, Erase Border, Line Color, Line Style and More Borders.
9) Fill Color - Button with Drop-Down. The button applies a color to the background of the current selection. The drop-down contains the commands: Theme Colors, Standard Colors, No Fill, and More Colors.
10) Font Color - Button with Drop-Down. The button changes the color of the font of the current selection. The drop-down contains the commands: Automatic, Theme Colors, Standard Colors, and More Colors.
====================================
Watch the video and Grab the information.
Show your support and please do like, share and subscribe to my youtube channel #Belookup and do not forget to click on the bell icon to get the latest updates on my youtube channel and it’s absolutely free and like my Facebook page too. 😊
===================================
FB Page: / belookup
FB Group: / growexcelskills
Instagram: / _piyush_bansal
Channel Link: / @belookup1
===================================
People Also Search:
Excel tutorial: How to apply bold, italic, underlining styles in Excel
Cell Formating in Excel
How To Bold, Italic, Underline In MS Excel?
How to give formatting to your data in MS Excel?
What is the various way of doing formatting in MS Excel?
How to apply background color in Excel?
How to apply background and font color in MS Excel.
How to Apply Border In Excel?
How to remove the border in excel and way of applying it?
How to format data in Excel?
how to do formatting in excel
Format Cells in Excel - Easy Excel Tutorial
How to Format Your Excel Spreadsheets
Format Excel Cells - Excel Tutorial - Spreadsheet
Ways to format a worksheet - Excel
BeLookUp
#Belookup #excel #fontinexcel #exceltutorial