June 3, 2015
If the images in
this message are a little misaligned in your email program,
you can go here to read the
online version of this newsletter
NOTICE OF TEMPORARY CHANGES TO
MY NEWSLETTER - PLEASE READ
you may already know, I publish this newsletter every week, maintain my
website and answer a lot of questions from Excel Addict members, all in
my 'spare' time. Yes, I do have a full-time day job as well, so every
week it's a challenge for me to find the time to write and publish my
the next two months I will be updating my website, something I have
been wanting to do for years. This is going to take up a
significant amount of my time but I definitely don't want you
miss out on these valuable tips completely. So, what I have decided to
do for the next while is to continue publishing my newsletter
weekly, but in order to free up some time, I will be scaling back to
just one tip each week. I hope that will be enough to keep you learning and
loving Excel until I get my new and improved website up
in advance for your patience and understanding.
Hi fellow Excel Addict,
for joining me this week. I'll keep my message brief as I am trying to
free up as much time as possible to work on my website project.
hope you'll find this week's tip useful and that it helps make your
work a little easier. If you do, please be kind and share it
others who could use a little help as well.
I hope you have a fantastic week.
Hayes (The Excel
To view this
week's newsletter online click here.
If you missed last
week's newsletter, you can click here to view it online.
You can access
even more tips
on my website by going to my
you have a favourite quote, send it to me and I may post it in my
Easily Convert An AutoShape to a Different Shape
If you want to convert an existing AutoShape (Insert, Shapes) such
as a rectangle to a different shape, such as an arrow, here's an
easy way to do it without having to start from scratch and recreate all
of the formatting.
1) Select the AutoShape you wish to convert;
2) On the Drawing Tools...Format tab, point to Edit Shape... (in the Insert Shapes group);
3) Point to Change Shape and the select another type of shape.
The shape is changed instantly right before your eyes, with all of the same formatting and properties preserved.
You may be wondering how other people use AutoShapes in Excel, take a look here...
Note: There is a link on the above website to download a sample
workbook containing the AutoShapes picture. I downloaded it and it
locked up my Excel program. So you've been forewarned.
Spreadsheet Tips From An Excel Addict is available only to subscribers
of my newsletter. If this newsletter was forwarded to you and you would
like to get your own copy, please visit TheExcelAddict.com or send a
blank email to theexceladdict(AT)aweber.com
If you would like to share this
newsletter with others...
Forward this newsletter by email, but first delete the unsubscribe link
at the very bottom so you don't get accidentally unsubscribed
2) Ask your
friend/colleague to visit TheExcelAddict.com or send a blank email to
3) Post a
link to TheExcelAddict.com in a company newsletter or website.
Some of the resources I recommend on my website and in my newsletter
pay me a small referral commission if you purchase from them through
links on my website or using my referral code. This helps offset the
costs of my website. I've worked long and hard to build up my
reputation online over the past 10 years as someone who provides
exceptional value to my readers. So I'm not willing to risk that for a
few dollars. As you know, I don’t just recommend anything. It has to be
of outstanding quality and value. If you are ever not completely
satisfied with anything I recommend, please let me know and I will get
your money back for you...GUARANTEED. You can't lose.