Forum Discussion
G_Torres
Feb 17, 2020Copper Contributor
Unable to delete empty rows and columns
I am unable to delete empty cells / rows / columns from my worksheet - I choose Delete and nothing happens. I have tried just cutting and pasting my data to a new document, but all of the empty cells...
RickMcKay
Nov 07, 2023Copper Contributor
G_Torres None of the previous solutions worked for me, but I had two tables side by side.
My solution was to resize each table to the correct height, by changing the range of the tables.
Table Design -> Resize Table.
As soon as the tables were resized, I was able to delete the lines, without saving and re-opening the file.
Hope this helps someone. I am using the latest Office 365 Version 2311 Build 17029.20000