[Affiliate]
Blog Stats
- 3,316,175 hits
-
Join 3,247 other subscribers
- Follow wmfexcel on WordPress.com
Search wmfexcel
Want Google to translate this page?
-
Recent Posts
Top Posts & Pages
- Date Formats - A trick to format date with "st", "nd", "rd", "th"
- F3 - It is about Naming...
- Filter a list of items from a long long list
- Identify missing files in a folder with Power Query
- Calculate number of a specific day between two dates
- Quickly delete/hide records (rows) with Strikethrough format by using Find and a couple of simple techniques.
- Sequential number for visible rows only
- Interactive Chart is not difficult to make - Part 1/3
- Paste Special – Linked Picture (aka “Camera” in earlier versions of Excel)
- Add conditional columns with #Excel Power Query
My YouTube Channel
My Facebook page
- My Tweets
Tag Archives: Remove Top Rows
Combine all visible worksheets from multiple #Excel files in a folder
It is a common task for us to combine all worksheets in a workbook. It could be a time consuming task without Power Query. With Power Query, it’s piece of cake. 😁 Wait? What about if you want to combine … Continue reading
Posted in Power Query
Tagged Combine Workbook, Invoke Custom Function, Remove Top Rows, Unpivot column
Leave a comment
wmfexcel 