11 September 2012

How to Remove Any Blank Rows or Columns in Spreadsheet Excel

I. Remove Any Blank Columns

1. Open your original spreadsheet

2. a. Active at last column, example: column "G"




2. b. Press "CTR + SHIFT + Arrow Right" 






2. c. Then right click, choose "Delete".





II. Remove Any Blank Rows

3. a. Active at last rows, example: row "74"




3. b. Press "CTR + SHIFT + Arrow Down"




3. c. Then right click, choose "Delete".