Wiki Sumber Informasi iSIKHNAS

Ask the participants: Why might this be? Does this matter?

• This happened because data was deleted from the original dataset. Excel, however, still remembers the original extent of the range. If extensive formatting had been applied to this larger range, then more memory is being consumed than is really necessary, and the file size can be unnecessarily large.
• Good practice in Excel can include routinely selecting then deleting all columns to the right of the data block, then doing the same for all rows below the data block. This removes any unnecessary formatting, and can reduce the file size.