Friday, March 27th, 2015

Help! Excel Shows Columns as Numbers not Letters


change column numbers to letters in exce examplel Help! Excel Shows Columns as Numbers not Letters

What to do when Excel shows Column 1 not Column A

My Excel has been behaving stupidly lately. Instead of Column letters – A, B & C etc, the columns are numbered 1, 2, 3 and so on.

While I haven’t solved the fundamental problem I do have a short term solution. It all has to do with the Excel options. To change the column numbers back to letters chose File (the Office Button in Excel 2007) and choose Options > Formulas and disable the checkbox for R1C1 Reference Style.

change column numbers to letters in excel1 Help! Excel Shows Columns as Numbers not Letters

On the Mac click Excel > Preferences > General and deselect the Use R1C1 Reference Style checkbox.

Screen Shot 2015 03 25 at 7.03.00 AM Help! Excel Shows Columns as Numbers not Letters

This setting kicks Excel back into the correct mode – much more to my taste!

Of course, if you prefer seeing numbers and not letters all you need to do is to click the checkbox and you are good to go!

Saturday, January 17th, 2015

Open Recent Files Missing from Word (Mac)

Screen Shot 2015 01 17 at 5.02.14 PM Open Recent Files Missing from Word (Mac)

If your Recent files list disappears from your Mac, here’s how to put it back

Word on my Mac doesn’t have a recently opened files list but Excel does. Turns out the feature was disabled (or perhaps it was never enabled). Whatever the reason, it wasn’t there and I wanted it to be accessible.

Lucky for me it is just a preference setting. Click the Word button, click Preferences and then General. Look for the Track Recently Opened Documents option and enable it. Set the number of documents to track and click Ok. Yeah! Now you can open a recently opened file like you expect to be able to do.

Thursday, October 23rd, 2014

Calendar Wizard in Word 2013 – Yes!

Install Microsoft calendar wizard for Word 2013 opener Calendar Wizard in Word 2013   Yes!

Missing the Calendar Wizard in Word 2013? – no problem, here’s how to get it

Many years ago, Word had a wonderful Calendar Wizard that you could use to make calendar pages in Word. One really neat aspect of this Wizard was (and still is) that you can make calendar pages for any period of time – so you don’t have to wait till someone makes 2015 calendars for you to download – instead you can make your own and you can do it now! Hell you can make calendars for 2020 now if you want to really plan ahead!

In Word 2013 it might at first appear that the Calendar Wizard isn’t available – and it isn’t – that is, until you know how to make it accessible.

To start, download the cab file for the wizard from here: Microsoft Word Calendar Wizard Download for Word 2013.

Install Microsoft calendar wizard for Word 2013 1 Calendar Wizard in Word 2013   Yes!

Alternately, if you have an older version of Word on your computer, search for Calendar Wizard.wiz as you may have it on your computer somewhere already.

If you download the .cab file you’re getting a zipped archive format file which has to be opened. If double clicking it doesn’t launch an unzip program that can handle it, then download Express Zip File Compression as it can handle .cab files easily.

Install Microsoft calendar wizard for Word 2013 2 Calendar Wizard in Word 2013   Yes!

Extract the .wiz file (or copy it) to a folder of your choice or, better still, put it into your custom templates folder C:\Users\‹Username›\Documents\Custom Templates.

Install Microsoft calendar wizard for Word 2013 3 Calendar Wizard in Word 2013   Yes!

If you are doing this, then change its name when you do so – calendar wizard.wiz is (and was) a good name for it. If you found the wiz file on your own drive, make a copy to this folder.

T’hen double click the .wiz file to launch it in Word. If you put it in your Custom Office Templates folder then you can launch it from inside Word 2013 by choosing File > New, click Personal to view your personal templates and click to run it from there.

Install Microsoft calendar wizard for Word 2013 4 Calendar Wizard in Word 2013   Yes!


Tuesday, September 9th, 2014

Find Your templates in Microsoft Office – Mac

microsoft office template location on a mac Find Your templates in Microsoft Office   Mac

Need to manage your Microsoft Office templates but can’t find them?

It’s not easy to find the templates folder on your Mac. You might know it is My Templates but a typical search in Finder won’t turn it up.

Luckily help is at hand. Launch Finder and choose Go > Go to Folder. Now paste this folder name into the search box to go to your My Templates folder where you can now see and manage your templates!

