How to Remove Extra Unused Cells in Microsoft Excel 2013. Worksheets in Microsoft Excel can contain over a million rows and over 15,000 columns.

Tips If you don't need the number column anymore, you can right-click its column letter and click "Delete" to remove it. You can also select "Hide" to keep the column, but hide it from view.

You can remove leading, trailing, and extra spaces between characters and numbers in Excel using TRIM(), SUBSTITUTE() or Find and Replace.

You can split cells into columns in Excel using the "Text to Columns" tool, which is a great way to organize lots of data.