The Number Format menu opens. Swipe right until you hear the format you want such as Currency , Time , or Percentage , and double-tap the screen to select. On the worksheet, drag your finger around the screen to find the cell where you want to display the result of the formula.
An Excel formula always starts with the equal sign. When you have typed the equal sign, type a combination of cell references like B4 or D6 and math operators.
Excel runs the calculation and inserts the result to the selected cell. Excel automatically saves your work if you're signed in, but you can change the name of the file and select the save location, for example, to save a copy to your phone. The Save as page opens. The focus is on the file name text field.
Double-tap the screen. Use the on-screen keyboard to type the new file name. Swipe left until you hear the location where to save your file.
If you want to save the file to your phone, swipe left until you hear "This device," and double-tap the screen. In the location you selected, swipe left or right until you hear the possible folder or other sublocation you want, and then double-tap the screen. To use the default print options, swipe right until you hear "Print, button," and then double-tap the screen. Swipe right until you hear the name of the printer you want, and double-tap the screen to select.
For instructions on how to perform more advanced printing tasks, go to Use a screen reader to print an Excel workbook. Use a screen reader to print an Excel workbook. Use Excel for the web with your keyboard and a screen reader to do basic tasks, such as create a new workbook, edit a workbook, and print your work.
If you use Narrator with the Windows 10 Fall Creators Update, you have to turn off scan mode in order to edit documents, spreadsheets, or presentations with Office for the web. For more information, refer to Turn off virtual or browse mode in screen readers in Windows 10 Fall Creators Update. When you use Excel for the web, we recommend that you use Microsoft Edge as your web browser. Because Excel for the web runs in your web browser, the keyboard shortcuts are different from those in the desktop program.
Open Excel for the web. Switch to Editing mode. Edit your workbook. Use AutoSum to sum your numbers. Create a table from your data. Sort or filter the data in a table. Show calculations of your numbers. Press the Tab key until you hear "Home, button," press the Down arrow key until you hear "Go to Excel, button, off," and then press Enter. Excel for the web opens with the focus on the template for a new blank workbook. You can quickly open a file that you've been working on recently or browse all of your workbooks to find the one you want.
You can also open your workbook in the full desktop version of Excel to access additional options. To open a recent file, press the Tab key or B until you hear "Recently opened, button," and press Enter. Press the Tab key until you hear "Link Excel," followed by the name of the workbook in focus and your username.
To browse the list of recent workbooks, press the Tab key or I. When you find the file you want to open, press Enter. The file opens in Viewing mode. To browse all of your workbooks to find the one you want to open, press the Tab key or B until you hear "All, button," and press Enter. To navigate the list of workbooks, press the Tab key or I. Note: To open another workbook when already working in Excel for the web, you must be in Editing mode. For instructions on how to switch to Editing mode, refer to Switch to Editing mode.
To open a recent workbook, press the Tab key once, press the Up or Down arrow key until you hear the document you want, and then press Enter. To open a document from an online repository, press the Tab key until you hear "Link, View more files," and press Enter.
OneDrive opens. Navigate to the file you want, and then press Enter. The file opens in the Editing mode. If you have the full desktop version of Excel, it gives you many more options when working with your files. It's easy to open the full version from Excel for the web.
You hear: "This site is trying to open Excel. Press the Tab key until you hear "Open button," and then press Enter. The workbook opens in the desktop version of Excel. If you've opened a workbook in Viewing mode, and want to edit the file, you need to switch to Editing mode.
The mode changes to Editing. The app opens and the focus is on a new blank workbook option. This workbook option doesn't contain any predefined formatting. To browse the list of templates on the Excel for the web start page, press the Tab key until you hear the template you want, and then press Enter. To browse for additional templates, press the Tab key until you hear "Link, Access more templates," and press Enter. Press the Tab key until you find the right template, and then press Enter.
Note: To create a new workbook when already working in Excel for the web, you must be in Editing mode. To browse for a template, use the arrow keys to locate the template you want, and then press Enter. To edit your workbook, you need to be in Editing mode. For instructions on how to get to Editing mode, go to Switch to Editing mode.
To move between cells, press the arrow keys. The screen reader announces the cells as you move by their row and column location on the worksheet.
The cell A1 is in the first row of the column A. If the cell has text in it, the screen reader reads the text. To quickly add up the numbers in your sheet, you can use the AutoSum function. Excel for the web adds up the numbers and places the result to the cell you selected. For example, type one of the following:. Excel for the web runs the calculation and shows the result in the cell you selected. You can display different types of numbers in Excel for the web by applying a number format, like Currency , Percentage , or Date.
To select several adjacent cells, press and hold Shift and then use the arrow keys until you've selected the cells you want.
Press the Down arrow key or I until you hear "Number format," and then press Enter. You hear: "Alert, Number format.
Press the Down arrow key until you hear the format you want such as Currency or Date , and then press Enter to select and apply it to your worksheet. You can create a table from your data so that you can, for example, quickly filter or sort the data. Select the cells that you want to include in the table. Use the arrow keys to browse the available table styles. When you hear the style you want, press Enter.
The Format as Table dialog box opens. Press the Tab key until you hear: "My table has headers, checkbox, unchecked. Tip: Use table headers to make your table more accessible for screen reader users.
Screen readers use the header information to understand how to locate table cells. You hear the cell details, followed by "Has a sort and filter drop-down menu. To sort the data, press the Down arrow key or I until you hear "Sort smallest to largest," "Sort largest to smallest," "Sort A to Z," or "Sort Z to A" depending on the type of data in the cells, and then press Enter.
Press the Down arrow key or I to browse the filter options. When you hear an option you want, press Spacebar to select or unselect it. To apply the filter, press the Tab key until you hear "Apply," and then press Enter. The filter menu opens. Press the Down arrow key or I until you hear the option you want and then press Enter. The Custom Filter dialog box opens. Type the values you want and press Enter. To clear a filter, press the Down arrow key until you hear "Clear filter from," followed by the coordinates of the filtered cell, and then press Enter.
For more detailed instructions on how to sort or filter data in a table, refer to Use a screen reader to sort or filter a table in Excel. Type the name of the formula or function you want to use such as sum or average. A list of functions opens and is updated as you type. You hear the first function in the list. Press the Down arrow key until you hear the function you want, and then press the Tab key once to select it.
Type the cell range or other numbers you want to apply the function on, followed by a closing parenthesis , and then press Enter. Excel for the web automatically saves your work, but you can change the location or file name and you can download a copy of the file. The Save As dialog box opens. The focus is on the File Name text field. The focus moves to the File Name text field. The file is downloaded to the Downloads folder on your computer. The print preview of the workbook opens. To print using the default settings, press the Tab key until you hear "Print button," and then press Enter.
Microsoft wants to provide the best possible experience for all our customers. If you have a disability or questions related to accessibility, please contact the Microsoft Disability Answer Desk for technical assistance. The Disability Answer Desk support team is trained in using many popular assistive technologies and can offer assistance in English, Spanish, French, and American Sign Language.
Please go to the Microsoft Disability Answer Desk site to find out the contact details for your region. If you are a government, commercial, or enterprise user, please contact the enterprise Disability Answer Desk.
Office Accessibility. Basic tasks using a screen reader with Excel. Notes: New Microsoft features are released gradually to Microsoft subscribers, so your app might not have these features yet.
Notes: If you use Narrator with the Windows 10 Fall Creators Update, you have to turn off scan mode in order to edit documents, spreadsheets, or presentations with Office for the web. This lets you see only the columns and When trying to install Excel Viewer , I recieved the error, "Windows Installer does not allow patching of managed advertized products.
One or more Download this app from Microsoft Store for Windows 10, Windows 8. A security vulnerability exists in Microsoft Office Excel Viewer that could allow arbitrary code to run when a maliciously modified file is opened This free, powerful spreadsheet app is all you need to make and edit Office Description of the security update for Excel Viewer April 10, Summary.
This security update resolves vulnerabilities in Microsoft Office that Download the latest online Excel Viewer - Office Get the Excel mobile app. Send now. Your message is being sent. Your message has been sent, please check your device shortly. Your message has been sent, please check your email shortly. We're sorry, an error occurred while sending your message. Please try again shortly. Please enter a valid digit phone number. Format: or email address.
That email address is not valid. Please enter your email address in valid format such as name example. How your phone number or email address is used. Microsoft will use your phone number or email address only for this one-time transaction.
Standard SMS rates may apply. Share your workbook with others and always work on the latest version for real-time collaboration to help get work done faster. With Microsoft , work within an Excel file from mobile, desktop, and web. Learn more.
0コメント