![excel spreadsheet excel spreadsheet](https://i.ytimg.com/vi/B6E9dMaFHzc/maxresdefault.jpg)
When you apply a filter, you control the data that is displayed on the screen by setting criteria.
EXCEL SPREADSHEET PLUS
When you hover over the fill handle box, the mouse pointer will change to a black plus sign.
![excel spreadsheet excel spreadsheet](https://www.excel-easy.com/examples/images/view-multiple-worksheets/view-multiple-worksheets.png)
Fill can be used to copy data either horizontally or vertically in a range. Fill can also be used to automatically populate common lists of data such as days of the week or months.
EXCEL SPREADSHEET UPDATE
This means that if the anchor cell contains a formula with relative cell references, those references will automatically update relative to their position when copied to a new location.
![excel spreadsheet excel spreadsheet](https://i.ytimg.com/vi/Fy1GZ6LcCbI/maxresdefault.jpg)