Ms excel- delet unused cells

This query is : Resolved

Pratik K (Querist)
Follow

31 July 2008 I have many files in ms excel containing blank raws and columns.

How can I remove that unwanted blank raws and collumns from the sheet?

CA Nallathambi Srinivasan

CA Nallathambi Srinivasan (Expert)
Follow

31 July 2008 You can do by installing the Excel Utility Software availbale in Share Files in this site and using the functions available under the Power utilities menu.

CA Nallathambi Srinivasan

CA Nallathambi Srinivasan (Expert)
Follow

05 August 2008 Have you download the utility and used?

Pratik K

Pratik K (Querist)
Follow

06 August 2008 yes I have download the utility named power utility and Extools
But I could not remove unwanted raws and collumns from the sheet.
Can u suggest the path

Pratik K

Pratik K (Querist)
Follow

06 August 2008 i read the instruction but could not found.

CA Nallathambi Srinivasan

CA Nallathambi Srinivasan (Expert)
Follow

06 August 2008 Can you able to see the power utilities tab like File, Edit, View, Format menu.?

Pratik K

Pratik K (Querist)
Follow

07 August 2008 yes I can see power utility menu in the menu bar.

CA Nallathambi Srinivasan

CA Nallathambi Srinivasan (Expert)
Follow

07 August 2008 Then select the range from where you have to delete the blank rows or columns, or select entire sheet. then use Delecte Blank Rows under Rows options.

Pratik K

Pratik K (Querist)
Follow

08 August 2008 i can not find the raws options
I was able to delet sheet unused
In a new file I deleted sheet 1 and 3 but sheet 2 can not be deleted

CA Nallathambi Srinivasan

CA Nallathambi Srinivasan (Expert)
Follow

08 August 2008 is it possible to send a private message before coming online to my mail id. snthambi@gmail.com

Then I can help you better.

Pratik K

Pratik K (Querist)
Follow

09 August 2008 ok i will mail u soon