Hi Harmeet,
Can provide some samples, it will be a gr8 help for us?
Rgds,
Mahender Bisht
On Tue, Jun 9, 2009 at 12:29 AM, Harmeet Singh <harmeet.hew...@gmail.com>wrote:
> 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
>>
>> >>
>>
--
With Love,
Mahesh Bisht
--~--~---------~--~----~------------~-------~--~----~
-------------------------------------------------------------------------------------
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
-------------------------------------------------------------------------------------
-~----------~----~----~----~------~----~------~--~---
