Re: [AI] How to select more then 1 column and row simultaneously in an Excel sheet
On 9/30/12, Syed Imran wrote: > Hi Zujar > > I figured out how we can move through the hidden / unfiltered cells using > the arrow keys, although be it little tedious for some. You can use control > + alt + arrow keys. This will not announce the cell coordinates, but Jaws > will read the content. Besides, you can press insert + C to know the > coordinates whenever you like. > > -Original Message- > From: AccessIndia [mailto:accessindia-boun...@accessindia.org.in] On Behalf > Of Zujar Shabbir Kanchwala > Sent: 29 September 2012 21:03 > To: accessindia@accessindia.org.in > Subject: Re: [AI] How to select more then 1 column and row simultaneously > in > an Excel sheet > > select a cell from each column and press CTRL+SPACEBAR to select these > columns. Now press APPLICATION key and select Hide/Unhide. see example > below: > > To hide columns: > 1. Place the cursor on cell C1. > 2. Press RIGHT ARROW twice to select cells D1 and E1. > 3. Press CTRL+SPACEBAR to select columns C, D and E. > 4. Press APPLICATION key and select Hide or press CTRL+0. > > To Unhide columns: > 1. Press CTRL+G to open GoTo dialog box. > 2. Enter C1:E1 and press ENTER. > 3. Press CTRL+SPACEBAR to select columns C, D and E. > 4. Press APPLICATION key and select Unhide. > > Note that you need to select cells in a different way when they are hidden > as the cursor cannot be positioned on hidden cells using ARROW keys or the > TAB key. You can use the CTRL+G method to select cells irrespective of > whether they are visible or hiddden. > > hope it helps... > > On 9/29/12, tiku raj wrote: >> hello Friends, >> >> how to select more then 1 column and row simultaneously in an Excel >> sheet. >> >> And If I want to hide the data of column d, for some time I am abable >> to do it, but I am not able to select column C to E to unhide the same >> data. >> >> Please respond this query step by step first to hide the data and >> again to unhide the same data. >> >> Regards, >> >> Tiku >> >> I am using Windows 7 Ultimate and Excel 2007. >> >> >> Search for old postings at: >> http://www.mail-archive.com/accessindia@accessindia.org.in/ >> >> To unsubscribe send a message to >> accessindia-requ...@accessindia.org.in >> with the subject unsubscribe. >> >> To change your subscription to digest mode or make any other changes, >> please visit the list home page at >> http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org >> .in >> >> > > > -- > Best Regards, > Zujar... > > An optimist laughs to forget, whereas a pessimist forgets to laugh! > > > Search for old postings at: > http://www.mail-archive.com/accessindia@accessindia.org.in/ > > To unsubscribe send a message to > accessindia-requ...@accessindia.org.in > with the subject unsubscribe. > > To change your subscription to digest mode or make any other changes, > please > visit the list home page at > http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in > > > > Search for old postings at: > http://www.mail-archive.com/accessindia@accessindia.org.in/ > > To unsubscribe send a message to > accessindia-requ...@accessindia.org.in > with the subject unsubscribe. > > To change your subscription to digest mode or make any other changes, please > visit the list home page at > http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in > > Thank you folks, it is working. Search for old postings at: http://www.mail-archive.com/accessindia@accessindia.org.in/ To unsubscribe send a message to accessindia-requ...@accessindia.org.in with the subject unsubscribe. To change your subscription to digest mode or make any other changes, please visit the list home page at http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in
Re: [AI] How to select more then 1 column and row simultaneously in an Excel sheet
wow, that's so simple. Thanks for sharing! -- Regards, Zujar... An optimist laughs to forget, whereas a pessimist forgets to laugh! -Original Message- From: AccessIndia [mailto:accessindia-boun...@accessindia.org.in] On Behalf Of Syed Imran Sent: Sunday, September 30, 2012 6:21 AM To: accessindia@accessindia.org.in Subject: Re: [AI] How to select more then 1 column and row simultaneously in an Excel sheet Hi Zujar I figured out how we can move through the hidden / unfiltered cells using the arrow keys, although be it little tedious for some. You can use control + alt + arrow keys. This will not announce the cell coordinates, but + Jaws will read the content. Besides, you can press insert + C to know the coordinates whenever you like. -Original Message- From: AccessIndia [mailto:accessindia-boun...@accessindia.org.in] On Behalf Of Zujar Shabbir Kanchwala Sent: 29 September 2012 21:03 To: accessindia@accessindia.org.in Subject: Re: [AI] How to select more then 1 column and row simultaneously in an Excel sheet select a cell from each column and press CTRL+SPACEBAR to select these columns. Now press APPLICATION key and select Hide/Unhide. see example below: To hide columns: 1. Place the cursor on cell C1. 2. Press RIGHT ARROW twice to select cells D1 and E1. 3. Press CTRL+SPACEBAR to select columns C, D and E. 4. Press APPLICATION key and select Hide or press CTRL+0. To Unhide columns: 1. Press CTRL+G to open GoTo dialog box. 2. Enter C1:E1 and press ENTER. 3. Press CTRL+SPACEBAR to select columns C, D and E. 4. Press APPLICATION key and select Unhide. Note that you need to select cells in a different way when they are hidden as the cursor cannot be positioned on hidden cells using ARROW keys or the TAB key. You can use the CTRL+G method to select cells irrespective of whether they are visible or hiddden. hope it helps... On 9/29/12, tiku raj wrote: > hello Friends, > > how to select more then 1 column and row simultaneously in an Excel sheet. > > And If I want to hide the data of column d, for some time I am abable > to do it, but I am not able to select column C to E to unhide the same > data. > > Please respond this query step by step first to hide the data and > again to unhide the same data. > > Regards, > > Tiku > > I am using Windows 7 Ultimate and Excel 2007. > > > Search for old postings at: > http://www.mail-archive.com/accessindia@accessindia.org.in/ > > To unsubscribe send a message to > accessindia-requ...@accessindia.org.in > with the subject unsubscribe. > > To change your subscription to digest mode or make any other changes, > please visit the list home page at > http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org > .in > > -- Best Regards, Zujar... An optimist laughs to forget, whereas a pessimist forgets to laugh! Search for old postings at: http://www.mail-archive.com/accessindia@accessindia.org.in/ To unsubscribe send a message to accessindia-requ...@accessindia.org.in with the subject unsubscribe. To change your subscription to digest mode or make any other changes, please visit the list home page at http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in Search for old postings at: http://www.mail-archive.com/accessindia@accessindia.org.in/ To unsubscribe send a message to accessindia-requ...@accessindia.org.in with the subject unsubscribe. To change your subscription to digest mode or make any other changes, please visit the list home page at http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in Search for old postings at: http://www.mail-archive.com/accessindia@accessindia.org.in/ To unsubscribe send a message to accessindia-requ...@accessindia.org.in with the subject unsubscribe. To change your subscription to digest mode or make any other changes, please visit the list home page at http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in
Re: [AI] How to select more then 1 column and row simultaneously in an Excel sheet
Hi Zujar I figured out how we can move through the hidden / unfiltered cells using the arrow keys, although be it little tedious for some. You can use control + alt + arrow keys. This will not announce the cell coordinates, but Jaws will read the content. Besides, you can press insert + C to know the coordinates whenever you like. -Original Message- From: AccessIndia [mailto:accessindia-boun...@accessindia.org.in] On Behalf Of Zujar Shabbir Kanchwala Sent: 29 September 2012 21:03 To: accessindia@accessindia.org.in Subject: Re: [AI] How to select more then 1 column and row simultaneously in an Excel sheet select a cell from each column and press CTRL+SPACEBAR to select these columns. Now press APPLICATION key and select Hide/Unhide. see example below: To hide columns: 1. Place the cursor on cell C1. 2. Press RIGHT ARROW twice to select cells D1 and E1. 3. Press CTRL+SPACEBAR to select columns C, D and E. 4. Press APPLICATION key and select Hide or press CTRL+0. To Unhide columns: 1. Press CTRL+G to open GoTo dialog box. 2. Enter C1:E1 and press ENTER. 3. Press CTRL+SPACEBAR to select columns C, D and E. 4. Press APPLICATION key and select Unhide. Note that you need to select cells in a different way when they are hidden as the cursor cannot be positioned on hidden cells using ARROW keys or the TAB key. You can use the CTRL+G method to select cells irrespective of whether they are visible or hiddden. hope it helps... On 9/29/12, tiku raj wrote: > hello Friends, > > how to select more then 1 column and row simultaneously in an Excel sheet. > > And If I want to hide the data of column d, for some time I am abable > to do it, but I am not able to select column C to E to unhide the same > data. > > Please respond this query step by step first to hide the data and > again to unhide the same data. > > Regards, > > Tiku > > I am using Windows 7 Ultimate and Excel 2007. > > > Search for old postings at: > http://www.mail-archive.com/accessindia@accessindia.org.in/ > > To unsubscribe send a message to > accessindia-requ...@accessindia.org.in > with the subject unsubscribe. > > To change your subscription to digest mode or make any other changes, > please visit the list home page at > http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org > .in > > -- Best Regards, Zujar... An optimist laughs to forget, whereas a pessimist forgets to laugh! Search for old postings at: http://www.mail-archive.com/accessindia@accessindia.org.in/ To unsubscribe send a message to accessindia-requ...@accessindia.org.in with the subject unsubscribe. To change your subscription to digest mode or make any other changes, please visit the list home page at http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in Search for old postings at: http://www.mail-archive.com/accessindia@accessindia.org.in/ To unsubscribe send a message to accessindia-requ...@accessindia.org.in with the subject unsubscribe. To change your subscription to digest mode or make any other changes, please visit the list home page at http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in