Hi Harmeet,
I think this is a very good tip.
Regards - Dave.
Date: Tue, 9 Jun 2009 00:29:31 +0530
Subject: $$Excel-Macros$$ Re: <BEST EXCEL TIP> <WEEK # 24> <Submit TIP and Win
PRIZE>
From: harmeet.hew...@gmail.com
To: excel-macros@googlegroups.com
HI All,
Name : Harmeet
Subject : Hidden text in Formula
Tip : =2018+1056-4*120+N("My Salary + Bonus - 4 weekly loan repayments")
BY using N() formula You can enter hidden text in your formula.
Try it.............
Regards,
Harmeet
On Fri, Jun 5, 2009 at 9:11 PM, Ayush <jainayus...@gmail.com> wrote:
Hello Everyone,
Please submit your tip in this post for Week # 24. I am looking for
your overwhelming response in this competition.You just need to submit
your name along with the tip and subject. The tip can be shortcut,
trick, hidden secret, etc.
Last Submission Date -----13th June 2009.
Winner Declaration Date -----14th June 2009.
Example :
Name : Ayush Jain
Subject : the Great 'F4'
Tip : The 'F4' is easily the most useful shortcut key in Excel.
Basically it repeats your last command.
So say you changed the color of a font in a cell. Now click in a new
cell and hit 'F4' and it will change the font in the new cell to the
same color.Wonderful, right? Well what's great about this is that it
works for nearly everything else in Excel too.Highlight a row, right-
click and choose 'Delete'. Now highlight another row and hit 'F4'. It
deletes that row.Whatever you did last, Excel will attempt to repeat
the same command until you do something else. This works great for
things that require you to go to the menus or right-click and make
choices or click buttons that bring up more dialogs. It can be huge
time saver once you get used to using it. As the help says, it doesn't
work in every situation but most times 'F4' works great.
SO, WHAT ARE YOU WAITING FOR ? JUST SUBMIT A TIP & WIN PRIZES. Invite
your friends too for participation in the contest. The more
participation means more learning.
Thanks again,
Ayush Jain
--
Thanks & Regards,
Harmeet Singh
_________________________________________________________________
Looking for a new car this winter? Let us help with car news, reviews and more
http://a.ninemsn.com.au/b.aspx?URL=http%3A%2F%2Fsecure%2Dau%2Eimrworldwide%2Ecom%2Fcgi%2Dbin%2Fa%2Fci%5F450304%2Fet%5F2%2Fcg%5F801459%2Fpi%5F1004813%2Fai%5F859641&_t=762955845&_r=tig_OCT07&_m=EXT
--~--~---------~--~----~------------~-------~--~----~
-------------------------------------------------------------------------------------
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-------------------------------------------------------------------------------------
-~----------~----~----~----~------~----~------~--~---
