Category Archives: MS Office 2003

The task was to use text files that are created by an external program on a daily basis to create a workbook that contains those files’ data in monthly spreadsheets. The good thing is, the text files were named ‘DATAYYMMDD’, … Continue reading

Posted in Excel, MS Office 2003 | Tagged , , , , | Leave a comment

Let’s assume, you got 12 worksheets named with year and month. Each sheet contains several values for every day. To put them all together I recommend a combination of the Excel functions CONCATENATE and INDIRECT (the real dynamic duo if … Continue reading

Posted in Excel | Tagged , , , , , | Leave a comment

Getting rid of old calendar items that waste storage capacity is easy.

Posted in Outlook | Tagged , , , , | Leave a comment

Setting up a workbook Open Excel and create a blank workbook. The default settings will create three Worksheets, that’s enough. My personal settings only create one sheet, the others are inserted by ‘Insert->Worksheet’. For the beginning we need two sheets. … Continue reading

Posted in Excel | Tagged , , , , , | Leave a comment

Within MS Excel one can adjust the height of a row by dragging the boundary below the row heading until the row is the wanted height or double-click the boundary to get an automatically adjusted height that fits the content. … Continue reading

Posted in Excel | Tagged , , , , | Leave a comment