Helping Average Spreadsheet Users
Become Local Excel Experts
using Aweber, the best solution for managing your email campaigns.
GREETINGS
FROM CANADA
Hi
fellow Excel Addict,
I
just want to wish all of my American readers a Happy
Thanksgiving. In Canada we
celebrated our Thanksgiving on the second Monday in October, so this gives me
a second chance to tell you how very thankful I am for having you as a
fellow Excel Addict.
We're just days away from December, so a lot of people have been asking me for snow pictures but so far we haven't had any snow in (eastern) Newfoundland. In fact, currently it's really mild here for this time of the year -- but that could change pretty quick. My sister in Ottawa says they have about 10 centimeters on the ground.
On another note, I just want to let you know that every week I get a lot of emails with various Excel questions. I do read every single email but unfortunately it's impossible for me to answer every one. If I know an answer right off, I usually answer it right away. Other queries that require more time and analysis are more difficult for me to find the time to answer. However, occasionally I will be asked a question that is a challenge that I'm interested in finding the answer to, so I may spend a significant amount of time trying to figure it out. I oftem make a note of these questions to include in upcoming newsletters. Now that Christmas is getting closer, there are even more things competing for my time, so I hope you don't get offended if you don't get a reply to your question.
I may not be able to answer all of your questions but I do hope that the tips I share with you in my newsletter each week will give you some answers that will benefit you.
To your success in Excel,
Francis J Hayes (The Excel Addict)
I
just want to wish all of my American readers a Happy
Thanksgiving. In Canada we
celebrated our Thanksgiving on the second Monday in October, so this gives me
a second chance to tell you how very thankful I am for having you as a
fellow Excel Addict. We're just days away from December, so a lot of people have been asking me for snow pictures but so far we haven't had any snow in (eastern) Newfoundland. In fact, currently it's really mild here for this time of the year -- but that could change pretty quick. My sister in Ottawa says they have about 10 centimeters on the ground.
On another note, I just want to let you know that every week I get a lot of emails with various Excel questions. I do read every single email but unfortunately it's impossible for me to answer every one. If I know an answer right off, I usually answer it right away. Other queries that require more time and analysis are more difficult for me to find the time to answer. However, occasionally I will be asked a question that is a challenge that I'm interested in finding the answer to, so I may spend a significant amount of time trying to figure it out. I oftem make a note of these questions to include in upcoming newsletters. Now that Christmas is getting closer, there are even more things competing for my time, so I hope you don't get offended if you don't get a reply to your question.
I may not be able to answer all of your questions but I do hope that the tips I share with you in my newsletter each week will give you some answers that will benefit you.
To your success in Excel,
Francis J Hayes (The Excel Addict)
Please ALWAYS
type 'The Excel Addict' in the Subject field of any emails you send me.
This
will help your email stand out in the flood of junk email I receive
daily. I delete hundreds of junk emails each day, If you don't type
'The Excel Addict' in the Subject field, there's a good chance it will
get deleted. Also,
please delete the history (i.e. newsletter information) below your
response before sending.
This
weeks tips...
1) Format Only Part Of The Text Within A
Cell
(XL2003/XL2007)
2) Quickly Entering Duplicate Formulas II (XL2003/XL2007)
3) Create A Shortcut To Quickly Shutdown, Restart or Hibernate Your
Computer
If you're having trouble displaying graphics in this email, I have posted an online HTML version of this week's newsletter here.
Last week's tips were...
1) Quickly Entering Duplicate
Formulas (XL2003/XL2007)
2) Repeating Characters In A Cell (XL2003/XL2007)
3) More Room On Your Taskbar
You can still find last week's newsletter here.
You
can access even more tips on my website by going to my members
page.
|
THIS WEEK'S QUOTE
This is one of my favourite quotes ever!! "Come to the edge." "We can’t. We’re afraid." "Come to the edge." "We can’t. We will fall!" "Come to the edge." And they came. And he pushed them. And they flew. Guillaume Apollinaire 1880-1918 French poet & philosopher Is there anything more important than investing in your own personal growth? I'd like to share with you some of the Personal Development resources that I am currently using. -- Francis J Hayes THIS
WEEK'S FEATURED VIDEO CLIP
Brian Tracy - If You Could Achieve One Goal in 24 Hours |
Quick Tip
Format
Only Part Of The Text Within A Cell (XL2003/XL2007)
Everyone knows how to apply formatting to text in cells using color, bold, italics, font size, etc... You may not be aware of this little trick that will give you new options for formatting your Excel worksheets.
Did you know that you can apply different formatting to different parts of text within the same cell.
Here's how...
1) Select the cell;
2) Highlight the portion of text within the cell that you want to apply the formatting to;
3) Apply the formatting as you normally do. Don't press Enter yet!
4) Select and apply formatting to other parts of the text;
5) When you're done just press Enter.
Everyone knows how to apply formatting to text in cells using color, bold, italics, font size, etc... You may not be aware of this little trick that will give you new options for formatting your Excel worksheets.
Did you know that you can apply different formatting to different parts of text within the same cell.
Here's how...
1) Select the cell;
2) Highlight the portion of text within the cell that you want to apply the formatting to;
3) Apply the formatting as you normally do. Don't press Enter yet!
4) Select and apply formatting to other parts of the text;
5) When you're done just press Enter.
Know
an even better way?
Let me know at fhayes(AT)theexceladdict(DOT)com
Let me know at fhayes(AT)theexceladdict(DOT)com
Do You Have a Great Excel Tip to Share?
If you have a great Excel tip that you'd like to see in my newsletter, please send it to me and I will consider it for submission. Your tip should include a related sample file and should not be too long or complicated. Please say if you would like to have your name (and any other information about you that you want to share) included as credit for the tip.Email your suggested tips to... fhayes(AT)theexceladdict(DOT)com
"HOW
TO EXCEL" TUTORIAL
Quickly
Entering Duplicate Formulas II (XL2003/XL2007)
Last week I showed you how you could quickly enter dozens or even hundreds of formulas in a range of cells by entering only one formula and pressing CTRL+Enter. Well, like most other things in Excel, there are multiple ways to accomplish the same task. So, here's another quick and easy way to duplicate formulas and values recommended by Delain Goddard.
Whenever you already have data in a cell that you want to duplicate in other cells here is a quick technique you should know.
1) Select the cells where you want to copy the contents;
2) If all cells are contiguous to the source, the source can be the first cell selected of the range. If all cells are not contiguous, first select all of the target cells, then hold down the Ctrl key and select the source cell last, making it the Active Cell;
3) Press the F2 function key to put the source cell in edit mode;
4) Then press Ctrl+Enter to instantly copy the contents of the Active Cell to all of the target cells.
It is important to remember that this will work for formulas only if the cells to be filled require formulas with the same size and relative references as the original cell.
Last week I showed you how you could quickly enter dozens or even hundreds of formulas in a range of cells by entering only one formula and pressing CTRL+Enter. Well, like most other things in Excel, there are multiple ways to accomplish the same task. So, here's another quick and easy way to duplicate formulas and values recommended by Delain Goddard.
Whenever you already have data in a cell that you want to duplicate in other cells here is a quick technique you should know.
1) Select the cells where you want to copy the contents;
2) If all cells are contiguous to the source, the source can be the first cell selected of the range. If all cells are not contiguous, first select all of the target cells, then hold down the Ctrl key and select the source cell last, making it the Active Cell;
3) Press the F2 function key to put the source cell in edit mode;
4) Then press Ctrl+Enter to instantly copy the contents of the Active Cell to all of the target cells.
It is important to remember that this will work for formulas only if the cells to be filled require formulas with the same size and relative references as the original cell.
Know
an even better way?
Let me know at fhayes(AT)theexceladdict(DOT)com
Let me know at fhayes(AT)theexceladdict(DOT)com
"You Are About To Discover The Real 'Excel Secrets'
That Most Users Never Know, About How To Quickly Turbocharge Your Excel
Skills"In my latest ebook you'll learn 101 secrets that most users haven't discovered, even after using Excel for 10 or 15 years.
Are you ready to experience some Excel 'Aha!s' just like Ivan?
Dear Mr. Hayes, First of all, thank you for the wonderful Aha! experiences I had reading your "101 Secrets of a Microsoft Excel Addict." The Shift+drag columns/rows and the Alt+; shortcuts alone made it worthwhile the modest amount you charge for your e-book. Thank you for being such an Excel Addict. Action does generate inspiration. You have inspired me, I'm having fun with Excel once again. Cheers, Ivan
NON-EXCEL
TIP
Create A Shortcut To Quickly
Shutdown, Restart or Hibernate Your Computer
Step
1: Create A Desktop Shortcut
Right click on a
blank space of your desktop and select New,
Shortcut. A Create Shortcut window
will open.
1) Type in shutdown.exe
-s -t 0 (This means, shutdown and wait for zero seconds.
You can also substitute the -s with -r
for Restart or -h
for Hibernate);
2) Click Next button for next step;
3) Type Shutdown for the name and click Finish.
2) Click Next button for next step;
3) Type Shutdown for the name and click Finish.
You now have a
new shutdown shortcut on your desktop
Step
2: Change The Icon For Your Shortcut
1)
Right click the Shutdown shortcut icon on your desktop and click Properties;
2) Click
the Change icon button. An alert message
will popup. Click OK to ignore it;
3) From
the list of icons displayed select the square red icon and click OK;
Step
3: Create A Keyboard Shortcut To Shutdown Your Computer
Click
in the Shortcut Key field and press CTRL+Shift+S
to create a keyboard shortcut to activate the shutdown command.
Now,
to quickly shut down your computer, you double-click the shortcut on
your Desktop or simply press CTRL+Shift+S
on your keyboard.
Alternatively, you can drag the shortcut icon to your Quick Launch bar to give you a one-click shutdown option.
Alternatively, you can drag the shortcut icon to your Quick Launch bar to give you a one-click shutdown option.
Know an even better way?
Let me know at fhayes(AT)theexceladdict(DOT)com
Let me know at fhayes(AT)theexceladdict(DOT)com
SUBSCRIPTION
INFORMATION
Spreadsheet Tips From An Excel Addict
is available only to subscribers of my email
newsletter. If this newsletter was forwarded to you and
you would like to get your own copy, please visit
http://www.TheExcelAddict.com
"Spreadsheets
Tips From An Excel Addict"
is a weekly publication of TheExcelAddict.com.
Copyright Francis J. Hayes All Rights Reserved.
8 Lexington Place, Conception Bay South, Newfoundland, Canada, A1X 6A2 Phone: 709-834-4630
is a weekly publication of TheExcelAddict.com.
Copyright Francis J. Hayes All Rights Reserved.
8 Lexington Place, Conception Bay South, Newfoundland, Canada, A1X 6A2 Phone: 709-834-4630