• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Hour 15. Power Query Techniques > Refining Queries with Field, Field List, and ...

Refining Queries with Field, Field List, and Query Properties

You can use field and query properties to refine and control the behavior and appearance of the columns in a query and of the query itself. Here's how:

1.
Click a field to select the field, click a field list to select the field list, or click the Query Design window anywhere outside a field or the field list to select the query.

2.
Select Properties on the toolbar.

3.
Modify the desired property.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint