25 Very Useful Keyboard Shortcuts To format any selected object press ctrl+1 To insert current date press ctrl+; To insert current time press ctrl+shift+; To repeat last action press F4 To edit a cell comment press shift + F2 To autosum selected cells press alt + = To see the suggest drop-down in a … Continue reading Here are 75 Excel Shortcuts & tips to improve your skill
You could validate it to check to see if the string contains an “@” and contains a “.” somewhere after the “@”. Try: =IF(AND(ISNUMBER(FIND(“@”,A1)),ISNUMBER(FIND(“.”,A 1,FIND (“@”,A1)+1))),”valid e-mail”,”no”) Continue reading Validating an e-mail address in excel
Automatically SUM() with ALT + = Quickly add an entire column or row by clicking in the first empty cell in the column. Then enter ALT + ‘=’ (equals key) to add up the numbers in every cell above. Logic for Number Formatting Keyboard Shortcuts At times keyboard shortcuts seem random, but there is logic … Continue reading Excel Shortcuts
Knowledge Hub 