How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask Steve Herrod Your Own Question

Steve Herrod
Steve Herrod, Computer Support Specialist
Category: Microsoft Office
Satisfied Customers: 3284
Experience:  Trained in Microsoft Office from 2000 through to latest version 2010.
65126503
Type Your Microsoft Office Question Here...
Steve Herrod is online now
A new question is answered every 9 seconds

In Microsoft Excel 2010 I have a sprwadsheet that things it

This answer was rated:

In Microsoft Excel 2010 I have a sprwadsheet that things it is 224000 rows and WVW coumns, but the data is only 100 x 100. How do I reduce the size of the sheet that Excel considers each time it changes or calculates anything?

Steve Herrod :

Hi, I'll be happy to help with this issue - if you remove those rows/columns from the view does it improve calculation time etc?


 

Steve Herrod :

this command will hide all rows below 100

Steve Herrod :

1) Select row 101(Click on 101 to select the whole row)
2) Ctrl-Shift-down Arrow to select all rows below row 100
3) Right click on the selection
4) Choose Delete first to be sure that all the cells are empty
5) Right click on the selection again and choose Hide

Steve Herrod :

and you could do the same for columns too

Steve Herrod :

Let me know if that makes a difference at all

Steve Herrod :

Cheers

Steve Herrod :

Steve

Steve Herrod and 2 other Microsoft Office Specialists are ready to help you