How to add one more row of data ?

[Paulyeo11]

Hi All

I just Open a new file , and after i have enter one row of data and save the file , May i know how to add one more row of data ?

[TomMartens]

Hey @Paulyeo11 ,

enter additional data to "manual" table can be achieved using these steps:

Select "Transform data"

Mark the table where you want to add additional data

[Anonymous · Accepted solution]

Hi @Paulyeo11 

You will have to go to Home Tab-->Click on Transform data-->It will take you to power query editor from there in the right side pane you can see a gear buttor beside source click on that and you will be able to add row.

If this helped you please  accept this as solution