Assume I filled some cells of a worksheet (in Excel 2007).
Now I place the cursor in one of the cells and dragged the cursor to the right side.
As a result more and more empty columns are automatically added at the right side even I do not enter something.
Similarly rows are added at the bottom when cursor is dragged downwards.
Correspondingly the horizontal (and vertical) slider shrinks because the dimensions of the matrix grows.
Is there a menu/function which let me do the opposite?
Something like a trim/shrink function which cuts/deletes all empty columns beginning from the right side resp. rows from the bottom?
.... but not from the left and topmost side.
Peter
Bookmarks