Francis Hayes "The Excel Addict" Reveals...
"101 Secrets That Will Have
Everyone Around You Thinking
You're An Excel Magician"
Be Careful !
The SECRETS revealed in this eBook are highly ADDICTive

Below is a complete list of the Excel
Tips, Tricks and Secrets you'll find inside my eBook.

Each one of these tips has the potential to save you much valuable time.

How much is your time worth to you? Multiply that by 101.
101 Secrets of a Microsoft Excel Addict
1. Let Excel Read To You
2. The Quick And Easy Way To Move Rows and Columns
3. Put Pop-Up Pictures In Your Cells
4. Put Checkmarks In Your Cells
5. Create Cool 3D Effects In Your Cells
6. Fonts In Any Size You Want
7. Quickly Enter Duplicate Formulas
8. Combine Text And Numbers From Different Cells
9. Instantly Move To The End Of A Long Column
10. Make Your Spreadsheet Fit Your Screen
11. Hide Duplicate Values In A List
12. Quickly Select All Blank Cells In A Range
13. Turning The Tables
14. Recover A Deleted Sheet
15. Print Your Spreadsheet On A Specific Number of Pages
16. Dialog Box Tip
17. Quicker Data Input Using 'Pick From List'
18. Entering Data Into Cells In A Specific Order
19. A Double-Click Fill Handle Trick
20. Move A Little Closer
21. Create A Table of Contents For Your Workbook
22. Fill Handle Secret Revealed
23. Easily Move Sheets Between Workbooks
24. Turn Off That Annoying Paste Options Button (XL2003)
25. Prevent Automatic Creation Of Hyperlinks
26. AutoFill Your Own Custom Lists - Cool!
27. Make Your Worksheet Look Less Like A Worksheet
28. View Two Parts Of Your Worksheet Simultaneously
29. Give Me The Full Menu!
30. Create Dynamic Row Numbering
31. Sum Only Data That Meets A Condition You Specify
32. Cycle Font Color Tool Trick
33. Floating Colors
34. A Solution To The 'Last Used Cell' Mystery
35. A Neat Trick To Copy Formulas And Maintain Their Original Cell References
36. Cutting Corners On Your Text Boxes
37. Filter Your List With One Click
38. Delete Those Pesky HTML Objects From Pasted Web Data
39. Zoom Out For A Bird's-Eye View
40. Supress #DIV/0! Errors
41. Quickly Increase Your Value
42. Force Your Worksheet To Print Only One Page Wide
43. A Simple Trick To Replace A Formula With Its Value
44. Link a Text Box to Data in a Cell
45. Quickly Sum Non-Contiguous Cells
46. Display A User Input Message In A Cell
47. The Extend Selection Mystery
48. Formulas To Show The Path, Filename and Sheet Name
49. Extract Unique Items From A List
50. Align Objects With Cell Borders
51. Quickly Enter The Months Of The Year
52. F4, One Of Excel's Best Kept Secrets
53. Format Only Part Of The Text Within A Cell
54. A Quicker Way To Move or Copy Cells
55. Hide A Sheet Tab
56. Getting Rid of Those #$@& Spaces In Imported Data
57. Print Just A Small Section Of Your Worksheet
58. Quickly Convert Positive Values To Negative
59. Fonts and Cell Backgrounds In Every Color Of The Rainbow
60. Print Your Company Logo At The Top Of Each Sheet
61. AutoShape Perfection
62. No More Counting Characters
63. Quickly Access A Calculator From Excel
64. Create A Keyboard Shortcut For Windows Calculator
65. Advanced Windows Calculator
66. Use Your Keypad To Operate Windows Calculator
67. Have Multiple Print Areas On The Same Worksheet
68. Custom Sort Your Data
69. How To Subtotal Your List
70. Make Your Subtotals Really Stand Out
71. Sort Your Data Sideways
72. Move The Active Cell Within A Selection
73. Return The Day Of The Week From A Date
74. Change The Font in Your Footer or Header
75. Easily Convert Formula Results To Fixed Values
76. This Tip Is Wheel Cool!
77. Make Your Data Really Stand Out With Linked AutoShapes
78. Paste Everything Except Borders
79. Quick Solutions with Goal Seek
80. Create A Linked Picture Of A Cell Range
81. What Column Number Is It?
82. Prevent Unwanted AutoFilling
83. Convert Numbers With Minus Sign On Right-Hand Side
84. Change Excel's Default Open/Save To Location
85. Create Bullet Lists in Excel? Yes, You Can!
86. Avoid Vertical Alignment Problems with Wrapped Text
87. Can't Find That Recently Used File?
88. Change Excel's Default Font
89. Create Cell Comments Of Various Shapes
90. Formula To Calculate Last Day Of The Month
91. Easily Clear Just Your Input Cells
92. The Fastest Way To Select A Block Of Cells
93. Create Your Own Custom AutoFilter Toolbar
94. Copy Just The Subtotal Rows
95. Display Your Numbers As Thousands
96. Create A Running Total' Formula
97. Create A Custom Menu For Frequently Used Workbooks
98. Use Wildcards To Speed Up Your Auto Filtering
99. Avoid Excel's Out-Of-Control Scrolling
100. Calculate The Number Of Days, Months Or Years Between Two Dates
101. Create A Personalized Default Workbook

