Printing cell comments

If you use cell comments in your worksheets, sometime you may want to print these comments. Most people think it can't be done. Excel does allow yo...

Print your entire Workbook

If you attempt to print the file you are working on, and you click on the Print tool on the toolbar, only the current sheet is printed by default.  I...

Mouseless tip on Excel Comments

To quickly insert a comment in the current cell, simply pressSHIFT+F2 and start typing. Don't like where it is positioned? Don't touch that mouse!...

Import data from Internet

If you have ever used data from Yahoo or Google in a data table have you retyped it in, or tried to copy and paste it? It either takes too long or the...

Resetting last used cell

Do you ever get reams of paper printing at the end of your worksheet?  Even if users have deleted their empty rows that they no longer use, when they...

Create time stamp

Many a times when you want to enter the date in a sheet, you would do it manually by using =today() or =now().  However these are volatile as this da...

UK Postcode Distance Calculator

I first put the attached file together some years ago, and I've mentioned it on one post here soon after I joined and have had a few PMs asking for a ...

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube