Autosum box too big
We are trying to autosum on line 40, but the box that opens (with the
formula inside) is 3 rows high and very long, so it blocks out rows 39,40,41 as well as several columns wide. It's a pain in the neck because it often blocks rows we want to select for the autosum. Any reason it's so big and is there a way to change it? Thanks ~~Eric |
Eric
Are you using the Autosum button from the toolbar? Just select from start cell to end cell and hit the button. Are you using the Function Wizard? It can be moved around out of the way. Sounds like maybe you are summing many cells like =SUM(a1,a2,a3,a4,a5 etc. and the formula bar is dropping down. Post your method and formula. Gord Dibben Excel MVP On 8 Feb 2005 11:27:07 -0800, wrote: We are trying to autosum on line 40, but the box that opens (with the formula inside) is 3 rows high and very long, so it blocks out rows 39,40,41 as well as several columns wide. It's a pain in the neck because it often blocks rows we want to select for the autosum. Any reason it's so big and is there a way to change it? Thanks ~~Eric |
All times are GMT +1. The time now is 11:28 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com