Forum Discussion

mocholameow's avatar
mocholameow
Copper Contributor
Jun 13, 2019

How to keep source file format when using query?

When using query, the data combined with a table style format.

I want to keep source excel file format e.g. cell color, cell and text format.

 

I am using query with the following steps. (excel 2016)

New query > from file > from folder > combine and edit.

1 Reply

  • Power Query cannot capture cell styles sorry, the output table could be formatted though

Resources