HOSP 187 Lecture Notes - Lecture 1: Hyperlink, Tooltip, Circular Reference

• School: University of Delaware
• Department: Hotel, Restaurant and Institutional Management
• Course: HOSP 187
• Professor: Zjisk

Document Summary

Auto-(cid:396)e(cid:272)o(cid:448)e(cid:396) (cid:894)(cid:449)he(cid:374) u(cid:374)do is(cid:374)"t e(cid:374)ough(cid:895: use auto recover when for example you wiped out a critical column of numbers 20 min ago while editing your spreadsheet, file info. Adding hyperlink: you can create a hyperlink to a web page, you can create a hyperlink to a different type of file, you can create a hyperlink to another worksheet or another part of the current spreadsheet. Automatically selecting your data: move to the first cell that you want to select, hold down shift, double click whichever edge of the active cell corresponds to the direction you want to auto-select, excel completed your selection automatically. Moving cells around: move single cell or a continuous range of cells. Everything goes with it, (data, current formatting, etc. ) or you can choose to limit: paste into a blank area replace data, cutting and copying cells works almost exactly the same way.