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
