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 <tiku...@gmail.com> 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
