Stop Text Being Input

If you want to stop text being entered in a range you can use a Custom Data Validation formula.

Select the range and press in sequence, not held down, Alt a v v. This opens the Data Validation dialog.


From the Allow drop down select Custom (last entry).

In the Formula box enter the following formula


Replace A2 with the top left cell in your range. Make sure there are no $ signs in the reference.

Click OK.


Close Excel Quickly

In the more recent versions of Excel, when you click the X in the top right corner, you only close the current file.

In the older versions this would have closed Excel down, and you could then save each file in sequence.

To get the same effect in the new Excel, hold the Shift key down whilst you click the X with the mouse.


If you want to save all the open files click here to see a blog post with a macro to do just that.