If you like to select non-adjacent cells / rows / columns, make your first selection and then press shift + f8, after that move to the cells you want to include in your selection and then use the appropriate selection keys. For example, let's say I have already selected column A by pressing control + space and I want to select column M and then column T and column AE. Having already selected the column A, I press shift + f8 to turn on the add selected range mode, after that using either the arrow keys or the go to reference option I move to m1, and then press control space, then move to t1 and press control space again, then move to AE 1 and press control + space.
-----Original Message----- From: AccessIndia [mailto:accessindia-boun...@accessindia.org.in] On Behalf Of Mukesh Sent: 29 September 2012 21:05 To: accessindia@accessindia.org.in Subject: Re: [AI] How to select more then 1 column and row simultaneously in anExcel sheet Go to cell c1 and then press shift key, press right arrow key twice till the cursor come in e1. Press ctrl + space bar which will select columns from c, d, e at a time. done! Regards Mukesh Baviskar Mobile: 9403161157 -------------------------------------------------- From: "tiku raj" <tiku...@gmail.com> Sent: Saturday, September 29, 2012 8:21 PM To: "accessindia" <accessindia@accessindia.org.in > Subject: [AI] How to select more then 1 column and row simultaneously in anExcel sheet > 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 > 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
