Re: [JAWS-Users] Selecting multiple columns or rows in Excel 2007
Wow Brian. I wasn't aware that you could hide and unhide cells in so many ways. I learned Excel from taking a PC course locally here but I guess they couldn't teach us everything. Reese Peachtree Travel Radio http://phx.livewebdj.com/stations/bigshack - Original Message - Hello Greg, I am using Excel 2010 but I think the following information should be relevant to Excel 2007 as well. For answers to frequently asked questions about this list visit: http://www.jaws-users.com/help/
Re: [JAWS-Users] Selecting multiple columns or rows in Excel 2007
Brian, Sorry for not seeing your below post until after I sent mine asking about which version of Excel the commands worked in. Again, thanks for giving us this over view of commands for hiding and unhiding information in Excel. Annette -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 1:50 PM 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/
Re: [JAWS-Users] Selecting multiple columns or rows in Excel 2007
Brian, Will this work in Excel 2007 and Excel 2010? Thanks for posting this. Annette -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 2:23 PM To: jaws-users-list@jaws-users.com Subject: Re: [JAWS-Users] Selecting multiple columns or rows in Excel 2007 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 CTRL+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
Re: [JAWS-Users] Selecting multiple columns or rows in Excel 2007
Dear Brian, Thanks for all the helpful hints. I wasn't aware of those keystrokes. Greg -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 1:23 PM To: jaws-users-list@jaws-users.com Subject: Re: [JAWS-Users] Selecting multiple columns or rows in Excel 2007 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 answer
Re: [JAWS-Users] Selecting multiple columns or rows in Excel 2007
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/
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/
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/
Re: [JAWS-Users] Selecting multiple columns or rows in Excel 2007
Al, Thanks. That works for unhiding one cell at a time but not for a range of cells. Greg -Original Message- From: jaws-users-list-boun...@jaws-users.com [mailto:jaws-users-list-boun...@jaws-users.com] On Behalf Of Alan Robbins Sent: Saturday, September 24, 2011 8:07 AM To: jaws-users-list@jaws-users.com Subject: Re: [JAWS-Users] Selecting multiple columns or rows in Excel 2007 Greg I remember when I was working a trick I did with Excel 2000 was to use ctrl G and then enter a column/row coordinate (i.e. A5). What this accomplishes is it places the cursor in the row and cell of a column I know was hidden. Even though not visible on the screen the cursor would go there and then I would select unhide. This could only unhide one column at a time but you could play with the idea and see if you could modify to meet your needs? Haven't tried in 2010 but most standard commands with the ctrl key have remained consistent so far. The only one I miss and have to find out the new one is in excel 2000 ctrl F2 used to read the formula in a cell and in 2010 that key stroke has a different function. hope this helps Al -Original Message- From: jaws-users-list-boun...@jaws-users.com [mailto:jaws-users-list-boun...@jaws-users.com]On Behalf Of Greg Washington Sent: Friday, September 23, 2011 8:55 PM To: jaws-users-list@jaws-users.com Subject: Re: [JAWS-Users] Selecting multiple columns or rows in Excel 2007 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. -Original Message- From: jaws-users-list-boun...@jaws-users.com [mailto:jaws-users-list-boun...@jaws-users.com] On Behalf Of Reese Sent: Friday, September 23, 2011 7:21 PM To: jaws-users-list@jaws-users.com Subject: Re: [JAWS-Users] Selecting multiple columns or rows in Excel 2007 Hi: Place your cursor in column B then hit SHIFT-right arrow to select both columns B and C. ALT-h O and down arrow to hide/unhide menu and hit spacebar. Highlight unhide columns and enter. Hope this helps. Reese - Original Message - Hello everyone, I am using Jaws 12.0.1170 on a windows 7 64 bit machine. I cannot figure out how to select multiple columns or rows to insert, or unhide. For example if I am on column A and columns b- e are hidden and I want to unhide just column B and C I don't know how to do that. When I use control+left arrow to highlight column A to column E and then hit alt h,o,u and select unhide columns of course I unhide all the columns from B to E, not just B and C. Can anyone tell me how to just unhide the columns I want and not the whole range? 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/
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/
Re: [JAWS-Users] Selecting multiple columns or rows in Excel 2007
Greg I remember when I was working a trick I did with Excel 2000 was to use ctrl G and then enter a column/row coordinate (i.e. A5). What this accomplishes is it places the cursor in the row and cell of a column I know was hidden. Even though not visible on the screen the cursor would go there and then I would select unhide. This could only unhide one column at a time but you could play with the idea and see if you could modify to meet your needs? Haven't tried in 2010 but most standard commands with the ctrl key have remained consistent so far. The only one I miss and have to find out the new one is in excel 2000 ctrl F2 used to read the formula in a cell and in 2010 that key stroke has a different function. hope this helps Al -Original Message- From: jaws-users-list-boun...@jaws-users.com [mailto:jaws-users-list-boun...@jaws-users.com]On Behalf Of Greg Washington Sent: Friday, September 23, 2011 8:55 PM To: jaws-users-list@jaws-users.com Subject: Re: [JAWS-Users] Selecting multiple columns or rows in Excel 2007 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. -Original Message- From: jaws-users-list-boun...@jaws-users.com [mailto:jaws-users-list-boun...@jaws-users.com] On Behalf Of Reese Sent: Friday, September 23, 2011 7:21 PM To: jaws-users-list@jaws-users.com Subject: Re: [JAWS-Users] Selecting multiple columns or rows in Excel 2007 Hi: Place your cursor in column B then hit SHIFT-right arrow to select both columns B and C. ALT-h O and down arrow to hide/unhide menu and hit spacebar. Highlight unhide columns and enter. Hope this helps. Reese - Original Message - Hello everyone, I am using Jaws 12.0.1170 on a windows 7 64 bit machine. I cannot figure out how to select multiple columns or rows to insert, or unhide. For example if I am on column A and columns b- e are hidden and I want to unhide just column B and C I don't know how to do that. When I use control+left arrow to highlight column A to column E and then hit alt h,o,u and select unhide columns of course I unhide all the columns from B to E, not just B and C. Can anyone tell me how to just unhide the columns I want and not the whole range? 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/
Re: [JAWS-Users] Selecting multiple columns or rows in Excel 2007
Try using goto to select o and q. F5 is goto, then o,q I would guess. To unhide a column you are supposed to select the columns on either side of it. If that unhides o, I suppose you could (yuck!) re-hide it. At 07:54 PM 9/23/2011, you wrote: 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. -Original Message- From: jaws-users-list-boun...@jaws-users.com [mailto:jaws-users-list-boun...@jaws-users.com] On Behalf Of Reese Sent: Friday, September 23, 2011 7:21 PM To: jaws-users-list@jaws-users.com Subject: Re: [JAWS-Users] Selecting multiple columns or rows in Excel 2007 Hi: Place your cursor in column B then hit SHIFT-right arrow to select both columns B and C. ALT-h O and down arrow to hide/unhide menu and hit spacebar. Highlight unhide columns and enter. Hope this helps. Reese - Original Message - Hello everyone, I am using Jaws 12.0.1170 on a windows 7 64 bit machine. I cannot figure out how to select multiple columns or rows to insert, or unhide. For example if I am on column A and columns b- e are hidden and I want to unhide just column B and C I don't know how to do that. When I use control+left arrow to highlight column A to column E and then hit alt h,o,u and select unhide columns of course I unhide all the columns from B to E, not just B and C. Can anyone tell me how to just unhide the columns I want and not the whole range? 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/
Re: [JAWS-Users] Selecting multiple columns or rows in Excel 2007
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. -Original Message- From: jaws-users-list-boun...@jaws-users.com [mailto:jaws-users-list-boun...@jaws-users.com] On Behalf Of Reese Sent: Friday, September 23, 2011 7:21 PM To: jaws-users-list@jaws-users.com Subject: Re: [JAWS-Users] Selecting multiple columns or rows in Excel 2007 Hi: Place your cursor in column B then hit SHIFT-right arrow to select both columns B and C. ALT-h O and down arrow to hide/unhide menu and hit spacebar. Highlight unhide columns and enter. Hope this helps. Reese - Original Message - Hello everyone, I am using Jaws 12.0.1170 on a windows 7 64 bit machine. I cannot figure out how to select multiple columns or rows to insert, or unhide. For example if I am on column A and columns b- e are hidden and I want to unhide just column B and C I don't know how to do that. When I use control+left arrow to highlight column A to column E and then hit alt h,o,u and select unhide columns of course I unhide all the columns from B to E, not just B and C. Can anyone tell me how to just unhide the columns I want and not the whole range? 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/
Re: [JAWS-Users] Selecting multiple columns or rows in Excel 2007
Hi: Place your cursor in column B then hit SHIFT-right arrow to select both columns B and C. ALT-h O and down arrow to hide/unhide menu and hit spacebar. Highlight unhide columns and enter. Hope this helps. Reese - Original Message - Hello everyone, I am using Jaws 12.0.1170 on a windows 7 64 bit machine. I cannot figure out how to select multiple columns or rows to insert, or unhide. For example if I am on column A and columns b- e are hidden and I want to unhide just column B and C I don't know how to do that. When I use control+left arrow to highlight column A to column E and then hit alt h,o,u and select unhide columns of course I unhide all the columns from B to E, not just B and C. Can anyone tell me how to just unhide the columns I want and not the whole range? For answers to frequently asked questions about this list visit: http://www.jaws-users.com/help/
Re: [JAWS-Users] Selecting multiple columns or rows in Excel 2007
Justin, Thanks so much. Now how about unhiding rows or columns? Greg -Original Message- From: jaws-users-list-boun...@jaws-users.com [mailto:jaws-users-list-boun...@jaws-users.com] On Behalf Of justin williams Sent: Thursday, September 22, 2011 11:16 PM To: jaws-users-list@jaws-users.com Subject: Re: [JAWS-Users] Selecting multiple columns or rows in Excel 2007 Select as far down or to the right as you want your rows and collumns to go. Press control pc cursor. That will bring up a list box which says insert collumns and rows. Find what you want and then press enter. Also, you can get to it with the applications key, or the right mouse button. -Original Message- From: jaws-users-list-boun...@jaws-users.com [mailto:jaws-users-list-boun...@jaws-users.com] On Behalf Of Greg Washington Sent: Thursday, September 22, 2011 7:53 PM To: jaws-users-list@jaws-users.com Subject: Re: [JAWS-Users] Selecting multiple columns or rows in Excel 2007 Al, First, I'm glad I was able to help you successfully download Office 2010. Yes, I am using Office 2007 using the MS ribbon when unhiding columns. I find that easier than using the Jaws ribbon for that function. If I am on column A and columns b-e are hidden I can unhide all of those hidden columns by using control+right arrow from A to F. However I was wondering if there is a way I could unhide b and c and leave D and E hidden in one step. Likewise I would like to be able to insert more than one column or row at a time. I think I was able to do that in Excel 2003. but I cannot remember how -Original Message- From: Alan Robbins Sent: Thursday, September 22, 2011 6:03 PM To: jaws-users-list@jaws-users.com Subject: Re: [JAWS-Users] Selecting multiple columns or rows in Excel 2007 Greg, First, if I remember, your are using Office 2007, correct? I finally did successfully download a trial version of Office 2010 thanks to your directions. Anyway by your descriptions, you must be using the traditional MS ribbons and not the JAWS ribbon feature, correct? Now to your question. The only way in the past with Office 2000 and in my limited working with Office 2010 I think you have to have cells or columns directly adjacent to what you want to unhide highlighted. Using your example below I think you would have a two step process to accomplish what you want to. Al -Original Message- From: jaws-users-list-boun...@jaws-users.com [mailto:jaws-users-list-boun...@jaws-users.com]On Behalf Of Greg Washington Sent: Thursday, September 22, 2011 4:49 PM To: jaws-users-list@jaws-users.com Subject: [JAWS-Users] Selecting multiple columns or rows in Excel 2007 Hello everyone, I am using Jaws 12.0.1170 on a windows 7 64 bit machine. I cannot figure out how to select multiple columns or rows to insert, or unhide. For example if I am on column A and columns b- e are hidden and I want to unhide just column B and C I don't know how to do that. When I use control+left arrow to highlight column A to column E and then hit alt h,o,u and select unhide columns of course I unhide all the columns from B to E, not just B and C. Can anyone tell me how to just unhide the columns I want and not the whole range? I have similar problems when trying to insert more than one column or row in a excel spreadsheet. I can only do one column or row at a time and not a range of rows or columns. Any help would be greatly appreciated. Thanks, Greg 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/
Re: [JAWS-Users] Selecting multiple columns or rows in Excel 2007
Select as far down or to the right as you want your rows and collumns to go. Press control pc cursor. That will bring up a list box which says insert collumns and rows. Find what you want and then press enter. Also, you can get to it with the applications key, or the right mouse button. -Original Message- From: jaws-users-list-boun...@jaws-users.com [mailto:jaws-users-list-boun...@jaws-users.com] On Behalf Of Greg Washington Sent: Thursday, September 22, 2011 7:53 PM To: jaws-users-list@jaws-users.com Subject: Re: [JAWS-Users] Selecting multiple columns or rows in Excel 2007 Al, First, I'm glad I was able to help you successfully download Office 2010. Yes, I am using Office 2007 using the MS ribbon when unhiding columns. I find that easier than using the Jaws ribbon for that function. If I am on column A and columns b-e are hidden I can unhide all of those hidden columns by using control+right arrow from A to F. However I was wondering if there is a way I could unhide b and c and leave D and E hidden in one step. Likewise I would like to be able to insert more than one column or row at a time. I think I was able to do that in Excel 2003. but I cannot remember how -Original Message- From: Alan Robbins Sent: Thursday, September 22, 2011 6:03 PM To: jaws-users-list@jaws-users.com Subject: Re: [JAWS-Users] Selecting multiple columns or rows in Excel 2007 Greg, First, if I remember, your are using Office 2007, correct? I finally did successfully download a trial version of Office 2010 thanks to your directions. Anyway by your descriptions, you must be using the traditional MS ribbons and not the JAWS ribbon feature, correct? Now to your question. The only way in the past with Office 2000 and in my limited working with Office 2010 I think you have to have cells or columns directly adjacent to what you want to unhide highlighted. Using your example below I think you would have a two step process to accomplish what you want to. Al -Original Message- From: jaws-users-list-boun...@jaws-users.com [mailto:jaws-users-list-boun...@jaws-users.com]On Behalf Of Greg Washington Sent: Thursday, September 22, 2011 4:49 PM To: jaws-users-list@jaws-users.com Subject: [JAWS-Users] Selecting multiple columns or rows in Excel 2007 Hello everyone, I am using Jaws 12.0.1170 on a windows 7 64 bit machine. I cannot figure out how to select multiple columns or rows to insert, or unhide. For example if I am on column A and columns b- e are hidden and I want to unhide just column B and C I don't know how to do that. When I use control+left arrow to highlight column A to column E and then hit alt h,o,u and select unhide columns of course I unhide all the columns from B to E, not just B and C. Can anyone tell me how to just unhide the columns I want and not the whole range? I have similar problems when trying to insert more than one column or row in a excel spreadsheet. I can only do one column or row at a time and not a range of rows or columns. Any help would be greatly appreciated. Thanks, Greg 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/
Re: [JAWS-Users] Selecting multiple columns or rows in Excel 2007
Al, First, I'm glad I was able to help you successfully download Office 2010. Yes, I am using Office 2007 using the MS ribbon when unhiding columns. I find that easier than using the Jaws ribbon for that function. If I am on column A and columns b-e are hidden I can unhide all of those hidden columns by using control+right arrow from A to F. However I was wondering if there is a way I could unhide b and c and leave D and E hidden in one step. Likewise I would like to be able to insert more than one column or row at a time. I think I was able to do that in Excel 2003. but I cannot remember how -Original Message- From: Alan Robbins Sent: Thursday, September 22, 2011 6:03 PM To: jaws-users-list@jaws-users.com Subject: Re: [JAWS-Users] Selecting multiple columns or rows in Excel 2007 Greg, First, if I remember, your are using Office 2007, correct? I finally did successfully download a trial version of Office 2010 thanks to your directions. Anyway by your descriptions, you must be using the traditional MS ribbons and not the JAWS ribbon feature, correct? Now to your question. The only way in the past with Office 2000 and in my limited working with Office 2010 I think you have to have cells or columns directly adjacent to what you want to unhide highlighted. Using your example below I think you would have a two step process to accomplish what you want to. Al -Original Message- From: jaws-users-list-boun...@jaws-users.com [mailto:jaws-users-list-boun...@jaws-users.com]On Behalf Of Greg Washington Sent: Thursday, September 22, 2011 4:49 PM To: jaws-users-list@jaws-users.com Subject: [JAWS-Users] Selecting multiple columns or rows in Excel 2007 Hello everyone, I am using Jaws 12.0.1170 on a windows 7 64 bit machine. I cannot figure out how to select multiple columns or rows to insert, or unhide. For example if I am on column A and columns b- e are hidden and I want to unhide just column B and C I don't know how to do that. When I use control+left arrow to highlight column A to column E and then hit alt h,o,u and select unhide columns of course I unhide all the columns from B to E, not just B and C. Can anyone tell me how to just unhide the columns I want and not the whole range? I have similar problems when trying to insert more than one column or row in a excel spreadsheet. I can only do one column or row at a time and not a range of rows or columns. Any help would be greatly appreciated. Thanks, Greg 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/
Re: [JAWS-Users] Selecting multiple columns or rows in Excel 2007
Greg, First, if I remember, your are using Office 2007, correct? I finally did successfully download a trial version of Office 2010 thanks to your directions. Anyway by your descriptions, you must be using the traditional MS ribbons and not the JAWS ribbon feature, correct? Now to your question. The only way in the past with Office 2000 and in my limited working with Office 2010 I think you have to have cells or columns directly adjacent to what you want to unhide highlighted. Using your example below I think you would have a two step process to accomplish what you want to. Al -Original Message- From: jaws-users-list-boun...@jaws-users.com [mailto:jaws-users-list-boun...@jaws-users.com]On Behalf Of Greg Washington Sent: Thursday, September 22, 2011 4:49 PM To: jaws-users-list@jaws-users.com Subject: [JAWS-Users] Selecting multiple columns or rows in Excel 2007 Hello everyone, I am using Jaws 12.0.1170 on a windows 7 64 bit machine. I cannot figure out how to select multiple columns or rows to insert, or unhide. For example if I am on column A and columns b- e are hidden and I want to unhide just column B and C I don't know how to do that. When I use control+left arrow to highlight column A to column E and then hit alt h,o,u and select unhide columns of course I unhide all the columns from B to E, not just B and C. Can anyone tell me how to just unhide the columns I want and not the whole range? I have similar problems when trying to insert more than one column or row in a excel spreadsheet. I can only do one column or row at a time and not a range of rows or columns. Any help would be greatly appreciated. Thanks, Greg 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/
[JAWS-Users] Selecting multiple columns or rows in Excel 2007
Hello everyone, I am using Jaws 12.0.1170 on a windows 7 64 bit machine. I cannot figure out how to select multiple columns or rows to insert, or unhide. For example if I am on column A and columns b- e are hidden and I want to unhide just column B and C I don't know how to do that. When I use control+left arrow to highlight column A to column E and then hit alt h,o,u and select unhide columns of course I unhide all the columns from B to E, not just B and C. Can anyone tell me how to just unhide the columns I want and not the whole range? I have similar problems when trying to insert more than one column or row in a excel spreadsheet. I can only do one column or row at a time and not a range of rows or columns. Any help would be greatly appreciated. Thanks, Greg For answers to frequently asked questions about this list visit: http://www.jaws-users.com/help/