Return to the textbook page
- Contact Us
- Access Technology Institute Copyright Notice
- Introduction
- Table of Contents
- Maximize the Microsoft Excel Window
- Disable JAWS Virtual Ribbon Menus
- Configure Excel
- The Options Window
- General Property Sheet
- The Start Screen
- Start Screen Layout
- The Home Property Sheet
- Home Property Sheet Controls
- Manage Documents in the Documents List Box
- New Property Sheet
- Open Property Sheet
- Recent
- Shared with Me
- OneDrive
- This PC
- Add a Place
- Browse
- Account
- Feedback
- Options
- Close the Start Screen
- The Microsoft Excel Display
- The Title Bar
- Quick Access Toolbar
- Ribbon Tabs
- Ribbon
- Document Window
- Status Bar
- Open and Close the Ribbon
- Ribbons
- Note on Ribbon Tabs and Ribbon Terminology
- Ribbon Tabs
- Ribbon
- Open vs Closed Ribbon
- Exercise – The Display and Ribbon
- Quick Access Toolbar
- Add Commands to the Quick Access Toolbar
- Remove Commands from the Quick Access Toolbar
- Customize Ribbons
- Open Ribbon Customization Options
- Ribbon Terminology
- The Customize Ribbon Property Sheet
- Add Ribbon Commands to an Existing Ribbon Tab
- Remove Commands from a Ribbon Group
- Add a Ribbon Tab
- Remove Custom Ribbon Tabs, Groups or Commands
- Organize Ribbon Tabs, Groups and Commands
- Hide and Show Ribbon Tabs
- Reset Ribbon Customizations
- Export Ribbon Configurations
- Import Ribbon Configurations
- Save or Cancel Ribbon Customizations
- Access Custom Ribbon Tabs
- Customize the Quick Access Toolbar
- Exercise – Ribbon and Quick Access Toolbar
- Workbooks and Worksheets
- Workbooks
- Worksheets
- Rows, Columns, and Cells
- Navigate a Worksheet
- JAWS for Windows Cell Verbosity
- Insert Cell Data
- Insert Fractions
- The Active Cell
- Edit Cell Data
- Delete Cell Data
- Exercise: Workbooks, Worksheets, and Cells
- Navigate and Read Text
- Windows Text Navigation
- Phonetic Character Reading on Pause
- JAWS for Windows Desktop Reading Commands
- JAWS for Windows Laptop Reading Commands
- JAWS for Windows Say All
- Adjust JAWS for Windows Speech Rate
- Temporarily Adjust Speech Rate
- Permanently Adjusting Speech Rate
- Exercise – Navigate and Read Text
- Manage Worksheet Elements
- Create a Worksheet
- JAWS for Windows Cell Lists
- Select Cells, Rows, Columns, and Regions
- Extend Row and Column Selection
- Remove Selection
- Select Non Contiguous Regions and Cells
- Read Selected Cells
- JAWS for Windows Selection Verbosity
- Insert Cells, Rows, Columns and Worksheets
- Insert Cells
- Insert Rows and Columns
- Insert a Worksheet
- Navigate Excel Worksheets
- Rename a Worksheet
- Column and Row Titles
- Configure JAWS for Windows Title Reading
- Insert Additional Data
- Delete Worksheet Elements
- Delete Cells
- Delete Rows and Columns
- Delete a Single Row or Column
- Delete Multiple Rows
- Delete a Worksheet
- Exercise: Manage Worksheet Elements
- Manage Cell Text
- Cropped Text
- Manual Carriage Return
- Wrap Cell Text
- Adjust Column Width and Row Height
- Adjust Column Width
- Adjust Row Height
- Autofit
- Exercise: Manage Cell Text
- Hide Rows, Columns, and Worksheets
- Unhide Worksheets, Columns and Rows
- Unhide a Worksheet
- Unhide Columns and Rows
- Unhide All Columns and Rows
- Exercise: Hide and Unhide Data, Formulas and Functions
- Formulas
- Edit Formulas
- Reference Cell Addresses in Formulas
- Functions
- Exercise: Hide and Unhide Data: Formulas and Functions
- Absolute and Relative Values
- Row and Column Totals
- Assign Totals Cells
- Row or Column Total JAWS for Windows Keyboard Commands
- Read Column or Row Totals with JAWS for Windows
- Clear Column or Row Totals
- Format Cells
- The Format Cells Dialog
- Format Numbers
- Format Numbers in the Format Cells Dialog
- JAWS for Windows Number Format Alerts
- Number Format Keyboard Accelerators
- Format Numbers in Your Worksheet
- Align Cell Data
- Align Cell Data in the Format Cell Dialog
- Align Cell Data in the Home Ribbon
- Windows Alignment Keyboard Accelerators
- Font Attributes
- The Format Cell Dialog Font Property Sheet
- Open the Font Dialog
- Font Configuration Controls
- Font Attribute Keyboard Accelerators
- Home Ribbon Font Attribute Commands
- Say Cell Font and Attributes with JAWS for Windows
- Cell Borders
- Format Cell Dialog Border Property Sheet
- Add Borders in the Home Ribbon
- Cell Border Keyboard Accelerators
- Describe Cell Borders with JAWS for Windows
- JAWS for Windows Cell Border Indication
- Cell Colors
- Format Cell Dialog Fill Property Sheet
- Home Ribbon Fill Color Split Button
- Removing Cell Formatting
- Insert the Date or Time
- Exercise: Cell Formats
- Hyperlinks
- Insert a Hyperlink
- Link to a Web Page
- Link to an Email Address
- Link to Another Document
- Open a Linked Document in a Target Frame Internet Only
- Edit a Hyperlink
- Remove a Hyperlink from Text
- Activate a Hyperlink
- Delete a Hyperlink
- Read a Hyperlink with JAWS for Windows
- JAWS for Windows Hyperlink Detection
- JAWS for Windows Links List
- Exercise: Hyperlinks
- Databases
- Open the Database Form
- Navigate Records in the Database Form Dialog
- Search Database Records
- Delete a Record
- Filter a Database
- JAWS for Windows Filtered Columns and Rows Detection
- Exercise: Databases
- Named Cells, Ranges and Tables
- Name a Cell or Cell Range
- Format a Table
- Create a Named Constant
- Define a Formula Name
- Select a Named Cell, Named Range or Table in Go To
- Manage Cell and Table Names
- Exercise: Named Cells, Ranges, and Tables
- JAWS for Windows Custom Summary Labels
- Create a Custom Summary Label
- View Custom Summary Labels
- Organize Custom Summary Labels
- Rename a Custom Summary Label
- Delete a Custom Summary Label
- Delete All Worksheet Custom Summary Labels
- Exercise: JAWS for Windows Custom Summary Labels
- JAWS for Windows Monitor Cells
- Configure Monitor Cells
- Read Monitor Cells
- Configure Monitor Cell Title Reading
- List Monitor Cells
- Exercise: JAWS for Windows Monitor Cells
- Merge Cells
- Exercise: Merge
- Excel Autofill
- Input the Same Data into a Cell Range
- Input a Series of Values
- Fill a Growth Trend
- Flash Fill
- Exercise: Autofill and Flash Fill
- Quick Analysis
- Formatting Property Sheet
- Charts Property Sheet
- Totals Property Sheet
- Table and Sparklines Property Sheets
- Conditional Formatting
- Highlight Cell Rules
- Top Bottom Rules
- Data Bars
- Color Scales
- Icon Sets
- Create New Formatting Rules
- New Formatting Rule Dialog
- Manage Custom Rules
- Clear Conditional Formatting
- Go To Dialog Special Options
- JAWS Conditional Formatting Alert
- Goal Seek
- Sort a Data Region
- Microsoft Excel Find and Replace Dialog
- Open Find and Replace Dialog Property Sheets
- Find
- Replace Property Sheet
- Exercise: Find and Replace
- Charts
- JAWS for Windows Charts List
- Read a Chart with JAWS for Windows
- Edit a Chart
- Chart Design Ribbon
- Chart Format Ribbon
- Pivot Tables
- Insert Pivot Tables in Quick Analysis
- Navigate Pivot Tables
- Change Pivot Table Column Contents
Return to the textbook page