What is Excel?
Excel is a program for organizing data. You can create tables, graphs, and lists.
Workbooks, Worksheets, Columns, and Rows
Each Excel file is a workbook. Each workbook can has one or more worksheets. The worksheet is where you find cells and enter data. When you think about using Excel, you’re usually thinking about using the worksheet. Each new worksheet is like a new blank document, but it is within the same workbook.
Worksheets are spreadsheets organized by columns (vertical) and rows (horizontal). The rows are numbered, starting with one an going up. Columns are labeled alphabetically, starting with A and continuing to Z, then AA to AZ, and so on until ZZZ.
The Cell in Excel
The unit where a column and row meet is a cell. Cells are where the data (numbers, text, etc.) of the spreadsheet resides. The cell title is a combination of its column and row designations. For example, the cell in the first row and first column is A1. Further, the cell in the 4th column and 18th row is D18.
We can move from cell to cell using the arrow keys. Each arrow key will move you by cell in whatever direction you’ve selected. As we move into new cells, JAWS will announce the contents and location of the cell.
Opening, Saving, and Printing
Read the title bar of the active program | Insert + T
Open the file tab to save, open, print, and more | Alt + F
Create a new empty document | Ctrl + N
Open a saved document | Ctrl + O
Save file | F12
Print | Ctrl + P
Using the Ribbon with Excel
Excel uses a visual ribbon toolbar like other Microsoft Office applications. Below are keyboard commands that are helpful when working with the ribbon.
Move focus between the ribbon and the document | Alt
Move through the buttons within a ribbon tab | Tab
Move through the different ribbon tabs | Arrow Keys
Read the item currently in focus | Insert + Tab
Navigating the Worksheet
Navigating the Excel spreadsheet requires a whole series of hotkeys on its own. Spreadsheets can be large and complex, and it is easy to get lost. We already learned we can navigate the spreadsheet by using the arrow keys, but this will be too slow in some cases. Below are commands that will allow you to work with Excel with speed and clarity.
Move focus to the first cell in the worksheet | Ctrl + Home
Move focus to the last cell of contiguous data in the worksheet | Ctrl + End
Read the active cell’s contents | Insert + Tab
Read the active cell’s coordinates | Insert + C
Move to the last populated cell in any direction | Ctrl + Arrow Keys
Move until focus encounters a populated cell in any direction | Ctrl + Arrow Keys
Naming Columns and Rows
Excel is easier to use when we give columns and rows names instead of only using their coordinates.
To name a column, move your focus to the row that contains column titles and use the command below. To name a row, move your focus to the column that contains row titles and use the command below.
Name the active column | Insert + Alt + Ctrl + C
Name the active row | Insert + Alt + Ctrl + R
Read the column title | Insert + Alt + Shift + C
Read the row title | Insert + Alt + Shift + R
Cells with Data
Finding data that isn’t next to each other in Excel can be hard. How many empty cells do you have to skip before you know you didn’t miss anything? Luckily, JAWS has tools to make this easy.
The “cells with data” menu shows all the non-blank cells in your workbook. Use the up and down arrows to move through the list. When you find the cell you want, press Enter and JAWS will jump to it.
Open the cells with data menu | Ctrl + Shift + D
Open list of cells in active column | Insert + Shift + C
Open list of cells in active row | Insert +Shift + R
Selecting Data
In Excel, knowing how to select data is important. You may need to delete, move, or format whole columns, rows, or parts of a spreadsheet. Here are some key commands to help you do that.
Select all contiguous data in the active section of the worksheet | Ctrl + A
Select all data in the worksheet | Ctrl + A, then Ctrl + A
Select all cells in active column | Ctrl + Space
Select all cells in active row | Shift + Space
Read the bounds of the selected text | Insert + Shift + Down Arrow
Formatting Text
Excel allows you to change how your text looks.
Bold selected text | Ctrl + B
Italicize selected text | Ctrl + I
Underline selected text | Ctrl + U
Read formatting attributes of selected text | Insert + F
Making Your Data Work
Excel can do much more than hold data in columns and rows. It can do a range of computations. If you start a cell entry with the equals sign, that will make that cell a formula. Try this out! Enter the following text into a cell in Excel: =1+1. What does JAWS say when you read the contents of this cell now?
Turn on cell edit mode | F2
Format edit combo box | Alt + H, then N
Announces the formula | Insert + Ctrl + F2
Working with Worksheets
We can use new worksheets to create related tables and figures. For example, a workbook called “Budget” might have two worksheets: Income and Expenses. Excel is a flexible program, and you can use it in whatever way meets your needs.
Insert a new worksheet | Alt + Shift + F1 or Shift + F11
Move to the next sheet in a workbook | Ctrl + Page Up
Move to the previous sheet in a workbook | Ctrl + Page Down