The 18th Carnival of Computer Help and Advice

Welcome to the eighteenth monthly Carnival of Computer Help and Advice. Another digest of the best blog articles published recently that help you get the most out of your PCs.

We start this month with regular contributor, Andrew Edgington, who submitted his article Adobe Photoshop Elements Tools - Restoring Old Photos Tips from Master Adobe Elements.

for those who struggle to keep on top of all their computer files, help is at hand. As part of her 7-day guide to declutter your life, Suzanne at Without Dash presents Day 6 - the computer.

Next, a couple of OS specific posts. Jules submitted a tutorial explaining How to Fix Sound Recording Problems in Vista on PCauthorities.com. Collection of Web Freebies author, Nesher, lifts the lid on a largely unknown aspect of XP in the article How to run Windows XP as SYSTEM User?

Justin Acton of JustinActon.com provides a useful tutorial that demonstrates how to Add/Remove Items On SendTo Menu.

To offer a century of tips in one blog post is no mean feat; however, our next two contributors have managed it with some aplomb. Sarah Scrafford lists 100 Firefox Add-Ons to Create a Truly Brilliant Browser at Select Courses, and security-minded Alvina Lopez of the e-Justice Blog offers 100 Tips, Tools, and Resources for Locking Down Your PC.

I will let Ivan, our next contributor, explain his own post:

"Let’s assume you’re at work or at school and you’re on the computer. There’s an enormous chance that you have no administrative privileges and there’s absolutely nothing you can install onto the computer. Let us also assume that you want to use Mozilla Firefox instead of IE. That’s an easy one, ’cause we’ve all heard of Firefox Portable. Finally you download Firefox and you’re happy how you fooled Windows. So you’re browsing and you go to youtube. And what happens? You need to install the Flash Player. Damn… What now…"

Find the answer in Ivan's post Install Flash Player without having administrative privileges at PC Hacks.

If you have posted an article offering computer advice that you want to submit to the carnival then use the form over at our Blog Carnival page to submit it for consideration. If you would like to host a future carnival then please leave a comment on this post or on the carnival page. If you don't wish to have the responsibility for selecting articles or writing the carnival post, don't worry I can do that for you.

Read More

Printing from Excel - Part 2

In the last post I showed how to format an Excel sheet so that it fitted to the page and added page numbers. The end result as displayed in Print Preview is as shown here.


As we can see there are no gridlines on the print. We can either remedy this by selecting border types on the table or, more easily, we can set a print option to show simple gridlines. To do this go to Print Preview, click the 'Setup...' button and select the 'Sheet' tab. Here, I select the Print Gridlines option, as shown.


After I click 'OK', the Print Preview looks like this. I have zoomed in on the preview so that you can see the gridlines more clearly.


The above is a preview of page 2, where we can see that there are no column headers as there are on page 1. We can tell Excel to print the column headers on each page to make the print of the table more user-friendly. To do this I need to close the Print Preview, and select 'Page Setup' from the 'File' menu, which enables some extra options. On the 'Sheet' tab I click the circled button.


This opens the following option box. I now click the row that I want to repeat. In this case it is row 1, so I click the appropriate button as circled in red, and close the option box by clicking the button circled in green. This will enter the appropriate code into the 'Rows to repeat at top' option. After, I click 'OK' I have a well formatted spreadsheet ready to be printed.


As you can see there are a number of other options that I have not explored here. If you have a document that prints on many pages you may want to click the 'Margins' button and adjust the size of the print area by clicking and dragging the various dotted lines, but be careful to leave enough of a margin around the table so that the print is not ruined - at least a centimetre (or about half an inch) should be enough. If you have a particularly wide document you may not be able to fit it onto one page width, in which case you can also set the print to repeat columns in much the same way as I did for rows. Printing Excel spreadsheets may be a fiddly business, but with a little effort you can achieve some very good results.

Read More

Printing from Excel - Part 1

