On 12/15/11, Kiran Baug <[email protected]> wrote: > 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 <[email protected]> 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" <[email protected]> >> To: "accessindia" <[email protected]> >> Sent: Wednesday, December 14, 2011 11:17 AM >> Subject: [AI] Fwd: Need help in MS excel 2003 >> >> >>> ---------- Forwarded message ---------- >>> From: Kiran Baug <[email protected]> >>> Date: Tue, 13 Dec 2011 19:00:25 +0530 >>> Subject: Need help in MS excel 2003 >>> To: accessindia <[email protected]> >>> >>> 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/[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 >> >> > > > -- > Kiran Baug > > > 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 > > i think i can solve your problem but i need to understand your problem much clearly so can you call me on mobile +919029729579
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
