Log In
Home
Support
Demos
Documentation
Blogs
Training
Webinars
Welcome to DevExpress .NET Documentation
WinForms Controls
ASP.NET Controls and MVC Extensions
ASP.NET Bootstrap Controls
ASP.NET Core Bootstrap Controls
WPF Controls
Xamarin Controls
Windows 10 App Controls
Document Server
Product Information
Redistribution and Deployment
Spreadsheet Document Server
XL Export Library
Overview
Product Structure
Getting Started
Examples
Workbooks
Worksheets
Rows and Columns
Cells
Formulas
Formatting
Conditional Formatting
Tables
Grouping
Filtering
Sparklines
Pictures
Printing
Data Validation
Rich Edit Document Server
Snap Document Server
PDF Document Processor
Compression Library
Bar Code Library
Unit Conversion Library
API Reference
Reporting
Report Server
Dashboard
eXpressApp Framework
CodeRush
CodeRush Classic
Cross-Platform Core Libraries
Tools and Utilities
End-User Documentation
Document Server
>
XL Export Library
>
Examples
Examples
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: 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: Add a Hyperlink to a Cell
Formulas
How to: Create a Cell Formula
How to: Create Shared Formulas
How to: Create Subtotals
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
How to: Apply 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
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
How to: Insert and Position a Picture in a Worksheet
How to: Add a Hyperlink to a Picture
See Also
Getting Started
Is this topic helpful?
Additional Feedback
Close
Please tell us how you’d like us to improve this topic.
Send