Fishhawk

Excel Tricks

Excel (Mac v.) – AutoFill Thousands of Rows at Once without dragging in Excel

Magic double clicking on the right bottom square to fill the cells in the column till the last filled row.  

Excel – AutoFill Thousands of Rows at Once without dragging in Excel

Home > Fill > Series  

Add Spaces to Combined Text

Type the & operator Space: ” ” (double quote, space, double quote) Comma Space: “, ” (double quote, comma, space, double quote) Semi-colon Space: “, ” (double quote, semi-colon, space, double quote) Line break: CHAR(10) NOTE: Turn on Wrap Text in the cell, if using a Line Break
Related Posts