Worksheets, Workbooks, and Cell References

• References to other worksheets, Worksheet Reference =Sheet2!B6

• References in another workbook: [Book2]Sheet3!B5

• Linking workbooks and re-naming them afterwards will create problems!

• Ctrl+PageDown, Ctrl+PageUp keys: worksheet navigation

• Edit menu, Delete Sheet - deletes current worksheet

• Insert menu, Worksheet - inserts new worksheet into workbook