This “Flash Fill” shortcut is a great way to save time and reduce errors by automatically filling in a column based on a pattern you have established thus eliminating the need to manually enter the data.
Step 1: Type each once
Step 2: Ctrl E in each column
#exceltips #excel #exceltutorials #funfacts #spreadsheet #sheets #exceltricks #learnexcel #workhacks #howto #funfactofday #funfactsoftheday #learnmoreearnmore