Unhide a particular column in Excel 2003

If you have several columns hidden (i.e. columns G:K) and you want to unhide just one (i.e. column H), here's a trick that will avoid you having to un...

Change the default number of worksheets

Here is the quickest way to always get your Excel workbooks to open with a default number of sheets to be as many (or as few!) as you want. For Excel...

Shrink cell data

Excel is kind of clever as if you didn’t already know.  Excel will automatically fit your data to your cells by shrinking it.  The data in the cel...

Create Controls at Runtime/Expanding Forms/Floating Toolbar/PTO Calendar

Hi All, I have been working on the attached project for a short time, and figured I'd share it with the group. To briefly summarize, my organizatio...

mirror

ever only been able to see your pc in the mirror?and you need to read things off the excel sheet? then this trick will enable you to reverse the workb...

Excel Scheduler Process to Run the Excel WorkBook Macro

In this program you can run Macro on Scheduled Day and Time. for example I am using a Macro to check the Local hard drive free space availability. For...

Change Column/Row Header Styles

click the Home tab In the Styles group, click Cell Styles. Right-click on the Normal style, and click Modify Click the Format button select the fo...

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