August 2012

Changing a negative value into a positive value in Excel

Thursday, August 16th, 2012

Written by Jane Hames

I was doing some analysis on my banking this week (hmmm, not the most exciting job!) and decided to export the month’s transactions into Excel so that I could separate my incomings and outgoings more easily. The outgoings were displayed as negative values which is what I would expect. However, I wanted to be able to subtract my outgoings from my incomings to check the balance.

How can I shrink text to fit a page in Word 2010?

Thursday, August 9th, 2012

Written by Jane Hames

I deliver a lot of Microsoft Office upgrade training and I have been asked this same question several times recently: “From the Print Preview, in older versions of Word, I used to be able to shrink the text in a document onto one page. The option doesn’t seem to be available in Word 2007 and 2010.”

Autofill is creating a series and I just want to copy data!

Thursday, August 2nd, 2012

Written by Jane Hames

Many Excel users make use of the Autofill feature for copying formulas or entering days, months, dates or other things that form a series. There are occasions when users want Excel to ignore the fact that the value is part of a series so that rather than create the series, it just copies the value.