Forum Discussion
Power Query
Can someone please tell me how I can preserve cell formatting even after I refresh my query! This would be extremely helpful for my work project right now! Thank you in advance. ( I have attached...
Could you please clarify bit more. If we speak about cells formatting these are things like color change, number format, column width and like.
If repeating rows which you'd like to remove (aka headers) you may filter them within the query - add one more step and filter Hours (attached).
I am unsure how to 'you may filter them within the query - add one more step and filter Hours (attached).'
I have deleted the 'Header Rows' within the Power Query Editor - but once I refresh the Master Key spreadsheet after the hours cells have been updated the 'Header Rows' re-appear again and the formatting of the spreadsheet returns back to the default.