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 there wasn’t one before).
2009/06/16
2009/06/05
Excel: Creating a budget sheet
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. These are renamed (rightclick on tab->Rename) to ‘budget’ and (for actual reasons) ‘2009′. Then go to ‘File->Save as…’ and save it.
(more…)
2009/05/28
Excel: Automatically adjusted row height of merged cells
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.
This is true for single column, non-merged cells, whereas the first method also applies to merged cells. But imagine a 300 row sheet. I would not want to drag every row to a certain height after changing the font size. One could say: “Alright, I’ll just select the whole sheet by clicking the field left to A and above 1, drag one row to a height that fits the maximum height.” Lots of empty spaces. Does not look good.
Anyway, in writing the document just add a simple step.
(more…)