Text to Columns to the rescue!
I have had two times in the past couple of days when I have needed to use Text to Columns. It is a niche tool, but so good when it is needed, saving a lot of time compared to doing things manually. So, what did I use it for? Splitting text in one column into […]
10 Excel features you need to know – Webinar
Thanks to Te Awamutu Chamber of Commerce for hosting me. I presented my “10 Excel features you need to know”. A recording of the webinar is on YouTube. Check it out!
Stop people messing with your cells.
If you share a workbook with others and want to stop them changing the sheet cells you can protect the sheet. By default all cells are protected. If you want to allow them to enter information in some cells, but not others, then you need to unlock the cells to allow them to be changed. […]
Fitting data into a cell and getting it just right.
When the information you want to enter into a cell is too long for the width of the cell you would like, you can use Wrap Text. This will fit the information to the cell by expanding it down to fit. Another great trick to know about is Alt + Enter. When you would like […]
Save time, fill across worksheets
You can copy the same data into multiple worksheet in one go. Select the data to copy.Hold down Ctrl and select worksheets to copy to.Go to the Home menu, find the Editing section, Chose Fill – Across worksheets. Be careful to unselect the sheets before you do anything else. Do this by clicking on an […]
Center Across Selection instead of Merge and Center.
Instead of using Merge and Centre, try using Merge Across Selection. It makes highlighting easy and formulas more logical. The results look the same, but what is happening in the background is different. Below is how most people will put a title across multiple cells, by using the Merge & Center button. Notice the green […]
Filter a graph the easy way
You can filter a graph, right on the graph. Select the graph and choose the filter button. Choose which series or categories you want to be able to see. Select Apply.
Two very handy shortcut keys for charts.
There are two particularly useful shortcut keys are when using an Excel chart (graph). Use Ctrl + Left or Right arrow keys to move through selecting each chart element. Great for getting to the point you want when it is close to others and hard to get just right with the mouse. Use Ctrl + […]
Get your information here!
Excel includes Data Types that can get information from the internet and put it straight into your spreadsheet. You can choose from twenty different types of information, including Stocks, Geography, Food and Movies. Type in the thing you are interested in, select which data type you want it to be, and use the Insert Data […]
Be Unique
The UNIQUE formula, in #excel, makes short work of removing duplicates from a list. It comes in two main formats, determined by the third input. You can totally remove any items that appear more than once in your list, as below, or just keep one copy of each item. =UNIQUE(The range that has the values […]