Forum Discussion
Delete blank rows
Not particularly helpful, no.
I often work with extracted data and/or sort sheets and there are times where I would like to make use of the function..
On the YouTube video it worked particularly well. Just frustrated that I can't replicate it.
Ctrl- actually performs one of these actions
Depends on how ranges are selected above could not be shown and the default action is performed. If entire row is selected, when row is deleted. If parts of rows are selected, when depends on which data is around and what is selected it could remove selected cells and shift the rest left or up.
If Excel has no idea what to do it shows above window with options.
You may try to do the same from the ribbon Insert or delete rows and columns - Microsoft Support