The 19th Carnival of Computer Help and Advice

Welcome to the eighteenth monthly Carnival of Computer Help and Advice - a digest of recent blog articles offering advice on safer and easier computing.

We start this month with a couple of articles about Microsoft Office applications. Excel Matic author Mohit Khurana presents a tutorial explaining How to calculate subtotals using Array functions; and, MrGroove shows How To Delay or Schedule Delivery of Email Using Outlook at groovyPost.com.

For those of you considering purchasing a new computer, Michel of Computer spot/Tech zone offers the first part of a series of articles offering advice about How to buy a computer without getting ripped off. Meanwhile, MikeM presents a Netbook Computer Primer posted at HTS Tech Tips - Computer Tech Tips for Non-Geeks.

Microsoft recently launched their new search engine called Bing. To help users get the most of the innovative features offered by this new search engine, Margaret Garcia published 50 Tips & Tricks for Researching with Bing at Becoming a Computer Technician.

We finish with some practical advice from Mick Hart for anyone wanting to improve their digital photographic portraits. See his tutorial Adobe Photoshop CS4 Tutorials - Creating Awesome Eyes posted at Photoshop Revealed by David Peters.

Many thanks to all those who contributed articles for the carnival.

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

Customising the Quick Access Toolbar

In a recent post about adding buttons to the toolbars in Microsoft Office applications I pointed out that there is no way to add buttons to the new 'ribbon' that has replaced the old toolbars. Nevertheless, it has come to my attention that there is still one customisable toolbar in the latest versions of Word, Excel and Powerpoint. This is called the 'Quick Access Toolbar'. If you wish to add extra buttons to this toolbar you can do so by following the instructions on the 'Microsoft Office Online' pages. [http://office.microsoft.com/en-us/word/HA012341051033.aspx]

I do not have a copy of MS Office 2007 myself, so I do not know whether you can add a button for the useful 'Past Special' function. If you have a copy of any of the Office 2007 applications, please let me know how you have got on when adding buttons to this toolbar.

Read More

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