Printing from Microsoft Excel is markedly different to printing from Word. Whereas in Word we can usually just tell it to print without worrying that much about formatting the page, in Excel we will usually have to specifically tell it how we want to print our speadsheets, and this can sometimes be a little fiddly. Because there is quite a lot of fiddling that can be done I have split these instructions over two posts.


Pictured above is an example of a spreadsheet - in this case a dataset of U.S. population information. Exciting, I know. When I press the Print Preview button [pictured right] I see the following:


As we can see, not all the columns are shown on the first page. If I go down to page 6 we can see the missing column.


To remedy this situation I click the 'Setup..' button in the Print Preview. This opens up the following option box.


I could change the orientation to 'Landscape' as this would enable the missing column ; however, for the purposes of this tutorial I will keep it set to 'Portrait'. Instead, I reduce the scaling until the final column appears on the first page. In this case I set it to 80% of normal size.


I could also have achieved the same result by selecting all the data and reducing the font size, the column width and row height; although I find adjusting the scaling to be easier. The Print Preview now looks like this:


As yet there are no page numbers shown. In order to have page numbers displayed I click 'Setup..' again and open the 'Header/Footer' tab. Here I can select whether I want the page numbers to be shown at the top or the bottom of the page by choosing an option from the appropriate drop-down list, two of which are shown below.


As you can see from the drop-down lists, there are other options available for what will be displayed in the header or footer, including file name and date. I now have a serviceable format for my document that I can print out. At the same time I have reduced the number of pages from ten to four. There are a number of other print formatting options available that I will explore in the next post.

Read More

Finding lost documents

We have all done it, saved a document and then immediately forgotten where we saved it and what we called it. Fear not, help is at hand. Some applications will keep a short list of recently opened documents, which can usually be found in the 'File' menu. This should at least identify the name of the file, which you can search for. To save time, rather than search for this file, it may be easier to save it again in a more memorable location.

Much of the time, we created the lost file a while ago, and because we have created other files since then, the lost file is not mentioned in the list of recent documents. So, we have to use the Windows search tool.

Please note that the following instructions do not apply to Vista. For a walk through of the new search tool that Microsoft implemented on Vista, see this article at PC Magazine.

To open the search tool, open the Start menu and click on Search, or simply press F3 when you don't have any windows open. If you are using XP, you may be greeted with a choice of what you want to search for. Click on 'All Files and Folders', if not you will be taken straight to this screen.

Remember: change the 'Look in' field to 'Local Hard Drives', if it is set to something else. If you use networked drives, you will also have to search these as well, by selecting them from the list and repeating the search.

If you can remember some of the text from the documents, or some keywords that are unlikely to be in many other documents on your hard-drive, you can use the 'Containing Text' field. Simply type a keyword or phrase into it and click 'Search Now'.

If you cannot remember any of the content of the document you will have to cast the net wider. You can search for files of a certain type, for example, if you type *.doc into the 'Search for files or folders named' field and click 'Search Now', Windows will find every Word document on your computer [Note: if you are using Word 2007 the default file extension is now 'docx', so you would search for *.docx]. So, to search for Excel files use *.xls for Adobe Acrobat files use *.pdf and so on.

Sometimes, searching on file type will produce a long list of files, to narrow your search, you can select a date range. To do this click on 'Search Options' and tick 'Date'. You will be presented with a series of choices, the most important of which is the first where you can select whether you want to search for files that were modified, created or accessed within the time period you choose. Select suitable options depending on what you can remember.

If you use Microsoft Outlook (not Outlook Express) it may be worth looking in the 'Journal'; this contains a log of various tasks you have carried out on your PC such as creating new files. If it is not switched on, you may wish to do so if you are prone to losing files or wish to keep tabs on your PC usage.

If you wish to have a file search tool with more features you could try the freeware program Fileseek from Binary Fortress Software.

Read More

The 17th Carnival of Computer Help and Advice

Welcome to the seventeenth monthly Carnival of Computer Help and Advice. Another collection of blog articles to help you avoid problems and get the most out of your PC.

He start this month with some relief for Vista users. Krissb explains how to get rid of the annoying dialog box that opens everytime you want to perform some sort of administrative task. See the Get rid of the UAC! article at SEEPEYU.

