Ms excel- delet unused cells
This query is : Resolved
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?
How can I remove that unwanted blank raws and collumns from the sheet?
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.
05 August 2008
Have you download the utility and used?
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
But I could not remove unwanted raws and collumns from the sheet.
Can u suggest the path
06 August 2008
Can you able to see the power utilities tab like File, Edit, View, Format menu.?
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.
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
I was able to delet sheet unused
In a new file I deleted sheet 1 and 3 but sheet 2 can not be deleted
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.
Then I can help you better.
16 January 2009
You can not delete the unused rows and columns from excel spreadsheet... however for better presentation you can hide the same.
You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now
Click here to login now
Similar Resolved Queries
Unanswered Queries
- Depreciation Chart Companies Act
- GST Audit whether Govt Companies are exempt?
- PTRC Show Cause Notice on Email
- Unable to File TDS Q2 Return – New TRACES Portal Error
- Capital Gail Exemption Certificate
- Issuing of delivery challan by seller of goods
- Not ordinarily resident having partnership income in India and salary in USA is any form to filed be
- Taxation of crypto futures in India Fy 2026- 2027
- EPF ECR NEW RULES Sep 17th 2026
- Transfer of Physical Stock Between Two Proprietorship Concerns
- Accounting treatment of AMC alongwith the purchase of Laptop
- GST Treatment of Purchases with GST Paid where Outward Supplies of Manufactured CattleFeed Exempt
- Expert Help Required for TDS Refund 100000 Through TRACES – AY 2022–23
- IMPORT PURCHASE ENTRY PASSED IN BOOKS OF ACCOUNT
- FAST DS 26 Undisclosed Foreign Asset Disclosure Scheme 2026
- Regime change
- Goods sold but invoice not issued
- Tally: Imported bank entries do not show up in manual reconciliation
- Sales of goods of amount Rs97 lakhs to a party
- Confused About My Career After 12th — Cyber Security, AI or Finance? Need Guidance
Trending Online Classes
-
DT & Audit (Exam Oriented Fastrack Batch) - For May 26 Exams and onwards Full English
CA Bhanwar Borana & CA Shubham Keswani
Subscribe to Pro
Join an elite circle of professionals
CAclubindia
