Ravi Sir's Cards › Excel
Analyst tricks: fill blanks, Ctrl+Enter, paste values
Revision card: Analyst tricks: fill blanks, Ctrl+Enter, paste values. Example data table with Fill each blank with the value above: A3, A4 = Pune; A6 = Nashik; Type 0 into B2:B6 at once: 5 cells filled; Keep results, drop the formulas: fixed values.
Read card text
What this card says
Analyst tricks: fill blanks, Ctrl+Enter, paste values
Example
data table with Fill each blank with the value above: A3, A4 = Pune; A6 = Nashik; Type 0 into B2:B6 at once: 5 cells filled; Keep results, drop the formulas: fixed values
Learn this in the lesson: 26. Excel Tricks Every Analyst Should Know