file size magically goes down after copy and pasting to new sheet

[daveyc18]

original sheet copied and pasted to a new sheet I just created...i deleted the old, original sheet and magically rhe file size reduce by 2 MB. it's not due to formatting cause the original sheet dint have any formatting (i did a select all, clear formats just in case)....

just trying to know why this might have happened??

 

[JoeMo]

Did you copy a sheet with lots of formulas then pastespecial values on the new sheet, then delete the source sheet you copied? If yes, then likely those formulas were bit hungry compared to the values you pasted.

 

[Legacy 421546]

Excel did a fresh save of the new sheet. There's a lot of redundant info that can be cleaned up. 2 Mbyte less. What was the original size?

 

[daveyc18]

excel did a fresh save of the new sheet. There's a lot of redundant info that can be cleaned up. 2 mbyte less. What was the original size?

3 mb.

 

[daveyc18]

here's the link to the original file:

https://drive.google.com/file/<wbr>d/<wbr>0B6u98BCxSDBJTC1QNEFJZW1iNnR5c<wbr>XQ3MWMzMlRwYW9UbG1R/view?usp=<wbr>drivesdk


now, if you use that data...copy and paste to new sheet (or worbook) then save...the file size goes down

 

[Fluff]

You need to mark the file for sharing & post a new link.

 

[daveyc18]

You need to mark the file for sharing & post a new link.

ok should work:

https://drive.google.com/file/<wbr>d/<wbr>0B6u98BCxSDBJTC1QNEFJZW1iNnR5c<wbr>XQ3MWMzMlRwYW9UbG1R/view?usp=<wbr>drivesdk

 

[Fluff]

Click on A1, then Ctrl end.
Where does that take you

 

[daveyc18]

Click on A1, then Ctrl end.
Where does that take you

lol, yes, but why is it doing that? i dont see data outside of AE1756???

i even selected all the rows and columns after row a1756 and cleared all....it still takes me there

 

[Fluff]

Why is difficult to answer as there are a number of possibilities.
To remove them select the rows & right click> delete > save