Dear friend,
Senario 1. If you want to incert the row [cells from left to right] for
entire sheet then, select the cell above which you want to incert the row.
for eg. there is data in row A1 and row A2 now you want to creat the row
between A1 and A2. go to A2 and press application key and select Incert.
Down arrow to Incert entire row. and hit enter. now you will notice that the
data in the work sheet in row 2 is shifted to row 3 and you got the extra
row as row 2.
Senario 2. Suppose you have 2 or more data region. for eg. data region 1, a1
to e10. data region 2. g1 to k10. now you want to creat the extra row for
first data region without temperring data region 2. go to the cell above
which you want to incert row. select all the the cell horizontall. for eg.
your data region is a1 to e10 and you want to incert the row between A3 and
A4. go to A4 and select a4:E4 and press application key. press down arrow
and go to incert. select shift cells down and hit enter. you will notice the
extra row has created for a4 to e4you will notice that all the data from
that range has shifted to a5:e5, the second data region is unaffected.
zoher kheriwala taheri menswear mumbai. skype id zoher.kheriwala
----- Original Message -----
From: "Priyesh.C.U" <[email protected]>
To: <[email protected]>
Sent: Friday, August 16, 2013 11:56 PM
Subject: [AI] a doubt on ms xl
friends, how can i create a new row bitween 2 rows on xl? expecting the
help.
With best regards, Priyesh.C.U, Assistant Professor, P.G Department of
Politics, Maharaja's College, Ernakulam District, Kerala
& PH.d Scholar, School of International Relations & Politics, M.G
University, Kottayam.
Mobile: 09846141225
Email I D:
[email protected]
Skype I D: priyesh.cu
Facebook: priyesh cu Follow me on Twitter: priyeshcu
"Whenever there is
Decline of righteousness,
And rise of unrighteousness,
I incarnate myself
To protect the virtuous
And to destroy the wicked,
From Age to Age.
Geeta".
Register at the dedicated AccessIndia list for discussing accessibility of
mobile phones / Tabs on:
http://mail.accessindia.org.in/mailman/listinfo/mobile.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
Disclaimer:
1. Contents of the mails, factual, or otherwise, reflect the thinking of
the person sending the mail and AI in no way relates itself to its
veracity;
2. AI cannot be held liable for any commission/omission based on the mails
sent through this mailing list..
Register at the dedicated AccessIndia list for discussing accessibility of
mobile phones / Tabs on:
http://mail.accessindia.org.in/mailman/listinfo/mobile.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
Disclaimer:
1. Contents of the mails, factual, or otherwise, reflect the thinking of the
person sending the mail and AI in no way relates itself to its veracity;
2. AI cannot be held liable for any commission/omission based on the mails sent
through this mailing list..