Specializing in Advanced Spreadsheet & Office Macro Solutions.

PC Tips

PC Tips are FREE articles about useful tricks & tips on
how to get the most from your computer. Topics can be almost
anything, from the increasing security concerns to clever
tricks to improve your productivity.

Improve your Office and PC
capabilities the easy way - and for free!

New FREE PC Tips are published every month. Subscribe our newsletter and be warned whenever there are new
contents on OfficeHelp. Our newsletter is NEVER send unsolicited and
is only sent whenever there is something new. You won't bee
submerged by messages from us. Check our Privacy Policy for more
details.

An Excel AddIn is an extension to Excel and, once installed, will load every time Excel is loaded, becoming “part” of Excel until it is deliberately uninstalled. Learn how to install and manage them on all versions of Excel from 97 to 2007.

Macros are software applications that run inside other applications, like Office packages. While some very sophisticated macros are real pieces of Software, demanding professional developers, ANYONE can create their own automation macros in any of the Microsoft® Office applications.

Sometimes, it is nice to be able to keep some secrets from prying eyes. It is possible, in a very simple manner, to hide windows folders so that they don't become visible when browsing or searching the harddisk.

If you know how to print documents, then you can generate your own PDF files using the tools you already use to produce documents, like office suites. There are several alternatives, from the powerful official (paid) option of buying Adobe Acrobat full suite to free utilities capable of making them from your originals.

Do you use Outlook to store your email? Do you have email archives that include almost all your professional life from the last few years? If you're anything like most regular users, losing your email archives would be a professional catastrophe. Learn how to backup Outlook's data files on this tutorial.

Most large text documents are divided in chapters and need a Table of Contents. But making one manually is an annoyance and highly impractical. Change the text and you have to update all your page numbers. It is impossible to do without error for long, But there is a solution. Let Word do the Table of Contents for you, automatically - including page numbers and chapter title updates. Learn how on this useful 5-minute tip. Make more professional looking documents with this trick.

You open Outlook and get an worrying error message: your email / calendar / contacts file is corrupted and can't be opened. You've just lost everything on it!!! Well, not exactly. It is possible to recover the file, partially or even totally, usually with a small loss of the message that provoked the corruption. All with a free utility Microsoft (r) already included on Windows but forgot to tell.

Have you ever lost the work of a full afternoon? Just finishing your afternoon long document and the electric power fails. You remember to save regularly, didn't you? Oops. Learn how to make office automatically save your work every N minutes (you choose how many) in easy tip. Never loose your work again. Works with Word, Excel and PowerPoint.

Recognize the problem? You're typing a word document and the text is in a different format from another document or even part of the same document. You need to harmonize. So you need to check the format of the source document and manually apply each format to the new text, right? WRONG. It is possible to copy formats between blocks of text, from the same or different documents, as easily as copy/paste. Save time and trouble formatting professional looking word documents.

Ever read a professional document with numbered footnotes on the bottom of each page? Would like to replicate them on your Word documents? It is really easy, Word will even take care of the numbering for you. Learn how on this useful 5-minute tip. Make more professional looking documents with this trick.

Microsoft(r) Excel is one of the most widely used software's in the world and many use it intensively for advanced calculations and complex projects. Learn how to SAVE TIME AND EFFORT by preserving ALL your working context between Excel sessions.

The Internet is full of free software, but it’s not always easy to find what we want. Also, there is an increasing trend for the replacement of “Free” software with AdWare, advertisement supported software riddled with SPYWARE that will spy on your browsing habits and display annoying adds.

Browser Hijackers are small applications that auto-install from WebPages using bugs in Internet Explorer. They can redirect your browser home and search pages, or worst, send to their makers all keystrokes you make (including your passwords and credit card details).

Macros are useful software applications that run inside other applications, like Office packages, to allow for customization and automations of common tasks. However, there are some security risks associated with Macros. Therefore, to be able to safely run macros, the Office security settings may have to be properly configured.