Hello everyone, I'm trying to export some data from PDF format into Excel using my Microsoft Excel latest version. The problem is I do not know how to select all page that shown here. I have almost 400+ pages, and it's hard to tick one by one. I hope there's an easy way to do it.
@FatinAmani Just select the first one and press Transform Data. Then, in the Applied steps, delete the Navigation step. This leaves you with the Source. Now you can simply filter all the Pages or all the Tables and expand