Doing it in Style…
The Style section on the Home Menu gives easy access to set formatting for cells that can be a good place to start. There are a number of set options you can select from rather than having to customise your own formatting. There are also some common number formatting options. Comma [0] and Currency [0] […]
Back to basics continued, more formatting options.
Carrying on with some basic formatting using the Number section on the Home Menu. You can format a cell to be Time. There are a number of different options to choose from for how the time is displayed. To access the first three for these options use the More Number Formats and then the Time […]
Back to basics
It has been just over a year since I started writing Excel Tips once a week. Going back over what I have written about, I have realised I haven’t covered some of the most basic/fundamental features in Excel. So, that is my inspiration for my next few blogs! On the Home menu, is a section […]
Freeze, in the name of being able to see what is what.
When you have a large sheet and you want to be able to see the top rows, even if you have scrolled down, then Freeze Panes is your friend. For example, if you have headings in the top row and want to be able to see them, even when you are at the end of […]
Make your spreadsheet look less like a spreadsheet.
If you want your spreadsheet to look less like a spreadsheet, or you want more space for your data when showing it to others, then you can make a big difference with a few clicks. Turning off the gridlines and the headings (the letters across the top, and the numbers down the side) can make […]
Pivot Tables are amazing!
I was reminded again this week how great Pivot Tables are. If you haven’t used these little beauties in your Excel workbooks you might be missing out. Sometimes, they can require a little bit of manipulating to get your data into a state that is ready for a Pivot Table, but it is totally worth […]
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 […]
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 + […]