Dear Umesha,
Excel 2003 has 256 columns per worksheet but Excel 2007 has 16,384 columns
per worksheet. I do not know if the number of columns has increased even
further in Excel 2010.
Your Friend
Mr. Sameer Latey
Mumbai, India
----- Original Message -----
From: "Umesha Economics" <umesha....@gmail.com>
To: <accessindia@accessindia.org.in>
Sent: Sunday, December 18, 2011 5:19 AM
Subject: Re: [AI] Fwd: Need help in MS excel 2003
I think you can write a jaws script for this. I wrote one for merging
multiple cells. one more question, do we have lakhs of columns in MS excel?
as per my knowledge, there will be 255 columns in a sheet.
Umesha
----- 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
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
