Enter Numbers Starting with Zero in Excel
If you’ve ever tried to enter a number starting with zero into an Excel spreadsheet, you will have had the Read More
Megan Casey
About Megan Casey
Posts by Megan Casey:
Line Ends on Dashed Picture Borders in Word and PowerPoint
One of the more obscure settings when putting a frame around a picture in Word or PowerPoint is the Cap Read More
Picture Frame Corner Types in Word and PowerPoint
Join Type is what Microsoft calls the corners of the picture frames – the place where the horizontal and vertical Read More
Multi-Line Picture Borders in Word or PowerPoint
Word and PowerPoint have some great ways to add a border or frame around an image, graphic or logo. We Read More
New Zealand Flag into Word, Excel or PowerPoint
Find and add the New Zealand national flag and alternatives into Office documents, Word, Excel or PowerPoint, then use some Office picture tools to enhance the Read More
Canadian Flag into Word, Excel or PowerPoint
Get a hi-res version of Canadian National flag into Office documents, Word, Excel or PowerPoint, then use some Office picture Read More
Add the Australian Flag into Word, Excel or PowerPoint
Find and add the Australian National flag, Aboriginal flag and other Aussie ensigns into Office documents, Word, Excel or PowerPoint, Read More
Create Barcodes in Word
Once you start delving into Word, you find it can do all sorts of things that you wouldn’t expect. One Read More
IF and Nested IF Statements in Excel
An IF statement might sound like a complicated thing that programmers do, but it’s actually fairly easy to do in Excel. An Read More
Change Margins in Word
Sometimes we want to change the margins around a Word document, either to change the way the page looks, or Read More
Hiding Text in PowerPoint
PowerPoint has options for hiding slides and also hide & reveal text or content within slides. We have looked previously Read More
Hidden Text, Images and objects in Word
We have recently discussed how to show hidden formatting characters in Word, but it is also possible to hide text Read More
Hidden text positioning and formatting tricks in Word
Word is very clever dealing with Hidden text, perhaps a bit too clever at times. Here’s some tricks for positioning Read More
Find and Remove Hidden Text in Word
If you want to remove hidden text from your Word document, you first need to find it. For a shorter Read More
Outlook Profiles, important and useful but little known
Outlook profiles is one of the most important but least known parts of the program. Profiles can be very useful, Read More
Hiding Columns and Rows in Excel
Make your worksheets look more compact and focused by hiding unwanted columns or rows. Hidden rows/columns still work in calculations, Read More
Hiding Cell Contents or Formulas in Excel
If you have data in Excel that you don’t want to be visible, but you still need to be able Read More
Understand the Show All markers in Word
Here are the major marks Microsoft Word displays with the Show All option on. Paragraph Mark, the symbol is called a Pilcrow. It’s the symbol used for the ‘Show Read More
Show Hidden Characters in Word with Show All
If you are working on a Word document with complex formatting, sometimes you need to see the hidden characters and Read More
Using 3D Formulas to range across Excel worksheets
3D Formulas in Excel allow you to make calculations using data from many different worksheets, including ones that don’t exist yet. This can be Read More
Office Watch
Office for Mere Mortals
Twitter
Facebook