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.comwrote:
HI All,
Name : Harmeet
Subject : Hidden text in Formula
Tip : *=2018+1056-4*120+N(My Salary + Bonus - 4 weekly loan
Hi All,
Name : Rakesh Shar,ma
Subject : Remove Border formatting
Tip : Press Ctrl + Shift + _ (Under Score)
On Jun 10, 5:15 pm, Rakesh Sharma rak_sha...@yahoo.co.in wrote:
HI All,
Name : Rakesh Shar,ma
Subject : Show formulas in printable format
Tip : Press Ctrl + ~ ( To View
HI All,
Name : Rakesh Shar,ma
Subject :For Quick Chart
Tip : Press F11
To prepare quick chart based on data, Just select the your data and
press F11.
On Jun 10, 5:15 pm, Rakesh Sharma rak_sha...@yahoo.co.in wrote:
HI All,
Name : Rakesh Shar,ma
Subject : Show formulas in printable
HI All,
Name : Rakesh Shar,ma
Subject : Show formulas in printable format
Tip : Press Ctrl + ~ ( To View formulas in printable format or
to take a printout for forumlas enter in cells)
On Jun 5, 8:41 pm, Ayush jainayus...@gmail.com wrote:
Hello Everyone,
Please submit your tip in
name: harsh shah
subject : formula reference
tip : press ctrl + [ (will show from where the formula has been derived)
ctrl + ] (will show where this cell has been used in formula)
On 10/06/2009, Rakesh Sharma rak_sha...@yahoo.co.in wrote:
HI All,
Name : Rakesh Shar,ma
Subject :
Name: Aindril De
Subject: Shortcut keys for selecting cells, rows, and columns in Excel 2003
Tips:
1. Extend the selection in the direction of the arrow key
[Shift]+[→], [Shift]+[←], [Shift]+[↓], [Shift]+[↑]
2. Select the current column
[Ctrl]+[Spacebar]
3. Select the current row
Name: Aindril De
Subject: Useful Shortcut keys Using Ctrl and Shift
Tips:
Ctrl+Shift+4 (i.e. Ctrl+$): Formats your current selection as currency
Ctrl+Shift+5 (i.e. Ctrl+%): Formats your current selection as a percentage
Ctrl+Shift+6 (i.e. Ctrl+^): Formats your current selection as scientific
thanks for this shortcut
its cul
On Tue, Jun 9, 2009 at 6:18 AM, Abdul Rasheed rashee...@gmail.com wrote:
Name : Abdul Rasheed
Subject : Save As
Tip : Press F12
Regards
Abdul Rasheed
--~--~-~--~~~---~--~~
HI All,
Name : Harmeet
Subject : Enter Date
Tip : Press Ctrl+;
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
HI All,
Name : Harmeet
Subject : Select Active Column
Tip : Press Ctrl+Space bar
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
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
HI All,
Name : Harmeet
Subject : Enter Time
Tip :
CTRL SHIFT : Enters the time
CTRL SHIFT Creates an outline box around whatever you select
CTRL SHIFT _ Removes the outline box around whatever has an
outline
CTRL SHIFT * Highlights all
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
To select blank cells in a range:
Select the range, then hit Cntl + G Alt + S (special) k (blanks) hit
enter.
Srinivasan Ethirajalu.
On Sat, Jun 6, 2009 at 1:13 PM, Manoj S Negi
manojsnegi.uttranc...@gmail.com wrote:
Hi all,
Name : Manoj S Negi
Subject : Insert a new sheet in the excel
Name : Satti Charvak
Subject : the Great 'F2'
Tip : The 'F2' is easily the most useful shortcut key in Excel, and in
the Microsoft Windows Operatin System (All Versions) of course.
Basically it it helps you rename many things:-
1. File/Folder names in Windows OS
2. Cell text in Excel cells
Name : Upendra Singh
Subject : Selecting More than one Value in a single Page field for Pivot Table
Tip : There are sometime situation where we need to select more than one
Value form a given Page field in Excel Pivot Table. In Excel 2003, we can
either select “All” or one Value from a
16 matches
Mail list logo