Skip tables when you need spilled results, presentation-ready layouts, one-off modeling logic, or stable protected data-entry templates.

I've written many times about the many benefits of formatting your data as a structured table in Microsoft Excel. However, despite this, there's one major issue that continues to throw a spanner in ...

If you are working with Excel spreadsheets or workbooks, juggling multiple tables of data, at some time you might need to combine them into one. Rather than spending hours manually copying and pasting ...

Excel validation lists avoid blanks and errors with TOCOL(ignore) plus FILTER; the spill range stays stable across worksheets.

How to align tables using Quick Tables in Microsoft Word Your email has been sent The article How to control a Word table’s horizontal alignment shows you how to manually align tables between the left ...

If you’re running Mac OS X 10.4, there’s no reason to fire up Microsoft Word or Excel if you just need a simple table. You’ve got access to a pretty handy built-in tables feature in Apple’s TextEdit ( ...