Jules of PCauthorities.com says, "If you are using Microsoft Outlook for your email, then there is a simple add-on from Microsoft that can help you make regular backups." To find out more go to Backup Outlook PST Files.

We often include articles about Firefox hacks in this carnival. This month's supply comes from kemei, who presents 8 ways to hack Firefox to load faster posted at infomaniac.

On ths subject of Internet apps, Ivan at PC Hacks has written an excellent article that answers the question, What Is A Proxy Server And How To Use It?

"For those of you, who have to work for long hours on the computer, your eyes are put to undue strain. Here are a few tips on how to relax them." So says Aparna of Beauty and Personal Grooming. Do yourself a favour and see that article: Eye care for computer users.

For those of you who have made the switch to linux or are considering making the move, Yonit Gruber-hazani lists 13 books and magazines for linux sysadmins at yonitg.com.

We round up this month with a post from regular carnival contributor, Andrew Edgington, who presents Adobe Photoshop Elements Tools - How to use the Smart Brush on his Master Adobe Elements blog.

If you have a blog with posts about computer issues and would like to host the next carnival then please leave a comment on this post or use the contact form over at our Blog Carnival page, where you can also submit your blog posts for inclusion in a future carnival.

If you would like to host a future carnival but don't wish to have the responsibility for selecting articles or writing the carnival post, don't worry I can do that for you.

More next month.

Read More

Putting new buttons on toolbars in MS Office (before the 2007 version)

A while ago I published an article that suggested that rather than printing directly from web browsers, such as Internet Explorer, it is better to copy the information that you want into a word processor and print it from there. In that article I mentioned the use of the 'Paste Special' in Word, which enables you to remove formatting from the information that you paste. In this article I will explain how to put a button for 'Paste Special' onto the toolbar in Microsoft Word 2003 and other earlier versions. This technique can also be used to add any of the other available buttons onto any toolbar.

Open up Word and right-click on one of the toolbars, which are at the top of the screen below the menu and look something like this:


From the menu, select 'Customize...', which will open a dialog box. Click on the 'Commands' tab.


Select 'Edit' from the left-hand menu, because the 'Paste Special' tool is listed in the 'Edit' menu. Scroll down through the list on the right-hand until you see 'Paste Special' then left-click on it and hold the mouse button down. The mouse pointer should change to an arrow pointing at a rectangle with a square to the bottom right, which will have an X in it initially.

Move the pointer up to the toolbars and release the mouse button when it is in a suitable position: next to the normal paste button for example. You will notice that the mouse pointer changed appearance again when you hovered over the toolbar, with the X being replaced with a + to let you know that the new button can be placed there.

Your toolbar should now look something like this:

If you wish to remove a button from the toolbar, follow the instructions above for opening the 'Customize' dialog, but rather than drag from the dialog box to the toolbar, click on the button you wish to remove from the toolbar and drag it into the dialog box.

This process also works in the other Microsoft Office applications such as Excel and PowerPoint. With Office 2007, Microsoft have replaced the old tried-and-tested menu and toolbar arrangement with something called 'ribbons' (as pictured below) and there is no way to customise these in the same way as detailed above.

This is an edited version of a post that first appeared on Bloody Computer! on 19th November 2007.

Read More

How to password protect any file in Windows XP

Certain applications, such as Microsoft Word, enable you to password protect your files. Nevertheless, the zip functionality that is built into Windows XP enables the user to password protect any file by compressing it using a password. If you have an alternate compression application, such as WinRar installed then you can also use that to password protect files on any version of Windows.

To do so, right-click on the file you wish to password protect and select 'Send to...' From the sub-menu that pops up select 'Compressed (zipped) folder'


This will create a zip file with the same name as the original file.

Right-click on this zip file and select 'Explore'. This will open the file in a new window. From the 'File' menu select 'Add a password'.

Type the password in twice and click OK

Delete the original file, and for extra safety, empty your 'Recycle Bin'.

You may see the following message if you have another compression application installed. If so, just click 'Yes', and carry on as above.

Read More