Examples
- 3 minutes to read
This section provides a full list of examples (grouped by features) contained in this help.
Workbooks
- How to: Create a New Document
- How to: Password Protect a Workbook
- How to: Specify Document Properties for a Workbook
Worksheets
- How to: Create a New Worksheet
- How to: Set a Worksheet Name
- How to: Hide a Worksheet
- How to: Reorder Worksheets within a Document
- How to: Show and Hide Row and Column Headers
- How to: Show and Hide Gridlines
Rows and Columns
- How to: Create a Column
- How to: Create a Row
- How to: Hide a Row or Column
- How to: Specify Row Height and Column Width
- How to: Freeze Rows and Columns
Cells
- How to: Create a Worksheet Cell and Set Its Value
- How to: Merge Cells or Split Merged Cells
- How to: Specify the Cell Selection
- How to: Add a Hyperlink to a Cell
Formulas
Formatting
- How to: Format a Cell
- How to: Apply Predefined Formatting to a Cell
- How to: Apply Themed Formatting to a Cell
- How to: Change Cell Background Color
- How to: Configure Cell Font Settings
- How to: Add Cell Borders
- How to: Align Cell Content
- How to: Specify Number Format for Cell Content
- How to: Apply Rich Formatting to the Cell Text
Conditional Formatting
- How to: Format Cell Values that are Above or Below the Average
- How to: Format Cells that are Less than, Greater than or Between a Value
- How to: Format Blank Cells
- How to: Format Unique or Duplicate Values
- How to: Use a Formula to Determine what Cells to Format
- How to: Format Top or Bottom Ranked Values
- How to: Format Cells based on the Text in the Cell
- How to: Format Cells with Dates
- How to: Format Cells Using Data Bars
- How to: Format Cells Using Icon Sets
- How to: Format Cells Using Color Scales
Data Validation
Tables
- How to: Create a Table
- How to: Apply a Table Style
- How to: Apply Custom Formatting to a Table
- How to: Create a Calculated Column
Filtering
Printing
- How to: Specify Print Settings
- How to: Set Page Margins
- How to: Add Headers and Footers to a Worksheet Printout
- How to: Insert Page Breaks in a Worksheet
- How to: Print Titles on a Worksheet
Sparklines
- How to: Create Sparklines
- How to: Customize the Sparkline Appearance
- How to: Specify Sparkline Axis Settings
Pictures
See Also