Wednesday, December 21, 2016

Remove unused Extra rows and cells in Excel

Please refer below site for handling unused extra cells and rows in excel.
Source- http://smallbusiness.chron.com/remove-extra-unused-cells-microsoft-excel-2013-75272.html

I copied the actual information from the above website for quick reference.

Worksheets in Microsoft Excel can contain over a million rows and over 15,000 columns. With a workspace that large, if you're not careful, you can both easily and unintentionally enter data into the wrong cell -- which, depending on what you're working on, can interfere with important calculations. Fortunately, just as you can remove empty cells in a printout, you can also hide them on your PC.
Press "Ctrl-End" to move to the end of your worksheet and then select the cell located directly below the current cell.
Press "Ctrl-Shift-Down" to move to the bottom row and then select "Format" from the Cells group on the Home tab.
Point to "Hide & Unhide" and then choose "Hide Rows" from the menu to remove all of the selected rows from your worksheet.
Return to the last cell in your worksheet and then select the cell located directly to the right.
Press "Ctrl-Shift-Right" to highlight the remaining columns and then click "Format."
Point to "Hide & Unhide" and then choose "Hide Columns" from the menu to remove the selected columns.

No comments: