You can create a macro which will carry out all these commands with just one command which you can apply as a keyboard shortcut or an icon or a menu item. For example you may regularly want to add your name as a footer on a spreadsheet page and make the print fit to one page and perhaps vertically and horizontally center it. Creating a macro for repetitive commands in Excel using JawsĪ macro is either a shortcut for a series of commands which you may do on a regular basis. Place cursor in either the left, center or right section and type any of the following codes. Control Shift $.Īpply number format with2 decimal places. Formatting.Īpply currency with 2 decimal places. Select cells first including start of series, then menu option Edit, select Fill, select Series, then Alt F for Autofill option, press Enter. Select cells first including formula then Ctrl R.įill a Series, date, sequence. Select cells first including formula then Ctrl D.įill across a formula. Select row, application key, select delete. Select column, application, select delete.ĭelete a row. Select column to left, application key, select insert.ĭelete a column. Select row below, application key, select insert. Select cells to be filled then Control + R. ![]() Select cells to be filled then Control + D.įill Right. F5 key then enter cell reference.Įnter data and move to next cell. ![]() Format Menu, Sheet, Rename, type new name, Enter. Excel Spreadsheets Shortcuts and Instructions for Jaws Screen Reader
0 Comments
Leave a Reply. |