Navigation Pane
You can now turn on a Navigation Pane. Find it under View Menu. Shortcut keys: Alt W, K. This brings up a list of all the sheets in your workbook. Each sheet has an expand arrow, and if you click that it brings up a list of tables, charts, pictures, and sections of that sheet. […]
Clipboard memory knows what you just copied, and the thing before that as well…
I am generally not a fan of copying and pasting as it is usually an inefficient thing to do. But, sometimes it is helpful and if you are going to do it at least do it well. Did you know that everything you copy is stored on the clipboard memory? This means that you can […]
Line up – Use Align to get your graphs layout just right.
When you have graphs (Charts) or pictures in Excel and you want to get them lined up you can use Align. It is available on the Page Layout Menu (Alt, P AA) and also the Format Shape Menu. (Alt, JP, AA) You need to select the elements first. Use the Shift (or Ctrl) key (hold […]
Custom Number Format the rescue.
You can do a lot with custom number formats. One thing that is tricky is when you are presenting information and you want to have the units correct is allowing for 0 days, 1 day, 2 days. The lack of “s” when the unit is 1 is tricky, but can be sorted with a custom […]
Displaying Numbers just the way you want.
Displaying numbers in a cell is an important part of making your data easily readable. The way a number is displayed in a cell can be different to the data that is stored in the background. You can change the way the data looks by formatting the cell. Use the Number section on the Home […]
How to fit in… your data into a cell.
Fitting data into a cell can be tricky, but with a few simple tricks and tips, you can fit the data into the size and shape of cell that you want. Resize your columns. You can change the width of an individual column (or row height) by moving your mouse pointer to the line between […]
Powerful Filter Button Options.
Once you have added Filter buttons to your data, either via the home menu or because you have a table, you have a lot of powerful options on how to use them. Filter by Color – if you have colours on your cells, either from formatting or conditional formatting, you can use this to filter […]
Getting started with Filter buttons.
Add Filter buttons to your data in Excel using Sort and Filter, then Filter. Found on the Home Menu. (Shortcut keys: Alt H, S, F). If you make your data into a Table, then you get the Filter buttons automatically. Learn more about Tables here. If you add filters to your data, you can access […]
Get your life in order, or at least your data with Custom Sort.
To get your data in just the right order, use Custom Sort. Found on the Home Menu, under Sort & Filter. (Shortcut keys Alt, H, S, U). Make sure you have selected a cell within the data you want to be sorting, otherwise Excel gives you an error message. Once you have the Custom Sort […]
Get Sorted, with Sort
If you have data in a list and you want to change the order, then you need to Sort. The simplest place to find sort is on the Home Menu, Under Sort & Filter. (Alt, H, S, S) If you have pre-selected a cell in the column you want to sort by, just choose Sort […]