KwickClips Course Topics · 38 sec · free
How do you refer to cell B2 on sheet Mid in Calc?
Short answer. =Mid.B2
What separates the file path from the sheet?
A hash (#).
Remember
| Sheet: =Mid.B2 |
| File: path, #, sheet.cell |
In Calc, is it Mid dot B2, or an exclamation mark? Another sheet is name, dot, cell. Another file adds its path, a hash, then sheet and cell. Remember. Sheet uses a dot. A file adds its path and hash.
This clip is from the full lesson: Linking Spreadsheet Data: setting up multiple sheets; creating references to other sheets and other documents — 5 minutes, with the tables, the quick answers and the whole lesson in text.
Useful for: CBSE Class 10 Information Technology (402)
More KwickClips from this lesson
Voice-over is AI-generated; the script is written and checked by Kajal Ma'am. Confirm anything you plan around against your official board document. We never ask for a password or an OTP.