Cari Blog Ini

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".