📞 01223 214177 ✉️ karen@roem.co.uk
Since Excel 2007 you can quickly turn a range of cells into something resembling stock listing paper that mainframe computers used to print out. (Remember those faint green horizontal lines?) It will also switch on the filtering functionality, making it easy to summarise and analyse your data. It used to be called a list, but it is nowadays known as a table. Hence the fact that both CTRL + L and CTRL + T work to quickly create a table. (See tip_429.php.)
An Excel table can be thought of as a database. With it, you can store large (or small!) amounts of information and organise it anyway you wish. You can also use its powerful Table Tools to quickly retrieve data and manipulate it in numerous ways.
A table typically contains of rows and columns, which you can obviously select just like you would select them in a worksheet. But if you want to select the data only - for example, in order to copy and paste it - you can use some simple keyboard shortcuts.
Here's how:
Related tips:
* Unless stated otherwise, these tips were written for Microsoft Office 2010.
I’m committed to sharing the best of what I know with others so please don’t keep me a secret. If you enjoyed today’s tip, please forward it to anyone you feel may benefit. Alternatively, feel free to reprint it (with full copyright and subscription information) in your newsletters and message boards.