Page Layout

"Anyone who has ever done any Excel troubleshooting knows that one of the areas that causes people the most problems is printing, because Excel spreadsheets are often not only too long for one page, but also too wide for one page and therefore, Excel inserts both horizontal and vertical pages breaks which can make your data print in all kinds of strange ways if you don't understand how it works."

Labels: Tips

Combine Excel and Outlook

"The subs will send a newly created workbook with just the visible cells in the selection or range.
The cells will be PasteSpecial as values in the workbook you send.
It is saves the workbook before mailing it with a date/time stamp.
After the file is sent, the workbook will be deleted from your hard disk."

Labels: General, Internet, Macros, Tips, VBA

Samples and papers

"SIE is an electronic journal devoted to the publication of quality refereed articles concerned with studies of the role that spreadsheets can play in education. Our aim is to provide a focus for advances in our understanding of the role that spreadsheets can play in constructivist educational contexts.

Spreadsheets in Education (eJSiE) is a free facility for authors to publish suitable, peer reviewed articles and for anyone to view and download articles."

Labels: General, Reference, Tips, Tutorials

Concatenate Excel Outlook

Labels: Lists, Tips

Easy trick

Labels: General, Tips