Forum Discussion

Kollox's avatar
Kollox
Contributing User
5 years ago
Solved

Reports Filtering in Excel

My question actually relates to all Myob reports exported to Excel. Unlike Myob Premier Classic we are not able to filter reports exported from Myob to Excel. This has always been useful. It would be ...
Desktop
  • Mike_James's avatar
    Mike_James
    5 years ago

    Hi Kollox , it would be more useful if support had advised how to make the Data Filter work on reports. 

     

    The Data filter requires a continuous block of data, with all column headings and no blank lines.

     

    Taking a sales register report as an example (below), you need to remove Row 11, which is blank, then insert a row before the totals. Then select any data cell, and enable the Data Filter. 

Mike_James's avatar
Mike_James
Ultimate Cover User
5 years ago

Hi Kollox , it would be more useful if support had advised how to make the Data Filter work on reports. 

 

The Data filter requires a continuous block of data, with all column headings and no blank lines.

 

Taking a sales register report as an example (below), you need to remove Row 11, which is blank, then insert a row before the totals. Then select any data cell, and enable the Data Filter. 

Mike_James's avatar
Mike_James
Ultimate Cover User
5 years ago

PS: Row 11 is very narrow, and hard to manage with just the mouse. To select it, press F5, then type 11:11 and click OK. Then press Ctrl+Minus to delete that row.

Looking for something else?

Search the Community Forum for answers or find your topic and get the conversation started!

Community home

Level up your skills using MYOB software.

 

Find help guides and technical solutions for all MYOB products here

Explore video tutorials for our software at the MYOB Academy here

 

Dig into MYOB Academy for free courses, learning paths and live events to help build your business with MYOB.