Excel spreadsheets often have a column or a row of incremental data. That is, information in the form of a list of numbers (1, 2, 3, 4, etc), times (09:00, 10:00, 11:00, etc), the names of months or the days of the week. You could type all this information into the row or column yourself, or you can let Excel handle it for you.

To try this out open Excel and type 1 in any cell, and 2 in the cell below it. For lists of numbers you need to enter a couple of numbers so that Excel knows where to begin and what interval to use.

Select both the cells (by hovering the mouse pointer over the top of one, holding down the left button, moving to the other cell and letting go).

You will notice that there is a small square in the bottom right hand corner of the selection box. If you hover the mouse pointer over this square the pointer will change to a + symbol. If you hold down the left mouse button and drag downwards Excel will fill in the cells continuing the series of numbers.

You can do the same with larger increments too. The images to the left show the same process being used to generate is a list of numbers with an interval of 10.

But that is far from all you can do with this process. You can drag these lists in any direction so that you can create rows as well as columns. Also, you are not limited to numbers; you can produce lists of months, days of the week, and times. I have included a video in this post showing this feature of Excel in action creating a few of these lists.

Microsoft has confirmed that the Office suite is once again under fire at the beginning of 2008. However, it seems that attacks only target the Excel component in a variety of Office versions. Concomitantly with revealing that a Critical, Zero-Day vulnerability is being actively exploited in the wild, the Redmond company provided assurance that users of the latest versions of the Office System are not at any risk from attack. Office Excel 2007, Excel 2008 for Mac, Office Excel 2003 Service Pack 3 as well as users that have installed Microsoft Office Isolated Conversion Environment (MOICE) are not affected by the vulnerability.

A member of the Microsoft Security Response Center revealed that: “a targeted attack exploiting a vulnerability in Microsoft Office Excel. Our investigation has shown that this vulnerability affects Microsoft Office Excel 2003 Service Pack 2, Microsoft Office Excel Viewer 2003, Microsoft Office Excel 2002, Microsoft Office Excel 2000 and Microsoft Excel 2004 for Mac. Microsoft Office Excel 2003 Service Pack 3, Microsoft Office Excel 2007 and Microsoft Excel 2008 for Mac are not affected as they do not contain the vulnerable code.” (more…)

A while ago I wrote 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 word. This technique can also be used to add any of the other available buttons onto the 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.

If you wish to bring up Windows’ file search minimise all your windows and press F3. You can also search within a certain folder too: open that folder up in Windows Explorer (the name for the program that opens when you double click on ‘My Documents’, ‘My Computer’, etc) and - you guessed it - press F3.

Pressing F3 opens search dialogs in many other programs as well: in Internet Explorer it opens (and closes) the vertical search bar; in MS Outlook it opens up the ‘Advanced Find’ dialog. Try pressing F3 when using applications that have some sort of search facility.

In a similar vein, you can open up the find facility in many applications by holding down the Control (’Ctrl’) key and pressing F. To explain the difference between search and find, consider that you will search for a web page and when you have opened it you can find text within it. In MS Word Ctrl + F opens the ‘Find and Replace’ dialog. As with F3, try it out in any program that has a find facility.

Of course some programmers use slightly different standards. For example in Firefox both F3 and Ctrl + F open the find word dialog at the bottom of the screen.

Happy hunting.