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 ...

At one point, Pivot Tables were the greatest feature in Excel, but as with most tools and tricks, that’s no longer the case. Instead of setting up a Pivot Table, adjusting the layout, and refreshing ...

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

Embarrassing confession time: I never learned my multiplication tables in grade school. Sure, I had the easy tables like the twos and the fives down, but if asked what 4 x 7 or 8 x 6 was, I’d draw a ...

How to use VBA to modify tables in Microsoft Word Your email has been sent Image: PixelMe/Shutterstock Must-read Windows coverage CrowdStrike Outage Disrupts Microsoft Systems Worldwide 10 Best ...

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 ( ...