How-To Geek on MSN

You need to know the difference between a range and an array in Excel

Excel processes the range (A1:A10) by converting it into an array in memory. This array is what Excel works with to calculate the sum. The distinction is subtle but important: while the range is the ...
How-To Geek on MSN

7 Microsoft Excel tricks you probably didn't know

Press Windows+Z to rearrange how your duplicated Excel windows appear on your screen. Press Ctrl+Shift+; to insert the ...