Home » Tables

Tag: Tables

turned on black and grey laptop computer

Excel Tables

turned on black and grey laptop computer

Managing, analysing and referencing lists of data becomes easier when you know how to use Excel Tables.

There are so many advantages to using Tables which I will cover within this post. Once you see how helpful they are I’m pretty sure you will be using Tables a lot.

When you insert a Table over a list of data Excel automatically takes over and applies many features for you. You will also have many tools for working in lists made available to you on a contextual tab, making working with lists so much easier. Continue Reading

graphs of performance analytics on a laptop screen

Finding and removing duplicate data in Excel

graphs of performance analytics on a laptop screen

Finding and removing duplicate data in Excel can be a quick process. However, for many people who haven’t learnt how to do this the quick way in Excel, it can be an absolute chore.

One of the many things I love about my job is that I get to work with so many different people from all kinds of organisations. However, it doesn’t matter what industry or region I’m working in the challenges of working with large lists of data are pretty much the same.

Continue Reading
person holding white printer paper near black laptop computer

Excel – How do I merge cells within a range that is formatted as a Table?

person holding white printer paper near black laptop computer

PROBLEM: when I use “Format as Table” to format a range the “Merge and Center” button becomes inactive and I can no longer merge cells.  Why?
SOLUTION: the Table format will stop the merging of cells.  However there is a work-around.

The Format as Table command can be used to quickly apply a professional format to a selected range.  However, in applying the format you are also applying the functionality that Tables offer.  As a result you will no longer be able to merge cells. Continue Reading