~/Library/Application Support/Microsoft/Office/User Templates/My Templates





Wednesday, August 20th, 2014

A Great Microsoft Office Tutorial Resource

asgags A Great Microsoft Office Tutorial Resource

Great find! A list of good quality Microsoft Office tutorial resources

I’ve recently discovered an enormous list of Microsoft Office tutorials that may be worth checking out. Each piece of Office software has several listed tutorials ranging from beginner to advanced difficulty and general to specific usage.

Best of all, each tutorial has a brief summary of its contents so you can quickly decide if its new and interesting information. Hopefully every Office user will find something of use. You can visit the page here.

Thursday, July 31st, 2014

Force Excel to Recalculate a Worksheet

excel force recalculation of formulas worksheet ctrl alt f9 Force Excel to Recalculate a Worksheet

Help! My Excel formulas aren’t updating – how can I make Excel recalculate everything?

I have been working on a very large and very complex worksheet today. It uses a lot of custom functions to manage the calculations and as I was working on the functions I was plagued with a problem. You see Excel refused to update the cells that contained formulas based on my functions. It meant I was continually thinking that the problem was with my code. Sometimes the code was a problem but when formulas don’t update you just don’t get any visual feedback as to what is going on. I checked the Options to make sure that Calculation was set to be done automatically and it was.

excel force recalculation of formulas worksheet Force Excel to Recalculate a Worksheet

Turns out the problem is a known one and can happen in Excel. How horrible is that? Excel won’t recalculate? Wow! That’s like Word not spell checking or not letting you type the letter e!

Anyway the solution is to press Control + Alt + F9 to force every formula in the worksheet to recalculate. When you do this, it might take a while for it all to recalculate but at least the data will now be accurate!

Thursday, July 24th, 2014

Insert Text from a File into Word

pic1 Insert Text from a File into Word

You can quickly insert text from a file into your document using Word’s Text from File command. This used to be as simple as choosing Insert > File  but the command got hidden behind an additional layer of the UI in Word 2007, making it almost entirely invisible to most users.

To insert text from a file in all recent versions of Word, open the Insert tab in the ribbon and, in the Text settings find the Object button. Click the small arrow to the right of the Object button, and choose Text from File…. Choose the file you want and click Insert. The file type selection here defaults to Word documents only, so if you wish to insert a .txt file or other non-Word document, you’ll have to change the file type to your desired type or All Files.

pic2 Insert Text from a File into Word

If you insert a Word document it will include all elements of the document such as images and special formatting. If you wish to include the file’s header or footer (if it has one), you should insert the file into a new section of your document. Be careful when inserting multiple files with different formats, since text from one file may take on another file’s format if the inserts aren’t separated properly.

Monday, June 16th, 2014

Resize and Position Photos in SmartArt Placeholders

powerpoint size and position photo in smartart placeholder1 Resize and Position Photos in SmartArt Placeholders


Yikes! Just how do you resize a photo inside a PowerPoint or Word SmartArt placeholder

I got an email from a reader this morning. He has a PowerPoint slide (but it could as easily be a Word document or an Excel worksheet) and he wants to size a photo inside a placeholder. You see he was making an organization chart and he was dealing with lots of different head shots – all photographed differently. He wanted to make the faces the same relative size inside the placeholders – but to do this he had to get access to the photos inside the placeholders.

You see that’s the problem, every time you right click the placeholder and choose Size and Position you’re affecting the placeholder not the thing inside it! The solution is to use the Crop tool – so click on the placeholder and choose Picture Tools > Format tab and click the Crop tool.

powerpoint size and position photo in smartart placeholder2 Resize and Position Photos in SmartArt Placeholders

Now you get handles around your photo and you can drag the handles to resize the image and you can move it to change its position inside the placeholder. When you’re done, click Crop again to finish. Easy when you know how.

Monday, June 9th, 2014

Find the Recycle bin in Windows

recyclebin Find the Recycle bin in Windows

Help! My Recycle Bin just disappeared!

This is a major annoyance – your Recycle bin just ups and disappears from your Desktop. Well it’s easy to get back – when you know how.

Click the Start button and type Desktop Icons – wait as the search results appear. Click Show or hide common icons on the desktop to open the Desktop Icon Settings dialog.

Here you will find icons for common tools including the Recycle Bin. Click its checkbox to select it and click Ok to return it to the desktop. Notice too that you can add icons for My Computer, Your User Account files, Network and the Control Panel to your desktop  by simply clicking the appropriate checkboxes.


Wednesday, April 30th, 2014

Link an Image to a Web Page in WordPress

wordpress image hyperlink anchor opener Link an Image to a Web Page in WordpressStop stressing – here’s how to create a link from an image in

It’s dead easy to create an image as an anchor in HTML so, when a visitor clicks your image they are taken to a web page. The same cannot be said for a self hosted WordPress page – it’s ridiculously hard to link an image to a webpage until you know how it is done and then it is simple!

I made the mistake in the past of trying to edit the HTML myself. It was an exercise in frustration as WordPress just seems to knock the code out and link back to the image and not the page. I got it to work a few times but I’m blowed if I can remember exactly how. So, today, when I was editing a post my assistant wrote about free fonts that included pictures of the fonts I realized I needed to solve this problem and fast!

I wanted the font images to be linked to the download page – should be simple, but it isn’t.

Here is an image linked the way WordPress defaults to linking – it just opens the image in its own browser window – sucks!

return to sender0 Link an Image to a Web Page in Wordpress

Now lets look at what it should do – click this and it opens a new browser window at the download site:

return to sender0 Link an Image to a Web Page in Wordpress

The solution is part WordPress and part html hack!

To begin, when you go to insert the image into the post there is a link box – into this you should type the link you want the image to open when clicked.

wordpress image hyperlink anchor 1 Link an Image to a Web Page in Wordpress

Unfortunately this won’t open a browser window so you’ll then have to go to the HTML view and locate the image link and add the code after the image – the code is a simple target=”_blank” entry inside the tag itself as shown here:

wordpress image hyperlink anchor 2 Link an Image to a Web Page in Wordpress

Now, if you put an image into a post and forget to add the link all is not lost – in fact it works better. If you click on the image in Visual view you’ll see two icons, click the image icon to open up a screen which lets you edit the image code:

wordpress image hyperlink anchor 3 Link an Image to a Web Page in Wordpress

Now you can add the link code:

wordpress image hyperlink anchor 4 Link an Image to a Web Page in Wordpress

Then click the Advanced Settings tab and enable the Open Link in a New Window checkbox, then click Update and you’re done.

wordpress image hyperlink anchor 5 Link an Image to a Web Page in Wordpress

It’s not as simple or as clear as it might be but I’m willing to bet that this post will help out a  lot of struggling WordPress bloggers!

Helen Bradley

Thursday, April 10th, 2014

Make a Style that forces a page break in Word

word style with built in page break Make a Style that forces a page break in Word

If you always start a new page for a particular type of heading – include the page break in the style

When you always start a major heading item on a new page in a Word document you can configure your heading style so it has the page break built into it – saving  you having to insert it manually.

To do this, select some text with formatted with the style that is to include the page break and locate the style in the Style gallery. If it does not appear there, display the Styles and Formatting task pane by clicking the dialog launcher in the bottom right of the Styles area in the ribbon.

Right click the Style name, choose Modify and then Format.

Click the Paragraph option and then click the Line and Page Breaks tab.

Enable the Page Break Before checkbox and click Ok twice.

The page break is now part of the style so a new page will be started each time you use that style. The style will also update and effect any text already formatted using that style in the current document.

Helen Bradley

Wednesday, March 26th, 2014

Play and Burn DVDs in Windows 8

dvdimage Play and Burn DVDs in Windows 8© ugaldew,

If you’re using Windows 8 or 8.1 you can play videos and movie files you have stored on your computer but you can’t view DVDs using Windows Media Player—this feature was removed from Windows 8 along with the Media Guide.  If you want to be able to play DVDs in Windows 8 you will need to download and install a DVD player. If you’re using Windows 8 Pro then you can download and install Microsoft’s Windows Media Center which costs $9.99 – this site will step through the process. If you’re not using the Pro version then you would need to upgrade to Pro to use the Media Center, which ends up being a $100 upgrade  just for the ability to play a DVD. Instead, I recommend you use the free VLC Media Player.

If you need to burn DVDs you will need a DVD burner to do so. Windows 8 doesn’t ship with a DVD burner but that doesn’t mean that the manufacturer of your computer hasn’t provided one. Check the Start screen and see if there’s a DVD burner already installed. If not, here is a round up of some of the DVD burning tools around which are Windows 8 compatible. The good news is that most have free trial versions so you can test them out and see how they perform:

