Monday, 7 September 2009

Spam comments

I have noticed a marked increase in comments left on this site that are little more than spam. I do not mind that people want to share links here, but I object to comments that contain little more than a list of links to commercial sites.

From now on such comments are subject to removal with no explanation. Please do not let this dissuade you from leaving short comments with a link to your blog or longer comments that refer to commercial sites where they fit in with the theme of this blog: computer help and advice.

Thursday, 27 August 2009

The 20th Carnival of Computer Help and Advice

Seasonal greetings and welcome to the twentieth monthly Carnival of Computer Help and Advice. Another digest of blog articles that help you to avoid problems with and to get the most out of your PCs.

I will let the first contributor introduce their own article. Josh Allison of Modern Geeks presents a "simple how-to on researching properly before buying yourself a new laptop or computer along with effective methods to not get conned." Find out more at How to research before buying a new computer or laptop. In a similar vein, Michel asks Apple Macs or PC’s? at Computer-Tech Blog.

After spending all your spare cash on a new computer, you may want to check out Pinyo's list of Best Free Essential Software For Windows posted at Moolanomy Personal Finance. You may also want to consider Mike Pettinato's article Turn Any Web App into a Desktop Application on his gadgetphix blog.

Staying on the subject of software. With the academic year about to start in many parts of the world, Allison Johanson of Best Online Universities.com. lists her 25 Must-Have Firefox Extensions for e-Learners.

Last up this month we have Jules Peters post that offers a variety of Windows Registry Maintenance Tips at PCauthorities.com. Jules says, "With the Windows registry being such a critical component in Windows XP and Vista, you should consider some actions to ensure the registry is optimized. Here are a few tips."

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.

Drop by next month for another selection of blog articles.

Monday, 27 July 2009

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.

Thursday, 9 July 2009

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.

Saturday, 27 June 2009

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.

Tuesday, 16 June 2009

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.

Friday, 12 June 2009

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.