User FAQs

If you have a question, please send it to us.

1) How can you enter a line break into a cell to spread text over multiple lines ?
(Alt + Enter)

2) What does a Red Triangle in the top right corner of a cell indicate ?
This indicates that a comment has been added to the cell.

3) What does a Green Triangle in the top left corner of a cell indicate ?
This indicates that the Error Checking Smart Tag has identified a potential issue.

4) What is the little square icon that sometime appears in the bottom right corner of a cell ?
This is the Smart Tag.

5) Is it possible to prevent a user from copying cell values from a worksheet ?
Yes. One way to prevent the cells from being selected is by unlocking all the other cells and then protecting the worksheet by unticking 'select locked cells'.

6) How would you add a drop-down list to a cell to provide a list of possible values ?
Data Validation

7) When is the Fill Handle displayed ?
It is always displayed in the bottom right corner of the active cell (or selection).

8) How do you find the Last Populated Cell on a worksheet ?
Using the shortcut key (Ctrl + End).

9) What is the difference between the active cell and the current cell ?
The active cell is the cell the user has selected (the one with the selection border).
The current cell is the cell that code is operating on internally, even if it is not the active cell.
They are often the same, but they can be different, especially when using automation.