Viewlet Library
Excel 2000
To Menu
This is a collection of links to Viewlet demonstrations of various subjects. The Viewlets were created by various contributors. Pacific Mountain Workforce Consortium offers these without any warranty of any kind.
Italicizing Text
Understanding Cells and Active Cells
Hiding and Unhiding Worksheet Tabs
How to Rename Worksheets
How to Use the Chart Wizard
How to Merge Cells and Center Text
How to Jump to a Cell
Insert Hyperlink
Send Email
Set Margins
Advanced Toolbars
Change Default Font
Fill Color
Rotate Text
Merge Cells
Alignment
Cell Borders
Sorting Rows
Deleting Individual Worksheets
Inserting an Individual Worksheet in a Workbook
Open a Copy of a Workbook
Open a Workbook as Read-Only
Open an Existing Workbook
Open a New Workbook
Using Single and Double Accounting Underlining
Underlining Text
Bolding Text
Cutting and Pasting Cells
Deleting Contents of a Cell
Entering Data in a Cell
Freezing and Unfreezing Window Panes
Deleting Individual Columns
Deleting Individual Rows
Inserting Individual Rows
Fill Formats Using Right Mouse Button
Creating Custom Number Formats
Formatting Numbers
Editing Cell Contents
Using the AutoSum Toolbar Button
Changing Page Breaks in Page Break Preview
Splitting a Worksheet's Active Window
Grouping and Ungrouping Worksheets
Moving Worksheets within a Workbook
Resizing Horizontal Scrollbar
Use Drop Down Menu Options to Adjust Row Heights
Using the Height Toolbar Button or Row Header Bar
Using the Width Toolbar button and the Column Header Bar
Changing Column Widths Using Drop Down Menu Options
Setting a Standard Column Width
Highlight Entire Rows, Columns, or Worksheets
Using Drag and Drop to Move Cells
Highlighting a Range of Cells
Using the Currency Style Toolbar Button
Hiding and Unhiding Open Workbooks
Change Standard Font for New Workbooks
Show Formulas
Showing or Hiding Scroll Bars
Show or Hide Comments and Indicators
Resizing a Comment Box
Editing a Comment
Inserting and Deleting a Comment
Show or Hide the Formula Bar
Getting Help for Lotus 1-2-3 Users
Naming a Range of Cells
Sorting Cells in Ascending or Descending Order
Using the Format Painter
Setting Print Margins
Printing Grid Lines
Printing from Print Preview
Viewing Worksheets in Print Preview
Navigating Views
Manually Recalculating Worksheets
Sharing a Workbook
Protecting and Unprotecting a Workbook
Protecting and Unprotecting Worksheets
Hiding and Unhiding Row and Column Headers
Turning Status Bar On and Off
Turning Grid Lines On and Off
Changing Color of Grid Lines
Changing the Default Number of Worksheets in a New Workbook
Changing Direction the Selection Moves after Pressing Enter
Inserting Individual Columns
How to Make a Chart Change to Its Own Sheet
How to Make a Chart Change Back on the Data Sheet
How to Make a Chart on Its Own Sheet
How to Create a Scatter Chart
How to Create a Pie Chart
How to Create a Line Chart
How to Create a Column Chart
How to Create a Bar Chart
How to Create an Area Chart
How to Create a 3D Chart
Adding a Column to a Worksheet
Testing Part of a Procedure in VBA for Excel
Configuring the Visual Basic Editor
Copy and Paste Special a Value
Navigating within a Large Number of Worksheets
Creating VBA Code for an Event Related to the Sheet
Paste Special Formulas
Renaming a Sheet
Moving a Sheet
Deleting a Sheet
Deleting a Column
Adding a Row
Naming a Field
Working in Two Worksheets from the Same Workbook at Same Time
Resizing a Named Field
Renaming a Named Field
Conditional Formatting
A Simple "If" Formula
