Are you an accountant or bookkeeper? Don't let an Excel problem interrupt your workflow
Over 5 920 Excel questions are searched on Google in South Africa every month...
If you're adding to that statistic, you'll know how hard it is to find a solution that specifically relates to your Excel problem.
But not anymore!
Get Excel guru, Adrian Miric to solve it in the next five minutes.
We're only interested in the data in the red block below and want to quickly get rid of the other rows (and keep in mind that this pattern repeats itself over the next 300 pages of the report).
Keep reading to learn how to clean up your spreadsheets before you format them.
How to use the AutoFilter tool
Instead of going through the entire spreadsheet and deleting the unnecessary data, you can use the AutoFilter tool. Select the area you want to format, and click the Data tab and the click the AutoFilter button.
The logic is that you filter out the data you don't want. So you select all the rows you want to delete.
At the end of the formatting, I only want to display sales people's codes. So I select all the data that I don't want – and unselect sales peoples' codes.
When you click OK
you'll see all the rows that you want to get rid of as shown below.
Now highlight the rows you want to get rid of and click Delete Row. To highlight the whole row, click on the row numbers as opposed to highlighting the cells (click blue numbers on left hand side).
Now select Data - > Filter -> Clear
You'll see that in one step you've removed all your unwanted rows. Now you only display the content you want to display.
And that's how I helped this administrator clean up her data in minutes. Use this tip to clean up any of your Excel databases. And keep an eye out. I'll send you a bulletin every month to give you tips and tricks to make working in Excel much easier. I also run Excel seminars specifically geared towards helping finance professionals use Excel efficiently. Email email@example.com
to find out what's currently running.
Until next time,
Want to learn tips and tricks to halve the time it takes you to do basic finance tasks? Join me at the Excel for Beginners Workshop
in July. Email firstname.lastname@example.org
to get your name on the hotlist and be the first to receive confirmation that bookings have opened.