The ‘Go To’ and ‘Go To Special’ functions can help you audit your worksheet and also act as a tool to update values and make changes to your spreadsheet with the minimum fuss. From the Home tab, they can be accessed under ‘Find & Select’ from the Editing group. There are also Read More …
Category: Formatting
Show pivot table results as a percentage
If you want to display your pivot table values as a percentage of the total, there is a simple solution. You don’t need to create a new calculated field, you can just right-click the values, select Show Values As, % of Grand Total. As well as showing the values as a % of Grand Total, Read More …
Using the Quick Access Toolbar in Excel
If you have commands that you use over and over again in Excel, you can speed things up a bit by adding them to the Quick Access Toolbar in the top left of your screen. Rather than having to find the command in the ribbon, you are always just one click away. This Read More …
Keyboard shortcuts
Editing worksheets Inserting Showing / Hiding Formatting worksheets Menu options Moving / Scrolling Miscellaneous
Manipulating text in Excel
There are lots of cases where manipulating text in different ways can be quite challenging in Excel. Learning a few formulas and techniques can help you to overcome these challenges. TYPE function A common problem is distinguishing whether a cell value is in number or text format. You may have values that look like Read More …
Hide gridlines in Excel
A dashboard or summary in Excel often looks smoother without the gridlines in the background, here’s how to remove them. The quickest way to toggle between showing and hiding them is the following shortcut: Alt, W, V, G. The ribbon equivalent is to go to the View tab and de-select Gridlines.
Filter by current selection in Excel
There is a quick way to filter by your current selection using Excel. In this case we want to quickly filter for all football World Cups which Brazil have won. Click on any of the Brazil entries within the ‘Winner’ column Go to File – Options – Customize Ribbon From the ‘Choose commands from’ drop-down, choose Read More …
Why can’t I modify or delete my Excel custom slicer style?
Just a quick troubleshooting article on this one, as it can be a nuisance but it is very easily resolved. You may find that when you go to Modify, or Delete a custom slicer style you’ve created that nothing is happening. It will still let you Duplicate, but that just leaves you with a Read More …
Removing E+11 E+12 values in Excel
You may have seen numbers displayed as E+11, E+12, etc in an Excel cell, this is because Excel cannot display numbers with more than 12 characters. That includes fractions where the decimal places take it beyond 12 characters. With the cells in General format, these are displayed as scientific notation with the beginning of the Read More …
Excel found unreadable content in the file
This is an error that may pop up after you’ve pasted or formatted some cells. It is usually because you have used up the maximum number of different formatting combinations Excel can handle, which probably means you’ve spent a long time building a very complex workbook. So you might find yourself in a bit of Read More …