Insert Menu /text/scalc/00/00000404.xhp Sun Microsystems, Inc.

Insert Menu

Choose Insert - Headers and Footers. Choose Format - Page Style - Header (or Footer) tab, press Edit. Choose Styles - Manage Styles - Page Styles, open context menu of the page style, choose Edit Style - Header (or Footer) tab, press Edit.

Choose Layout - Headers and Footers. Choose Layout - Format Page - Header (or Footer) tab, press Edit. On the Insert menu of the Insert tab, choose Headers and Footers.

Icon Headers and Footers Headers and Footers

Choose Insert - Field. Choose Insert - Field - Date. Choose Insert - Field - Sheet Name. Choose Insert - Field - Document Title.

Choose Insert - Time.

Choose Insert - Fields - Time. On the Insert menu of the Insert tab, choose Time.

Icon Insert Time Insert Time

CommandCtrl + Shift + ; (semicolon)

Choose Insert - Date.

Choose Insert - Fields - Date. On the Insert menu of the Insert tab, choose Date.

Icon Insert Date Insert Date

CommandCtrl + ; (semicolon)

Choose Insert - Sparkline.

Choose Sparklines - Sparklines.

On the Data menu of the Data tab, choose Sparklines - Sparklines.

Choose Sheet - Insert Cells. Choose View - Toolbars and select the Insert Cells toolbar:

Icon Insert Cells

Icon Insert Cells Down

Icon Insert Cells Right

Icon Insert Rows

Icon Insert Columns

Choose Sheet - Insert Sheet from File.

Choose Insert - Function.

On the Insert menu of the Insert tab, choose Function.

Icon Function Wizard Function Wizard

CommandCtrl + F2

Insert - Function - Category Database Insert - Function - Category Date & Time Insert - Function - Category Financial Insert - Function - Category Information Insert - Function - Category Logical Insert - Function - Category Mathematical Insert - Function - Category Array Insert - Function - Category Statistical Insert - Function - Category Text Insert - Function - Category Spreadsheet Insert - Function - Category Add-In Insert - Function - Category Add-In Choose Insert - Named Range or Expression. Choose Sheet - External Links.

Choose Sheet - Named Ranges and Expressions - Define. CommandCtrl+F3

Choose Insert - Named Ranges and Expressions. Choose Sheet - Named Ranges and Expressions - Insert.

On the Insert menu of the Insert tab, choose Named Ranges and Expressions.

Choose Sheet - Named Ranges and Expressions - Create. Choose Sheet - Named Ranges and Expressions - Labels.