Excel - Creating drop Down Lists in Cells

Creating A Drop Down Lists For Users to Choose From In Excel

When you design an Excel workbook for users other than yourself to use you may find that it is helpful to provide drop down lists for some column values such as Status Codes, Categories, Response Codes, etc. This is surprisingly easy in Excel and requires no clever VBA code!

In the following example we can see a drop list that a user can choose from when populating a Country column value.

Excel - Transpose Columns & Rows

Make Rows the Columns and Make Columns the Rows In an Excel Worksheet

Have you ever found that you have a worksheet with a table of data on it, but you would really like the rows and columns to be switched round? In other words you would like to transpose the columns and rows.

Working with Tables in Microsoft Word - Part 1

Microsoft Word Tables

Microsoft Word offers a very powerful table feature, but it can be a bit of an art working with tables sometimes. In a series of blogs I aim to run through some simple, but essential tasks when working with tables in Word.

It is easy enough to copy and paste a data set into Word from a source such as a Microsfot Excel workbook as a lot of default formats are applied when the data is pasted, but formatting it to your requirements is then often the challenge.

In Working with Tables in Microsoft Word - Part 1 we will look at: