Greg, I should also mention that if you do not use merged cells, you can select non contiguously and hide individual rows or columns. For example, if you want to hide row 10 and row 20, and if your data goes from column A to G, you could use the Go To box. Press CTRL+G to bring up the Go To box. Type in A10:g10,a20:g20 and press enter key. You can then hide those rows using CTRL+9 or unhide them using CTRL+Shift+9. JAWS might not announce it but there is a comma between the ranges I just used. Similarly, you could hide and show hidden columns. For example, if you want to hide columns b and e, you could use the Go To box and type in b:b,e:e and press enter key to select the ranges. You would then use CTRL+0 to hide the columns or Shift+CTRL+0 to show the columns. (Again, there is a comma between the ranges I specified). This method doesn't work correctly though if you are using merged cells in any of the rows or columns you want to hide or show.
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, September 24, 2011 10:50 AM To: jaws-users-list@jaws-users.com Subject: Re: [JAWS-Users] Selecting multiple columns or rows in Excel 2007 Hello Greg, I am using Excel 2010 but I think the following information should be relevant to Excel 2007 as well. To hide a single column simply have the cursor in the column to hide and use CTRL+0. To hide a single row place the cursor in the row and use CTRL+9. To make a single column not hidden use shift with right or left arrow keys to select the columns to the left and right of the hidden column and then use Shift+CTRL+0. To make a row not hidden use shift+up or down arrow key to select the row above or row blow the hidden row and use CTRL+Shift+9. To hide multiple columns going right, use shift with right arrow key to select the columns to hide and then use CTRL+0. To hide multiple columns to the left, use shift with left arrow key to select the desired columns and then use CTRL+0. To unhide the multiple columns use shift with right or left arrow key to select the columns to show (starting on one that is not hidden) and then use ShiftCTRL+0. To hide multiple rows, use shift with down arrow or up arrow key to select the rows to be hidden and then use CTRL+9. To show the rows again, use Shift with up or down arrow key (selecting the row above and row below the hidden rows) and use shift+CTRL+9 to show the rows. If the cursor is in a column on the left and you cannot use shift with left arrow to select hidden columns to the left, you can select the whole row by using shift+spacebar and then use CTRL+Shift+0 to make all columns visible. If you have hidden rows then you can use CTRL+spacebar to select a whole column and use CTRL+shift+9 to make the whole row visible. The above will work for contiguous rows or columns, but you might need a macro to handle noncontiguous rows or columns. 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 Greg Washington Sent: Saturday, September 24, 2011 8:27 AM To: jaws-users-list@jaws-users.com Subject: Re: [JAWS-Users] Selecting multiple columns or rows in Excel 2007 Reese, Thanks. I am still trying to find a way to unhide a range of columns at one time. I will google it and see what I find. It's probably a Excel 2007 and not a Jaws issue. Greg -----Original Message----- From: jaws-users-list-boun...@jaws-users.com [mailto:jaws-users-list-boun...@jaws-users.com] On Behalf Of Reese Sent: Saturday, September 24, 2011 10:10 AM To: jaws-users-list@jaws-users.com Subject: Re: [JAWS-Users] Selecting multiple columns or rows in Excel 2007 Place your cursor on column P. ALT-h O and down arrow to hide/unhide menu and hit spacebar. Highlight unhide columns and enter. Only column P will be unhidden. Reese ----- Original Message ----- My problem is that I have multiple columns hidden in a spread sheet, for example columns B to p. So I want to unhide only column p. How do I do that? When I am on column q and hit shift left arrow and select unhide columns from the menu it unhides all the columns b-p. the same happens if when on column A and I hit shift right arrow and then select unhide columns all the columns from b to p get unhidden. 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/
