If you have worked with spreadsheets before you know there are a few different types of pointers. The type of pointer depends upon where you are relative to a cell, column, or row. Listed below are the different types of pointers and a brief description of what each one does:
- White Plus - the default pointer, allows you to select a cell or group of cells. Note: Left-click and hold to select multiple cells from contiguous rows and columns with this pointer.
- Down or Right pointing black arrow - appear when you hover over row or column headings and allow you to select an entire row or column to apply changes to at one time.
- Left / Right and Up / Down double arrow black pointer - appear when your pointer hovers on the dividing lines between individual rows and columns. Allow you to adjust the row width and column height.
- Black four-arrow pointer - appears when you hover over the edges of a cell but not the corners. Use this pointer to move data in a cell or group of cells to another place in the spreadsheet, another sheet, or another spreadsheet file. Note: You can also select a cell or group of cells, right-click and select cut, then click the cell where you want to move the cells to, right-click and select paste to move the same data. There are multiple ways to manipulate data in a spreadsheet. Use the way that seems most intuitive and effective for you.
- Black plus - appears when you hover at the bottom right corner of any cell or selection of cells.