Forum Discussion
Keep getting Large Operation Message
I have an Excel sheet for simple bookkeeping. There are about 285 entries. I have sorted it according to project name. I want to add blank rows under each project grouping, put sub-totals for that...
It could be that excel thinks the used range is much larger than it actually is. Do you have unnecessary formatting (some people select entire rows/columns when applying cell formatting)?
See here for more information:
https://support.microsoft.com/en-us/office/locate-and-reset-the-last-cell-on-a-worksheet-c9e468a8-0fc3-4f69-8038-b3c1d86e99e9
See here for more information:
https://support.microsoft.com/en-us/office/locate-and-reset-the-last-cell-on-a-worksheet-c9e468a8-0fc3-4f69-8038-b3c1d86e99e9