Excel Basics #12: Stylistic & Number Formatting

The Excel Basics Series shows a systematic description of what Excel can do from beginning to end.
#12 Video topics:
1)Learn about the Format Cells Dialog Box: Ctrl + 1
2)See the Number, Alignment, Font, Borders, Fill (Patterns) Tabs in the format cell dialog box
3)See how to format a table including Center Across Selection (No Merge AND Center) and Borders
4)Learn about Number formatting
5)Date Math and Formatting Format (Date Number Format)
6)Time Math and Formatting Format (Time Number Format)
7)Accounting and Currency Number Formatting Format
8)Blank and Custom Number Format

Category:

Science & Technology

Tags:

• Excel
• Number
• and
• Stylistic
• Format
• Formatting
• Cells
• Date
• Time
• Mike
• Gel
• Girvin
• Highline
• Community
• College

[KUNAALnPOOJA4ever]

qs though

for my assignment i have to make a time sheet

but i dnt knw how to put right hours like if the total worked hours are 5.75 how can i make it right automatically to worked hours are 6.15.

[ExcelIsFun]

@KUNAALnPOOJA4ever , try video:"

Excel Basics #15: Date & Time Format & Calculations

[KUNAALnPOOJA4ever]

thank you thank you thank you

you are big help for me with my assignment

[ExcelIsFun]

@KUNAALnPOOJA4ever , you are w elcome!

[siberianfeline]

You are such an amazing person with your enthusiasm and knowledge you make the excel really really fun. With all those shortcut keys and information you are the BEST. Thank you for all the post. I watch your videos everyday and determined to go through all of them over and over (I am far from finishing them though). Thank youX10000000000 :)

[ExcelIsFun]

You are welcome!

[ExcelIsFun]

I am glad that you like them!

Ctrl + * (* on Number Pad), or yes, as you say:

"CRTL + SHIFT + *" if you are using the 8 key.

[ExcelIsFun]

I am glad that you like the videos!

[ExcelIsFun]

Thanks!

[atchkutch]

@ExcelIsFun You are Fantastic :) Thank you very much for all the videos :) Your Great! :) with regards to highlight the whole table its "CTRL+Fn+*" if you will use the number pad :P

[atchkutch]

Your Great! :) with regards to highlight the whole table its "CTRL+Fn+*" if you will use the number pad :P