How-To Geek on MSN

5 everyday actions that Power Query does better than regular Excel tools

Any null values will show as blank cells in the final Excel table. If you'd prefer to fix this within the Power Query Editor, ...
MUO on MSN

This hidden Excel setting instantly made spreadsheets easier to read

Press Alt > W > E > F in sequence (not all at once). This sequence activates the View tab and toggles the Focus Cell. Remembering this shortcut lets you treat the feature as a temporary reading ruler.