,microsoft ,excel with a screen reader3 keyboard shortcuts ,a quick reference for using ,excel for ,windows with ,,jaws or ,,nvda1 with ,mac equivalents where they are simple4 ,it covers moving around a sheet1 selecting1 entering data and formulas1 formatting1 rows and columns1 tables and filters1 and setting up header reading4 ,these shortcuts are for ,microsoft ,excel on ,windows "<,microsoft #cfe"> with ,,jaws or ,,nvda4 ,where the ,mac version is different and simple1 it is shown too4 ,in this guide1 ,insert means the ,,jaws key or the ,,nvda key4 ,excel is not a web page1 so you do not need the virtual cursor or browse mode3 both screen readers read each cell as you arrow to it and announce its address1 such as ,b#d1 and the ,control "6 ,alt "6 ,arrow table commands from the web are not needed4 ,some commands take more than one step through the ribbon3 8,alt "6 ,h1 then ,o1 then ,i0 means press ,alt "6 ,h1 let go1 then press ,o and then ,i4 ,shortcuts that use a symbol1 such as ,control "6 ,shift "6 #d1 are for the ,,us ,english keyboard and may differ on other layouts4 ,moving around ,move one cell up1 down1 left or right3 ,the arrow keys ,move to the edge of the current block of data3 ,control "6 an arrow key "<,mac3 ,command "6 an arrow key"> ,move to cell ,a#a1 the start of the sheet3 ,control "6 ,home "<,mac3 ,fn "6 ,control "6 ,left ,arrow"> ,move to the last cell that has been used3 ,control "6 ,end "<,mac3 ,fn "6 ,control "6 ,right ,arrow"> ,move down or up one screen3 ,page ,down or ,page ,up ,move to the next or previous worksheet3 ,control "6 ,page ,down or ,page ,up "<,mac3 ,option "6 ,right ,arrow or ,left ,arrow"> ,open ,go ,to1 then type a cell address such as ,c#aj or a range name3 ,f#e or ,control "6 ,g ,move to the next cell in the row1 or back to the previous one3 ,tab or ,shift "6 ,tab ,finish the cell and move down to the next row1 or back up3 ,enter or ,shift "6 ,enter ,selecting ,extend the selection by one cell3 ,shift "6 an arrow key ,extend the selection to the edge of the data3 ,control "6 ,shift "6 an arrow key ,select the whole column3 ,control "6 ,space ,select the whole row3 ,shift "6 ,space ,select the current block of data2 press again for the whole sheet3 ,control "6 ,a "<,mac3 ,command "6 ,a"> ,entering and editing ,edit the cell you are on without clearing it3 ,f#b "<,mac3 ,control "6 ,u"> ,cancel what you are typing and keep the old contents3 ,escape ,start a new line inside the same cell3 ,alt "6 ,enter ,fill every selected cell with what you have typed3 ,control "6 ,enter ,copy the cell above into the selected cells "3 ,control "6 ,d ,copy the cell on the left into the selected cells "3 ,control "6 ,r ,clear the contents of the selected cells3 ,delete ,enter today's date3 ,control "6 ,semicolon ,enter the current time3 ,control "6 ,shift "6 ,semicolon ,undo or redo3 ,control "6 ,z or ,control "6 ,y "<,mac3 ,command "6 ,z or ,command "6 ,y"> ,formulas ,start a formula3 ,equals ,add up the numbers above or to the left "<,auto,sum">3 ,alt "6 ,equals "<,mac3 ,command "6 ,shift "6 ,t"> ,switch a cell reference between relative and absolute while editing1 for example ,a#a to `s,a`s#a3 ,f#d "<,mac3 ,command "6 ,t"> ,open the ,insert ,function dialog3 ,shift "6 ,f#c ,show formulas instead of results on the sheet1 or show results again3 ,control "6 ,grave " ,recalculate all open workbooks3 ,f#i ,formatting ,make the selection bold1 italic or underlined3 ,control "6 ,b1 ,control "6 ,i or ,control "6 ,u "<,command on the ,mac"> ,open the ,format ,cells dialog3 ,control "6 #a "<,mac3 ,command "6 #a"> ,apply currency format with two decimal places3 ,control "6 ,shift "6 #d " ,apply percentage format with no decimal places3 ,control "6 ,shift "6 #e " ,apply number format with two decimal places and a thousands separator3 ,control "6 ,shift "6 #a ,apply date format with the day1 month and year3 ,control "6 ,shift "6 #c " ,make the column as wide as its longest entry "<,auto,fit">3 ,alt "6 ,h1 then ,o1 then ,i ,rows1 columns and sheets ,insert cells1 rows or columns "3 ,control "6 ,shift "6 ,plus ,delete the selected cells1 rows or columns3 ,control "6 ,minus ,hide the selected rows or columns3 ,control "6 #i or ,control "6 #j ,unhide the rows or columns inside the selection "<,control "6 ,shift "6 #j does not work on every keyboard2 use the ribbon instead">3 ,control "6 ,shift "6 #i or ,control "6 ,shift "6 #j ,insert a new worksheet3 ,shift "6 ,f#aa ,rename the current worksheet3 ,alt "6 ,h1 then ,o1 then ,r ,open the context menu for the selected cells3 ,shift "6 ,f#aj or the ,applications key ,tables and filters ,turn the current block of data into a table with filter buttons3 ,control "6 ,t ,turn filter buttons on or off for the header row3 ,control "6 ,shift "6 ,l ,open the filter and sort menu for the column you are on "3 ,alt "6 ,down ,arrow ,move through the filter menu and check or uncheck items3 ,tab1 the arrow keys and ,space ,screen reader settings and reading ,if your sheet has a header row or a header column1 tell the screen reader where it is and it will read the header before each cell as you move4 ,go to the cell where the header row and header column meet1 usually ,a#a1 then press the keys for your screen reader4 ,,nvda clears the setting if you press the same keys again4 ,hear the current cell again1 with its address3 ,insert "6 ,tab ,set the column headers row "<,,jaws">3 ,insert "6 ,control "6 ,alt "6 ,c ,set the row headers column "<,,jaws">3 ,insert "6 ,control "6 ,alt "6 ,r ,set the column headers row "<,,nvda">3 ,insert "6 ,shift "6 ,c ,set the row headers column "<,,nvda">3 ,insert "6 ,shift "6 ,r ,hear the font1 color and number format of the cell3 ,insert "6 ,f ,tip3 defining the header row and column takes a few seconds and makes a long sheet much easier to follow1 because every cell is read as 8,total1 ,march1 #dej0 instead of just 8#dej04 ,for the full list of ,excel shortcuts1 press ,alt "6 ,q1 type 8keyboard shortcuts0 and choose the help article4 ,from ,full ,circle ,,at1 fullcircleat4com4 ,call or text #gab-#bej-#gbja1 or email amena4thomas`afullcircleat4com4