Name: Bakul Patel
Tip: Use F8 key to select range of cells.(No use of shfit key/mouse to
select range of cells)
If you want to DEFINE name of different cell ranges, do like this.
Example:
I want to give different names to following ranges using DEFINE function.
Range:A1:B20, A1:X10, A1:S30,
..so on.... ( Keep in mind that first cell is fixed in my case)
How to do :
Click cell A1 & press F8 Key ( this action will freeze cell A1)
then click on cell B20, it will select all of the cells from A1 to B20. Now use
Ctrl + f3 key to define name.
Once you finish define name click on X10, this will select A1 to X10 cells. Use
Ctrl+F3 again (same as above)
You can do it as many times as you want....
You can also use this with go to (f5 key) function to move your freeze cell
(below example);
You want to define name for following ranges,
A1:X20, B24:Y50, A20:H30 (in previous case A1 was fixed, here that is not
the case)
How to do:
A1:X20 Click on A1>Press F8 key>click X20>Ctrl+F3 (define name)
B24:Y50 Continue from previous>Press F5 key (go to function) type
B24>Enter>Enter> Click on Y50>Ctrl+F3 key (define name)
and so on
You can use this freeze function for many other applications, depending on your
use.
Chees,
Bakul
--- On Fri, 6/19/09, Bakul Patel <bakulpatel...@yahoo.com> wrote:
From: Bakul Patel <bakulpatel...@yahoo.com>
Subject: $$Excel-Macros$$ Re: <BEST EXCEL TIP> <WEEK # 25> <Submit your TIP
here only> Options
To: excel-macros@googlegroups.com
Date: Friday, June 19, 2009, 7:10 PM
Hi Friends,
Name: Bakul Patel
Tip of the week;
Convert name from "bakul" to "Bakul".
If you have a big list of names & you want to make it like this then this would
be helpful.
A B Result
1 bakul =PROPER(A1) Bakul
Cheers,
Bakul
--- On Fri, 6/19/09, Upendra Singh <upendrasinghsen...@gmail.com> wrote:
From: Upendra Singh <upendrasinghsen...@gmail.com>
Subject: $$Excel-Macros$$ Re: <BEST EXCEL TIP> <WEEK # 25> <Submit your TIP
here only> Options
To: excel-macros@googlegroups.com
Date: Friday, June 19, 2009, 8:09 AM
Hi Friends,
Name : Upendra Singh
TIP : Hide Data in Cell or Worksheet from praying Eyes
ð Select the range you want to hide.
ð Go To Format=>Number=>Custom
ð In the type Box, type three colon (;;;) and press enter.
ð The data where the above formatting is applied will be visible in formula
Bar only and not in Worksheet Cell.
Regards,
Upendra Singh
9910227325
-------------------------------------------------------------------------------------------------------------
There are 10 kinds of people: Those who understand binary and those who don’t.
--~--~---------~--~----~------------~-------~--~----~
-------------------------------------------------------------------------------------
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
-------------------------------------------------------------------------------------
-~----------~----~----~----~------~----~------~--~---
