Hi Thanx the work has been done
On 12/18/11, Pranay Gadodia <pranaygado...@gmail.com> wrote: > Hi Kiran, > > If the order of the data written in column A is not important, you may use > the Data > Sort. It would arrange all the data items in ascending or > descending order in consecutive cells, that means seperate blank rows from > non-blank rows. > > And if the original order of the data items has to be preserved, then > 1. fill in the column B with serial number using the Edit > Fill > Series to > your last row. > 2. Then sort the data taking data range as both column A and B, and keeping > column A in the 'sort by' field. > 3. The whole data in this case too will get arranged with column A data > items in ascending or descending order in consecutive rows. Then select this > aggregated data both in column A and B, and now sort it on column B in > ascending order. > 4. Your column A would have the data items in original order without blank > rows. > > HTH, > > Pranay. > > ----- Original Message ----- > From: "Kiran Baug" <kiranbaug2...@gmail.com> > To: <accessindia@accessindia.org.in> > Sent: Saturday, December 17, 2011 11:46 PM > Subject: Re: [AI] Fwd: Need help in MS excel 2003 > > > Hi all > > i am updating data and creating new data from old data and it is huge > amount of data > > The data in columA starts from A1 and goes till A39 lakhs cell number > and there is lots of blanks between A1 to A39 lakhs in colum and i > want to remove that all blanks cells in between of colum A 1 to A 39 > lakhs > > and doing manually is quite time consuming > > I am looking out for shortcut that by selecting the whole colum a data > and deleting the blank cells in between the Cell 1 to 39 lakhs > > I hope i am able to make you all understand now > > Thanking you all, > Kiran Baug > > On 12/17/11, Umesha Economics <umesha....@gmail.com> wrote: >> need more clear info about your problem. >> >> ----- Original Message ----- >> From: "Kiran Baug" <kiranbaug2...@gmail.com> >> To: <accessindia@accessindia.org.in> >> Sent: Thursday, December 15, 2011 10:35 PM >> Subject: Re: [AI] Fwd: Need help in MS excel 2003 >> >> >>> Hi >>> >>> I want to delete blanks cells between the filled cells from a 1 to i >>> think a 39 laks cells ina a colum its goes to. >>> >>> doing manually is quite time consuming. >>> >>> There would be some or the other short cut to remove blanks cells of >>> the colum A. Please members please focus some light on this case >>> >>> Thanking you all, >>> Kiran Baug >>> >>> On 12/14/11, RAJ VASWANI <mr.rajvasw...@gmail.com> wrote: >>>> you can select the particular cell range by go to option. >>>> for this: >>>> press ctrl+g. go to dialog opens. now type your first cell. E.G A1 press >>>> colon sign then and now press the last cell and press enter. you are >>>> done >>>> with selecting the [particular range. >>>> Now you can go to edit menu and delete the selected range. >>>> Hope it helps.. >>>> ----- Original Message ----- >>>> From: "Kiran Baug" <kiranbaug2...@gmail.com> >>>> To: "accessindia" <accessindia@accessindia.org.in> >>>> Sent: Wednesday, December 14, 2011 11:17 AM >>>> Subject: [AI] Fwd: Need help in MS excel 2003 >>>> >>>> >>>>> ---------- Forwarded message ---------- >>>>> From: Kiran Baug <kiranbaug2...@gmail.com> >>>>> Date: Tue, 13 Dec 2011 19:00:25 +0530 >>>>> Subject: Need help in MS excel 2003 >>>>> To: accessindia <accessindia@accessindia.org.in> >>>>> >>>>> Hi >>>>> >>>>> I am in little problem as i am currently dealing with a huge amount of >>>>> data well i am quickly coming on the topic >>>>> My problem is that >>>>> I am copying data from old data sheet but need to make some changes >>>>> >>>>> The data starts from cell1A and goes down to cell 39,00000 A and >>>>> there is empty cells between a1 to a 3900000 i want to remove that >>>>> blank cells by selecting the whole and i am looking for the shortcut >>>>> but i am not getting one if i dont get any then i have to do it >>>>> manually which i dont want to do and it will be a lot time consuming >>>>> >>>>> If anybody can focus light on this problem will be great helpful for me >>>>> >>>>> Thanking you all, >>>>> Kiran Baug >>>>> >>>>> >>>>> >>>>> -- >>>>> Kiran Baug >>>>> >>>>> >>>>> 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 >>>> >>>> >>> >>> >>> -- >>> Kiran Baug >>> >>> >>> 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 >> >> > > > -- > Kiran Baug > > > 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 > > -- Kiran Baug 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