Excel Tips, Tricks, and Shortcuts

Hello there. I'm Michael Leng. Today, in my blog "Exceltip2day" , I'm going to talk about: How to re-format the multiple data entered in an Excel sheet. Tip Quiz Do you know what is the Excel shortcut key for call out "Insert Function" Dialog Box? Do you know the very shortest way to format the entire cells in a worksheet? Fortunately, this following method is the best trick as far as I have ever known. It helps you to format the entire cells in a workbook to be the only one unique format. More, it does not complicate at all. Here comes the step-by-step shortcut: Select the original format cell as wanted. (Ex. Cell  “ B3 ” ). Click on the “Format Painter” icon on the top left corner. Press the “Ctrl” “A” buttons on your keyboard. Done! The outcome should be the same as the images beneath. Figure no.1 Shows the format of the entered data with none arrangement. Figure no.2 Shows the format of the entered data after...