Written by The New Paperclip on April 19, 2008 – 1:51 pm
Do you want to pretty up your spreadsheets just a little? Why not add a picture in the background! It could be a company logo, a nice relaxing beach landscape or a picture of your kids… whatever it is… it is really simple to add a background image to your spreadsheets in Excel 2007
Open up [...]
Written by The New Paperclip on April 19, 2008 – 1:42 pm
Are you like me and tend to write lots and lots in your cells in Excel 2007? It might be a good idea to make the text wrap.
What does wrapping text mean? Basically it is where you take one long line of text, and make it "wrap" around onto a number of lines instead. That [...]
Written by The New Paperclip on April 15, 2008 – 9:51 pm
It has happened to the best of us. Your day is going along great, and then all of a sudden you get an Outlook reminder… a reminder for that meeting you totally forgot about.
Now you just have 15 minutes to salvage something out of nothing and impress the boss/wife/colleague/all of the above.
Don’t want to get [...]
Written by The New Paperclip on April 15, 2008 – 8:30 pm
Yesterday I told you all about how you can use Merge and Center to get some text to run across a number of columns, rows, or both.
Well Jon Peltier quickly got onto the comments box and let us know about an alternative to Merge and Center in Excel 2007 called "Center Across Selection". It’s just [...]
Written by The New Paperclip on April 14, 2008 – 9:24 pm
Wonder how your favourite accountant/analyst/spreadsheet guru makes those cool looking headings that go across a number of columns and rows?
Chances are they are using a great feature of Excel 2007 called "Merge and Center". What does merge and center do? Exactly that - it merges all the cells you have selected, and then centres the [...]
Written by The New Paperclip on April 14, 2008 – 8:38 pm
Want to be a desktop publishing great, spreadsheeting wiz or PowerPoint guru and help the environment at the same time?
Guess what - you might be already!
Microsoft have released an extra section on Microsoft Office Online called Lighten up: Reduce your carbon footprint and workplace costs.
Obviously they left one tip for reducing your impact on the [...]
Written by The New Paperclip on April 14, 2008 – 8:24 pm
Have you ever noticed if you select some text in Microsoft Excel 2007 you get a little pop-up menu. You know the one, it lets you change the font, the font size, the font colour and a lot more.
Some people think it is great. Some people think it is annoying.
I think it is great, but [...]
Written by The New Paperclip on April 14, 2008 – 8:20 pm
Have you ever poured your heart and soul into absolutely awesome background in your word doc? Maybe you coloured it bright yellow, or purple, or ‘mother of pearl’?
It looks great on the screen, but when you print it… you can’t see it!
Did you know by default Microsoft Word 2007 that background colors and images [...]
Written by The New Paperclip on April 14, 2008 – 8:10 pm
How many times have you lost everything in your document? Word crashed? Maybe the power went out? Whatever it was that happened… I bet it happened just before you were going to save, right?
By default, Word 2007 makes an Auto Recover save every 10 minutes. But if you are clumsy like me, or don’t trust [...]
Written by The New Paperclip on April 14, 2008 – 7:50 pm
Have you ever noticed if you select some text in Microsoft Word 2007 you get a little pop-up menu. You know the one, it lets you change the font, the font size, the font colour and a lot more.
Some people think it is great. Some people think it is annoying.
I think it is great, but [...]