Spreadsheet Design & Auditing Tips

Comment: A5:IV5 would also reference the entire 5th row. A1:A65536 would also reference the entire column A. However, 5:5 and A:A do the same thing and are easier to type and remember. 4. What is Excel’s R1C1 reference style? A. Reverses the usual row and column order in references. For example, A5 becomes 5A. ................
................