Microsoft Excel spreadsheets frequently ... as an array enters the same formula in all highlighted cells, whereas entering "=A1:A20B1:B20" multiplies columns A and B in each respective row.

Launch Microsoft Excel 2010 and open the spreadsheet that contains the hidden lines. Press the "Ctrl-A" keys to select the entire spreadsheet. Press the "Ctrl-Shift-(" keys together to expand all ...

Impact Link Excel is a great program with hundreds of helpful functions. Unfortunately, one function it's lacking is a simple way to merge two or more columns while preserving all of their data.