Structure

Worksheets

This section will give you the commands for working with worksheets.

Worksheet management
Outcome Keyboard Dragon command
Rename worksheet
  1. Alt to move to the ribbon
  2. H to open the Home ribbon
  3. O to open the Format menu
  4. R to rename sheet
  5. Type in meaningful worksheet name
  6. Enter
  1. Rename sheet
  2. Dictate meaningful worksheet name
  3. Press enter
Create new worksheet Shift + F11 Insert worksheet
Delete worksheet
  1. Alt to move to the ribbon
  2. H to open the Home ribbon
  3. D to open the Delete menu
  4. S to delete sheet
 Delete sheet
Move worksheet
  1. Alt to move to the ribbon
  2. H to open the Home ribbon
  3. O to open the Format menu
  4. M to open the Move or copy options
  5. ↓ to select where you want to move it to
  6. Tab to go to OK button
  7. Enter
  1. Format
  2. Move or copy sheet
  3. From the Before sheet section, say what you see
Copy worksheet
  1. Alt to move to the ribbon
  2. H to open the Home ribbon
  3. O to open the Format menu
  4. M to open the Move or copy options
  5. ↓ to select where you want to copy it to
  6. Tab to go to the Create a copy checkbox
  7. Spacebar to check the Create a copy checkbox
  8. Tab to go to OK button
  9. Enter
  1. Format
  2. Move or copy sheet
  3. Create a copy
  4. From the Before sheet section, say what you see

Rows and columns

This section will give you instructions for inserting and deleting columns and rows.

Working with rows and columns
Outcome Keyboard Dragon command
Insert column
  1. Alt to move to the ribbon
  2. H to open the home ribbon
  3. I to open the Insert menu
  4. C to insert column
 Insert column
Insert row
  1. Alt to move to the ribbon
  2. H to open the home ribbon
  3. I to open the Insert menu
  4. R to insert row
 Insert row
Delete column
  1. Alt to move to the ribbon
  2. H to open the home ribbon
  3. D to open the Delete menu
  4. C to delete column
 Delete column
Delete row
  1. Alt to move to the ribbon
  2. H to open the home ribbon
  3. D to open the Delete menu
  4. R to delete row
 Delete row

Tables

Converting data into a proper table is essential to ensure that it is accessible for other assistive software users. The following instructions will explain how to work with tables.

Table management
Outcome Keyboard Dragon command
Convert data into a table
  1. Select cells that you want to convert into a table
  2. Ctrl + T
  3. Tab to go to My table has headers checkbox
  4. Spacebar to toggle checkbox on or off
  5. Tab to go to OK button
  6. Enter
  1. Select cells that you want to convert into a table
  2. Insert
  3. Table
  4. My table has headers to toggle checkbox on or off
  5. OK
Name a table
  1. Move to any cell in the table
  2. Alt to move to the ribbon
  3. J T to open the Table Design ribbon
  4. A to enter the Table Name field
  5. Type a one word table name
  6. Enter
  1. Go to any cell in the table
  2. Table design
  3. Table name
  4. Dictate a one word table name
  5. Press enter
Insert a row or column into the table
  1. Go to any cell in the table
  2. Alt to move to the ribbon
  3. H to open the Home ribbon
  4. I to open the Insert menu
  5. A to insert a table row or L to insert a table column
  1. Go to any cell in the table
  2. Insert row or Insert column
Delete a row or column from the table
  1. Go to any cell in the row or column you want to delete
  2. Alt to move to the ribbon
  3. H to open the Home ribbon
  4. D to open the Delete menu
  5. L to delete a table row or M to delete a table column
  1. Go to any cell in the row or column you want to delete
  2. Delete row or Delete column
Designating a header row and column
  1. Go to any cell in the table
  2. Alt to move to the ribbon
  3. J T to open the Table Design ribbon
  4. O to toggle Header Row on and off
  5. C to toggle First Column on and off
  1. Go to any cell in the table
  2. Table design
  3. Header row to toggle Header Row on and off
  4. First column to toggle First Column on and off

Video Demonstration

The following video will show you how to rename worksheets, and create and name a table.

00:00
Clicky