Top 10 Microsoft Excel Tips amp Tricks 6

############################# Video Source: www.youtube.com/watch?v=EEk0nISTu2E

Tip 53 - How to display only the last 4 digits of a credit card, SSN or phone number in Excel • Learn how to display only the last 4 digits of a credit card, SSN and/or phone number in Excel.. • Let's imagine you want to display only the last four digits of a credit card number, identification number, Social Security number, or other information and hide the remaining digits with asterisks for standard security measures. In this video, I will demonstrate how to do that. You can use the same method regardless of whether the digits in your cell are written as text, numbers, or the unique Social Security number format. • Here is the formula. • = ************ RIGHT(A2,4) • Tip 54 - How to add unit to cells in Excel • Learn how to add unit to a cell in Excel automatically. • Here are the steps for whole number. • 1) Select a cell • 2) Ctrl + 1 • 3) Number Tab --- Custom • 4) Under Type text box, enter the following. • 0 pcs • 5) OK • 6) Apply to all cells using Format Painter. • Here are the steps for decimal number (float/real). • 1) Select a cell • 2) Ctrl + 1 • 3) Number Tab --- Custom • 4) Under Type text box, enter the following. • 0.000 kg • 5) OK • 6) Apply to all cells using Format Painter. • Tip 55 - Compare two or more worksheets at the same time • Learn how to compare two or more worksheets at the same time. • Viewing two worksheets side by side allows you to easily compare worksheets that are either in the same workbook or in distinct workbooks. Additionally, you can arrange various spreadsheets so that you can view them all at once. • 1) View • 2) Window • 3) New Window • Tip 56 - Freeze panes to lock rows and columns • Learn how to freeze panes to lock rows and columns. • Go to the View tab to Freeze Panes to lock select rows and columns in place or Split Panes to create two windows of the same worksheet if you want to keep a portion of a worksheet visible while scrolling to another portion of the worksheet. • Steps on how to Freeze First Column. • 1) View -- Window -- Freeze Panes • 2) Freeze First Column • Steps on how to Freeze Top Row. • 1) View -- Window -- Freeze Panes • 2) Freeze Top Row • Steps on how to Freeze top 2 row. • 1) Select the third row. • 2) View -- Window -- Freeze Panes • 3) Freeze Panes • Steps on how to Freeze first 4 columns. • 1) Select the 5th column. • 2) View -- Window -- Freeze Panes • 3) Freeze Panes • Steps on how to Freeze Panes. • 1) Select cell B3 • 2) View -- Window -- Freeze Panes • 3) Freeze Panes • Hotkey to unfreeze panes is Alt + W + F + U. • Tip 57 - Words Count in Excel • Learn how to word count in Excel cell. • This is the formula. • =LEN(TRIM(A2))-LEN(SUBSTITUTE(A2, , ))+1 • Tip 58 - Translate Languages Using Google Sheets • Learn how to translate languages using Google Spreadsheet formula googletranslate(). • This is the formula. • =GOOGLETRANSLATE($C$3, $A$3, A4) • List of languages support by GoogleTranslate formula. • Language Name Language Code • Afrikaans af • Irish ga • Albanian sq • Italian it • Arabic ar • Japanese ja • Azerbaijani az • Kannada kn • Basque eu • Korean ko • Bengali bn • Latin la • Belarusian be • Latvian lv • Bulgarian bg • Lithuanian lt • Catalan ca • Macedonian mk • Chinese Simplified zh-CN • Malay ms • Chinese Traditional zh-TW • Maltese mt • Croatian hr • Norwegian no • Czech cs • Persian fa • Danish da • Polish pl • Dutch nl • Portuguese pt • English en • Romanian ro • Esperanto eo • Russian ru • Estonian et • Serbian sr • Filipino tl • Slovak sk • Finnish fi • Slovenian sl • French fr • Spanish es • Galician gl • Swahili sw • Georgian ka • Swedish sv • German de • Tamil ta • Greek el • Telugu te • Gujarati gu • Thai th • Haitian Creole ht • Turkish tr • Hebrew iw • Ukrainian uk • Hindi hi • Urdu ur • Hungarian hu • Vietnamese vi • Icelandic is • Welsh cy • Indonesian id • Yiddish yi • Tip 59 - How do I create a dynamic drop down list in Excel • Learn how to create a dynamic drop down list in Excel. • Here are the steps. • A) Create List Data Table • 1) Select the list data cells. • 2) Ctrl + T • 3) Check on My table has headers • 4) OK • B) Create Data Validation List • 1) Select a cell. • 2) Data -- Data Validation • 3) Allow set to List • 4) Source set to =$C$2# • C) Expanding Data Validation List • 1) Select last item in the Data List • 2) Tabs • 3) Add list item. eg Glue • 4) Enter • Tip 60 - How to Hide or Show Formula Bar in Excel • Learn how to hide or show formula bar in Excel. • Enable Formula Bar In Tool Ribbon • 1) File • 2) Options • 3) Advanced • 4) Look for Display section • 5) Check on Show Formula Bar • 6) OK • Tip 61 - Add hours, minutes and seconds to time in Excel • Learn how to add hours, minutes and seconds to time in Excel. • This is the formula you need to use. • =A3+TIME(B3,C3,D3) • Tip 62 - Auto Correction • For example, if you type, yuor , it get automatically replaced by your . These settings are found here. • 1) File --- Option • 2) Proofing • 3) AutoCorrect Options... • #tip #excel #microsoft #shorts #shortvideo #shortsvideo #howto #how #google

#############################

New on site