ADVANCED EXCEL KEYBOARD SHORTCUTS EXCEL KEYSTROKES ACTION EXCEL KEYSTROKES ACTION DATA SELECTION / NAVIGATION FORMATTING Ctrl Pg Up / Pg Down Move to Prior / Next Worksheet Alt E S, then Paste Special (copy first) Shift / Ctrl Spacebar Select Entire Row / Column F, T, V Formulas, Format, Value Ctrl * (Ctrl Shift 8) Select All Adjacent Cells EExcel has adjusted the formulas because the cell references are relative We may think of it in this way In the formula =B2∗C2 in D2, the reference to B2 is interpreted as the cell that is two columns to the right and on the same row as the cells containing the formula So when the formula is copied to D3, the reference to B2 is changed to Similarly, the reference to C2 is changed to C3In the example, the function is used to find whether any customer on 5/18/15 list is a repeated customer – are they on the list of customers in column A?
Advanced Array Functions Desktop Liberation
What are the advanced excel formulas