When printing out my table will the columns and rows print as well? Kathy
-----Original Message----- From: jaws-users-list-boun...@jaws-users.com [mailto:jaws-users-list-boun...@jaws-users.com] On Behalf Of Brian Lee Sent: Saturday, August 20, 2011 10:33 PM To: jaws-users-list@jaws-users.com Subject: Re: [JAWS-Users] EXCEL 2007 Kathy, I notice that the link in my last message extended to a second line. If you select both lines and copy the link to the clipboard, you can then paste it in your browser's address bar. You should go to the right site by using the link from the address bar of the browser. Take care. Brian Lee brianl...@charter.net -----Original Message----- From: jaws-users-list-boun...@jaws-users.com [mailto:jaws-users-list-boun...@jaws-users.com] On Behalf Of Brian Lee Sent: Saturday, August 20, 2011 7:13 PM To: jaws-users-list@jaws-users.com Subject: Re: [JAWS-Users] EXCEL 2007 Hello Kathy, Either Excel or Word can be used, whatever you are most comfortable with using. In either case, you might need to work a little with such things as column width, row height, line spacing, printing portrait or landscape, etc. You want to allow enough room for people to write what is needed, so Shari's tip about the double spacing for rows is a good one. There are other things to consider in thinking about the spacing such as how many points is Word using after each paragraph mark, font size and appearance and so forth. As far as I know, Microsoft doesn't have an upgrade pricing schedule for people wanting to upgrade to Office 2010 from Office 2007. I certainly am not sure of that though. Here is a link for Office 2010 pricing. http://office.microsoft.com/en-us/buy/office-2010-pricing-information-HA1018 10737.aspx?CTT=5&origin=HA101674631 Feel free to write me off list if you think I can help you any more with your project. Take care. Brian Lee brianl...@charter.net -----Original Message----- From: jaws-users-list-boun...@jaws-users.com [mailto:jaws-users-list-boun...@jaws-users.com] On Behalf Of Kathy Pingstock Sent: Saturday, August 20, 2011 7:04 AM To: jaws-users-list@jaws-users.com Subject: Re: [JAWS-Users] EXCEL 2007 Brian, Thank you for this. Can you tell me I want to create a sign in sheet for church. I am going to use 4 or 5 columns can excel work for this or is it better to use a table in word. Do you know what is would cost for me to upgrade from 2007 to 2010. Thanks Kathy -----Original Message----- From: jaws-users-list-boun...@jaws-users.com [mailto:jaws-users-list-boun...@jaws-users.com] On Behalf Of Brian Lee Sent: Friday, August 19, 2011 11:13 PM To: jaws-users-list@jaws-users.com Subject: Re: [JAWS-Users] EXCEL 2007 Hello Kathy, I don't have Excel 2007. I am using Excel 2010. There might definitely be some differences between the accessing of header and footer information, but I thought I would send you steps that work in Excel 2010 and you can check to see if the process is similar in Excel 2007. In the following steps, I get to the dialog box to use by going into sheet options under the page layout tab of the ribbon. If I remember correctly, you might need to go under page layout tab and find the button for launching the page setup dialog box. If you bring up the page layout dialog then you can go to the header/footer tab and follow the steps quite similarly from that point. After I show the steps used in Excel 2010, I am going to include another method that might also work in Excel 2007. First method: 1. In Excel 2010, use Alt followed by P followed by S followed by O to bring up the sheet options. In Excel 2007, you might need to go under page layout tab and find the button for Page Setup. Use spacebar on that button. 2. Use CTRL+tab key until the Header/Footer tab is reached. 3. If you tab across this page of the dialog box, you will find two combo boxes from which you can choose a built-in header or footer. Use up or down arrow key in those boxes to make your choice. 4. As you tab in this page of the dialog, you will find buttons for setting up a customized header or footer. Press spacebar to use the appropriate choice. 5. If you choose the button for creating a customized header, use tab key across the dialog box that results after using spacebar on the button. You will find a left, center and right section that can be filled in with text you want to include or with available field codes in the dialog box. 6. Fill in the information you want used in the appropriate location. You can use Alt+L to move into the left section, Alt+R to move into the right section, and Alt+C to move into the middle section. 7. With focus in the left, center or right sections, you can use Alt+U to insert the code for current page, Alt+T to insert the code for pages, Alt+D to insert a code for the date, Alt+M to insert a code for the Alt+time, P to insert the path and file name, Alt+E to insert just the Alt+file name, and Alt+A to insert a tab. You can also press Alt+F to bring up the font dialog box if you want to change the font or font attributes. When focus is in any of the three sections, you can press Alt+I to bring up the Insert Picture dialog box if you want to insert a picture. 8. Tab to OK and press enter key to close the header or footer dialog box and return to the page setup box. 9. If you want to use a different first page then tab to the checkbox and check it by using spacebar. You can tab and make other choices in this dialog box as well. 10. Tab to OK and press enter key to complete the process. Second method: I think the following will also work in Excel 2007. 1. Press function key 6 until the status bar is reached. 2. Use right arrow key across the status bar until the Page Layout button is found and press spacebar. This changes the view to page layout. 3. Press F6 until back in the main part of the worksheet and move focus to cell A1. 4. Route JAWS cursor to PC cursor and use up arrow key until you hear JAWS say something like "click to add header" or "click to add footer." 5. Press the home key and check to see if focus is on the letter C of the word "click." Do a single left mouse button click on that character. 6. Focus will move to the middle of three sections that a person gets when creating a custom header through the page layout dialog box. Read the current position of the cursor by using Alt+delete, and it should be on pixel 466 if using Excel 2010 defaults or something similar in Excel 2007. If you tab and check the position, it should be at 800 and something or close to that pixel range. If you shift+tab from the middle position, the cursor will go to 100 and some pixels. The point is that there are three sections, one on the left, one in the middle and one on the right for the header. 7. You can type what you want in any of those sections. 8. The header or footer design tab will also be added to the ribbon. Use Alt key and find the design tab. Use tab key to move to choices on the lower part of the ribbon for designing the header or footer. You will have similar options as those mentioned above, such as starting on a different page one, adding codes for page number, total pages, etc. 9. When done working with the three sections of the header, use the escape key to move back to the main working area of the spreadsheet. 10. With focus in cell A1, you can route JAWS to PC and use up arrow to find the information you added as a header. Put PC cursor back on if you do that check. 11. If you want to work in normal view, press F6 to move to the status bar, use right or left arrow key to find the button for the normal view and press spacebar on it. 12. Use F6 until back in the spreadsheet. Take care. Brian Lee brianl...@charter.net -----Original Message----- From: jaws-users-list-boun...@jaws-users.com [mailto:jaws-users-list-boun...@jaws-users.com] On Behalf Of Kathy Pingstock Sent: Friday, August 19, 2011 5:38 AM To: jaws-users-list@jaws-users.com Subject: [JAWS-Users] EXCEL 2007 Can anyone tell me how to do a header in excel 2007? Thanks Kathy For answers to frequently asked questions about this list visit: http://www.jaws-users.com/help/ For answers to frequently asked questions about this list visit: http://www.jaws-users.com/help/ For answers to frequently asked questions about this list visit: http://www.jaws-users.com/help/ For answers to frequently asked questions about this list visit: http://www.jaws-users.com/help/ For answers to frequently asked questions about this list visit: http://www.jaws-users.com/help/ For answers to frequently asked questions about this list visit: http://www.jaws-users.com/help/
