Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel 2007 Rows and Columns
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel 2007 Rows and Columns
Resolved · High Priority · Version 2007
Reply Thu 23 Sep 2010, 07:08Delegate Oksan said...
Oksan has attended:
Excel Advanced course
Excel 2007 Rows and Columns
Is it possible to delete most of the rows & columns of a worksheet to have only a small fraction of the worksheet left for use? I have a spreadsheet consisting of many worksheets and the size of my spreadsheet has reached 3MB and I need to reduce the size of this file. Would it be possible to delete rows & columns to achieve this? If so, how can I delete these extra rows & columns?
Thanks, Oksan
For upcoming training course dates see: Pricing & availability
RE: Excel 2007 Rows and Columns
Hi Oksan, thanks for your query. There can be many reasons for large Excel file sizes and just deleting unused rows and columns won't do the trick. However, if those unusued rows and columns have actually been data formatted they will contribute to the file size. Work arounds for this problem are too numerous to list here but have a look at this link:
http://www.ozgrid.com/Excel/ExcelProblems.htm
Hope this helps,
Anthony
Thu 30 Sep 2010: Automatically marked as resolved.
|