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 Insert - Insert Cells.

Icon Insert Cells Insert Cells

CommandCtrl + "+"

Icon Insert Cells Down

Icon Insert Cells Right

Icon Insert Rows

Icon Insert Columns

Choose Sheet - Insert Sheet from File.

Choose Insert - Insert Sheet - From File. On the Insert menu of the Insert tab, choose Insert Sheet from File.

Choose Insert Sheet - From file.

Icon Insert Sheet from File 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 - Named Range or Expression

Choose Sheet - External Links.

Choose Data - External Links.

Icon External Links External Links

Choose Sheet - Named Ranges and Expressions - Manage.

Choose Insert - Manage Names. Choose Data - Manage Names. On the Insert menu of the Insert tab, choose Manage.

Icon Manage Names Manage Names

CommandCtrl + F3

Other

On the drop-down list in the Name Box of the Formula Bar, select Manage Names.

Choose Sheet - Named Ranges and Expressions - Define.

Choose Insert - Define Name. Choose Data - Define Name. On the Insert menu of the Insert tab, choose Define.

Icon Define Name Define Name

Other

On the Name Box of the Formula Bar, insert a name for the selected cells range and press Enter.

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.