Wondershare DVD Creator — $39.95

Ashampoo Burning Studio Free — upgrade to full version for $49.99

Aimersoft DVD Maker for Windows – $39.95

Nero Burning ROM 12 – $49.99


Helen Bradley

Helen Bradley

Sunday, March 23rd, 2014

Easily Paste Web Content into Excel with Destination Formatting

opener Easily Paste Web Content into Excel with Destination Formatting

When pasting large data tables from your web browser into an Excel file you’ll probably be displeased to find that they do not match the formatting of the worksheet.

By default Excel will paste the data with the formatting it used on the source web page instead. This is rarely useful, since it’s very unlikely the web page had formatting that is compatible with your document. As you can see in the image above, using the source formatting can result in the inclusion of links, improper font and font size, and a number of other formatting issues.

To make Excel paste the data with destination formatting (i.e. the formatting of the destination Excel worksheet), you’ll need to add a special command to your quick access toolbar. To do this, select File > Options > Quick Access Toolbar. Above the left column, select the Choose commands from dropdown and choose All Commands. Scroll down the list and find Paste and Match Destination Formatting. Select it and click Add, then OK.

qat Easily Paste Web Content into Excel with Destination Formatting

Now whenever you wish to paste web data into Excel, click the Paste and Match Destination Formatting button in the Quick Access Toolbar instead of using the standard paste tool. This will result in the data being automatically formatted to match the look of the rest of your worksheet.

Helen Bradley

Helen Bradley

Friday, March 21st, 2014

How to Fix Excel Printing a Workbook to Multiple PDF Files

image opener How to Fix Excel Printing a Workbook to Multiple PDF Files

Learn how to  make sure that printing multiple sheets to a pdf gives one pdf and not many

If you have ever tried to print a large Excel workbook to a PDF file, you’ve probably run into this issue. You press print, Excel asks you to name the PDF, and then it begins to print. Everything seems fine, but then Excel asks you to name another PDF, then another, then another, ad infinitum. When the operation finally finishes, Excel has properly printed the workbook to a PDF format, but your worksheets have been split into several different PDF files. Some PDFs contain multiple worksheets, others only a single one, but all you really wanted was one PDF file with the entire workbook.

It turns out this issue is caused by having different Page Setup options on each worksheet. For example, Excel can’t print two pages with different paper sizes to the same “piece of paper” (actually a PDF in this case). Instead, it insists on having two different PDFs to print to, one for each paper size. So, to resolve this issue, you must make sure each worksheet’s page setup agrees with the others.

Fortunately, doing this is very simple. To begin, in your Excel workbook, right click one of your worksheet tabs at the bottom of the window and choose Select All Sheets. Any changes to the Page Setup options will now be applied to every worksheet.

image 2 How to Fix Excel Printing a Workbook to Multiple PDF Files

This means we don’t have to check each worksheet to make sure it has the same settings as the others; we simply choose which settings we want and all the worksheets will automatically match. To do this, go to the Page Layout tab in the ribbon. In the Page Setup section, click the small arrow in the bottom right corner to open the Page Setup dialog.

image 1 How to Fix Excel Printing a Workbook to Multiple PDF Files

The Page tab of the dialog contains the critical options that can lead to this issue, namely the paper size and print quality settings. Change these to whatever you wish, typically something like letter paper at 300 dpi. Other settings, such as orientation and scaling, do not cause the multiple PDFs issue so if you wish you can change them for individual worksheets. Still, it’s best to have all worksheets print with the same settings. Once you have chosen your desired settings click OK and they will be applied to every worksheet.

image 3 How to Fix Excel Printing a Workbook to Multiple PDF Files

You can now print your workbook to a single PDF file.

Helen Bradley

Helen Bradley

Thursday, March 20th, 2014

Create Your First Access Database – Pt 4 – Report Design

Database in Microsoft Access

Learn to create a database in Microsoft Access. This video steps you through the process of creating a report for your Access database file. In other parts of this series you can learn how to create the database, write Queries and create a Form for easier data entry.

For a text version of this video check out this article on my website: First Steps with Access

Helen Bradley

Helen Bradley

Page 1 of 3612345102030Last »