98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel 2007 Rows and Columns
Excel 2007 Rows and Columns
Resolved · High Priority · Version 2007
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
Fri 24 Sep 2010, 10:04Trainer Anthony said...
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.
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 tip:Page Break Preview in Excel 2010 (Hint/tip)If you select View then Workbook Views then Page Break Preview, you will be able to view how your Excel spreadsheet will be split across multiple pages when printed. Even better, you can also drag a page break to a new place. Excel will then scale down your entire worksheet to fit the information you want on the pages you want. |
