If I highlight all 5 rows to sort, I need the blank rows to move to the top to become rows 1 and 2.
I can't seem to find it in options or in the Help section. Been doing for years with an ancient version of Lotus 1-2-3 but an converting my sheets to Excel.
As far as blank rows in Excel are concerned the focus seems to be on deleting them.
All help welcome.
This thread is locked. You can follow the question or vote as helpful, but you cannot reply to this thread.