Hi Sunitha, Select the whole sheet and uncheck the lock using the format cells
window. Then select the cells which you want to protect and chec the lock using
the format cells window. Now go to Tools, Protect Sheet and protect the
worksheet. Only those cells will be protected which has been
Done!
On 10-Nov-2012, at 11:40 AM, Ayush Jain jainayus...@gmail.com wrote:
Dear group,
I have created a small formula quiz to test your formula knowledge. This quiz
has 10 questions related to excel formulas only.
Formula quiz
Based on your participation and engagement, I will try to
Hi,
You can select all the dates and use Control + H
Find What: 2011
Replace With: 2010
then click on Replace All button. It will change all the 2011 to 2010
Hope this helps!
Thanks,
Shreedar
On Thu, May 26, 2011 at 11:19 PM, Rich Prince rich.pri...@gmail.com wrote:
I have a column
Hi Bhanu,
Select all the cells where you want to remove zeros and select control + H,
and type 0 and replace with blank and then click on* Replace All.*
*
*
*
*
Thank you,
Shreedar
On Sun, Apr 3, 2011 at 8:25 PM, bhanu prakash bhanu...@gmail.com wrote:
Hi - need it help excel. Removing zeros
Any help on this would really great.
Thank You,
Shreedar
On Thu, Dec 2, 2010 at 7:01 PM, Shreedar Pandurangaiah
shreedar.panduranga...@gmail.com wrote:
Hi Group,
While I am able to use the Ctrl + Tilde, to see the hidden formulas in the
spreadsheet. My colleague is not able to do that...I
Hi Group,
While I am able to use the Ctrl + Tilde, to see the hidden formulas in the
spreadsheet. My colleague is not able to do that...I mean to say can't use
the Ctrl + Tilde. What should I do to enable that?
Thank You,
Shreedar
Hi Alan,
The third part of the formula, where you've put $E:$E has to be replaced by
either 1 or 2(since your table array is just D and E column).
Thanks,
Shreedar
On Sun, Oct 10, 2010 at 2:30 AM, Alan jalantho...@verizon.net wrote:
I am using Excel 2007 and having a strange problem
Dear Group,
Please let me know, if any of you are interested in training a group of
folks on Microsoft Excel in Bangalore. They are looking for 30 hours of
training..
Thank You,
Shreedar
--
--
Some important links
You can use Advance filters to remove the duplicates. Select the data...Go
to Data - Filter - Advance Filter - Click on Unique Records only - and Click
Ok...All the duplicate records will be filtered of.
Thanks,
Shreedar
On Thu, Sep 23, 2010 at 2:07 PM, janet dickson janetdicks...@gmail.comwrote
Hi Ayush, Here are my answers...
If B and C is given A = Bth root of C
If A and C is given B = Log(C,A)
If A and B is given C = A ^ B
Thanks,
Shreedar P.
On Wed, Sep 22, 2010 at 5:55 PM, Ayush jainayus...@gmail.com wrote:
Dear Group,
A small quiz for you...let see who answers it first
Dear All, this is amazing...I truly appreciate everyone's continued effort.
Thanks again,
Shreedar
On Mon, May 24, 2010 at 12:55 PM, sudhir kumar bluecore...@gmail.comwrote:
Hi
all Group members,
Thanks for joining this group and countined with us and
very special thanks to Ayush
Hi Sanjay,
If you are using Excel 2003 then keeping your cursor in the data and then
clicking Ctrl+A would choose the whole range of the data where your cursor
is placed...Try doing this while recording the macro, It will work.
Thanks,
Shreedar
On Thu, Jul 2, 2009 at 12:27 PM, SANJAY SONI
, If you have any more questions on this one!!!
Thanks,
Shreedar
On Thu, Jul 2, 2009 at 1:04 PM, shivashankar katageri
shankarkatag...@gmail.com wrote:
Dear all,
Any one can help w.r.t copy from subjects of column cells to row cells,by
just dragging or in no time, please
for reference see
13 matches
Mail list logo