One can go to Tools->Options->LibreOffice Calc->View and uncheck “Sheet tabs”, but the space they were in is still there, wasted. To reclaim it one must turn off the horizontal scrollbar. When other user interface elements like toolbars are not shown their space is reclaimed.