Thanx a ton Dave
On Tue, Jun 9, 2009 at 8:15 AM, Dave Bonallack <davebonall...@hotmail.com>wrote:
> 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
>
> >
>
--
Thanks & Regards,
Harmeet Singh
--~--~---------~--~----~------------~-------~--~----~
-------------------------------------------------------------------------------------
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
-------------------------------------------------------------------------------------
-~----------~----~----~----~------~----~------~--~---
