Mar 07 2024 01:34 PM
Hi. I discovered a short cut to remove blank rows in a sheet by using CTRL G (goto), special, blanks and then CTRL minus. Unfortunately although it selects the blanks, the CTRL minus deletes more than the blank rows, and most of the sheet information. Any suggestions would be appreciated.
Mar 07 2024 02:40 PM
Mar 13 2024 03:48 AM
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.
Mar 13 2024 05:25 AM
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