Forum Discussion
HELP PLEASE! Excel sizing issue!
Hi everyone, First time using this forum so I hope I am doing the right thing! I have created a finance spreadsheet that has a few macros, some fairly (ish) lengthy formulas in it (SUMIFS etc) a...
I have just noticed as well that although I have freeze panes on, my rows go from 7 to 316?
- There are only a few objects in it, literally a couple of buttons that I have added macros to, to just sort A-Z etc. The file was file and under 300kb last night, then I added one column with a few numbers in it and its gone crazily big. I tried going back and getting rid of the column and formulas I put in but even that didn't work. It is some kind of formatting I have done somewhere? The rows seem all funny, go from 7 to 316 and the scroll bar is the full length also, when I click on it it goes smaller but can only scroll so far down the sheet.
- Did you really delete the rows and columns and not just the content?
- Apologies, I have got this sorted now.
I was playing with the sheet trying to sort and all a sudden it just literally fixed! Reduced in size and job done! Thank you.