Monthly Archives: April 2020

Delete rows with empty cell(s) in #Excel

Guess what?  We are going to do it with a sequence of keyboard shortcuts only.  Believe it or not, it requires only 8 key strokes: Ctrl+A => Ctrl+G => Alt+S => k => Enter => Ctrl+- (minus sign) => r … Continue reading

Rate this:

Posted in Excel Tips, Shortcut | Tagged , | Leave a comment

Transform and Combine all worksheets in an #Excel workbook with #PowerQuery

Power Query is magically powerful, yet it is not well known to majority of Excel users.  I think most Excel users are not even aware of its existence…  So, let’s talk about how Power Query could solve a real-life problem … Continue reading

Rate this:

Posted in Power Query | Tagged , , | 2 Comments