On 9/30/12, Syed Imran <[email protected]> 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:[email protected]] On Behalf > Of Zujar Shabbir Kanchwala > Sent: 29 September 2012 21:03 > To: [email protected] > 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 <[email protected]> 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/[email protected]/ >> >> To unsubscribe send a message to >> [email protected] >> 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/[email protected]/ > > To unsubscribe send a message to > [email protected] > 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/[email protected]/ > > To unsubscribe send a message to > [email protected] > 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/[email protected]/ To unsubscribe send a message to [email protected] 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