Page 107 Get More Tips For FREE
You can get all of these NOW
for only 15 cents per tip.
(CLICK BOOK FOR PREVIEW COPY)

Special Introductory Price
As an incentive to get my Excel Secrets into the hands of as many Excel users as possible, I have slashed 40% off my regular price.
Regular Price $24.97(US)
You can get it NOW for only
$14.97(US)
(THIS LOW PRICE WON'T LAST FOREVER)
To Get It At This Low Price
Easy, Fast,
Safe and Secure Checkout
Dear Fellow Excel User,
If you're new to Excel, I've got some good news for you. Those people who have been using Excel for years are not that far ahead of you. Excel is probably the most popular business software program ever written, yet most users are utilizing less than 5% of its best, time-saving features.
However, if you're someone who has been using Excel for years and have yet to discover all these wonderful secrets everyone is talking about, now's your chance to make a giant leap in your productivity.
Francis: I just downloaded my copy of your new ebook, '101 Tips for the Excel Addict' and it is marvelous!! The first few tips blew me away. If the rest are this good or better, I'm in 'Excel heaven'. Thanks so much and keep 'em coming. -- Michael P., Information Technology (IT) Coordinator
After reading this eBook, you will have discovered many of Excel's best secrets that have been hiding right under your nose. These secrets are guaranteed to catapult your skills and productivity far ahead of anything you have even imagined.
  • In my ebook, I show you how to create a custom filtering toolbar to make working with your lists a breeze.
  • Need to delete all blank rows in you list? I'll show you a trick to get that done in seconds -- even if your list has thousands of rows.
  • I'll show you how to create a table of contents using hyperlinks to make moving around large complex workbooks as easy as surfing the Internet.
  • Wouldn't it be great to create Text Boxes that are linked to data in a cell? It's easy! And I'll show you how in my book.
  • Did you know you can use different formatting on text in the same cell? I'll show you this trick that very few Excel users know.
  • Have you ever imported or copied data from the web only to find you couldn't get rid of those annoying blank spaces? I've discovered a solution and I want to share it with you.
  • My book will show you how to make your data really stand out using 'linked AutoShapes'
  • Don't like the colors you are limited to in Excel? Would you like an unlimited choice of colors for your fonts and backgrounds? Get my ebook NOW and I'll reveal this secret to you.
Francis, How I wish I would have found you a year ago when I had to go through this exercise the first (of a number of times). I could have saved HOURS of time. Thank you, thank you, thank you! Have a great day! -- Charlene
Once you uncover just a few these seemingly unlimited supply of amazing, almost-magical Excel secrets, you will understand why so many people become 'addicted' to Excel .
I've been using Microsoft Excel for over 15 years and I can't seem to get it out of my system.
If you have enjoyed my tips in the past, I think you will really love 101 of my best 'secrets' all compiled in one convenient resource. I'm sure that my eBook will save you many, many more times its value in the hours and hours of work you will save month after month.
Francis, I used to think myself a pretty accomplished excel user, but you keep surprising me with new tricks every time. Keep up the great work! Thanks, Partha.
You can buy my eBook and learn the solutions to 101 common problems that Excel users everywhere are faced with daily or you can waste countless hours trying to find answers elsewhere. You know which option is best, right?
To your success,
Francis J Hayes (The Excel Addict)

Francis J Hayes (The Excel Addict)

Proceed with CAUTION ! You too are at risk of becoming an Excel Addict.
Important Note: The tips contained in this eBook are primarily for use with Excel 2003. Most will also work with Excel 2002 and Excel 2000. However, these tips have not been tested in Excel 2007 or Excel 97.
Special Introductory Price
As an incentive to get my Excel Secrets into the hands of as many Excel users as possible, I have slashed 40% off my regular price.
Regular Price $24.97(US)
You can get it NOW for only
$14.97(US)
(THIS LOW PRICE WON'T LAST FOREVER)
INSTANT ACCESS
You can be learning 101 of my best tips in minutes
Purchase Online with Credit Card by Secure Server
To Get It At This Low Price
(Easy, Fast, Safe and Secure Checkout)
This product is a downloadable eBook in PDF format (107 pages, 5.6MB). You will need Adobe Acrobat to open, read and print this eBook. This shouldn't be problem because most computers have Adobe Acrobat already installed.
More Reader Testimonials
These tips are really amazing !!!!!!! There are so many things which we would not be aware of. Thanks a lot for these tips. Thanks -- Chetana

Your tips and tricks have been more helpful to me than the monstrous Excel handbook I keep on my bookshelf. Again, thank you and keep up the good work. -- Lynne M

Hi Frank - Success!! This will save me significant frustration! All the best - Andy

Hi Francis, I am very grateful of the tips as it improves my turn around time. Thanks -- Clave

Hi Francis: Thanks you hugely. I am singing the praises of Excel Addict. Cheers -- Marcia

Dear Francis, I never cease to be amazed by your knowledge and expertise. Many many thanks and please keep up your inspirational work. Sincerely, Stephen

Dear Mr. Hayes, You are doing a great and excel-lent service,-- Arul, Kuala Lumpur, Malaysia

You most definitely are the 'Excel Addict'. Thank you so much! I was told by an advanced Excel instructor that the only way to solve this was to reload Microsoft Office. I knew that there had to be a way and it was sooooo simple. Thank you! - Scott, Trinidad

I just want to say that your tips are extremely helpfull. You are concise. You make it all seem so simple -- Jason

I have often wondered how to do this but never knew how to!!! THANK YOU THANK YOU THANK YOU!!!! -- Christie

Hi Francis, Thanks. This is one of the best "Excel Addict" tips I have had in a long time. Regards, Jake

Hey Francis! You always make things look so very nice and "follow-on-able" for us! Have a super day! Thanks -- Shirley : )

Another great tip ... I gave up on finding a way on how to format part(s) of a cell. I have asked a lot of supposed to be self-proclaimed Excel experts and they told me it could not be done. I guess now I can tell these "experts" that it indeed could be done. Again, thanks a whole lot ... I always look forward to your tips. More power to you and regards. - Benjie, Houston TX
Hey Francis - I found your Excel tutorials, well, simply amazing. I always get a chuckle when I come across something like this. The examples you've given are just so simple, I can't believe they aren't just readily known, but I copied down at least a dozen I've never heard of before. Regards, Robin

HI Francis, Just like to say thank you for all the Excel Tips, I'm amazed how much excel knowledge I have accumulated through you're XL tips. Thanks again Peter

Dear Francis J Hayss I am getting great help from your tutorial, the way it is explained is so easy to understand , practice & implement in daily use. Thanks -- Pravin

Hi Francis Thank you very much. Looking at it now, it is so simple and I did not see it. You're making me look very clever to my staff :) That is a good thing. Thanks -- John

TheExcelAddict: A note of gratitude for you THANK YOU!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! My administrator and I have being going absolutely nuts for months trying to massage data from our Urchin and other web-generated statistics reports trying to get the mysterious white space out of the cells. Excel "Help" was no help, my boss was convinced we were idiots (what could be so hard about TRIM or search and replace?), and we spent way too much time pressing the delete key manually. NOW, we know. Thanks to your tip: Getting Rid of Those #$@& Spaces In Imported Data THANK YOU SO MUCH. What a relief to finally understand what is going on here! -- Courtney
Francis, Thank you for your tips. They have been very helpful and are definite time savers. Regards -- Rob ( Project Co-ordinator )

Hi Francis, My name is Vivek and i am writing this mail to you from India in order to give my regards to the great work you are doing and the kind of help i have received from your work has improved my work efficiency by 15 - 20% in office. My work profile has started to a better outlook to it lately. Keep up the great work and do let me knw if you come to India any time in future. Regards -- Vivek

Helo Francis, I have regularly used your tips to improve my office and the spreadsheets they currently use and would not be able to do this without your valuable assistance...again thanks -- Tony
To Get NOW It At This Low Price
(THIS LOW PRICE WON'T LAST FOREVER)
Copyright Francis J Hayes © All Rights Reserved
8 Lexington Place, Conception Bay South, Newfoundland, Canada A1X 6A2
Phone 1-709-834-4630
Keywords: Francis J Hayes, The Excel Addict, Microsoft Excel eBook, Microsoft Excel Tips, Microsoft Excel Book, Excel Help, Francis Hayes, Excel Addict, spreadsheet tips, training, keyboard shortcuts