FREE Webinar Recording – Chapter 5 of My Book

The latest and fourth webinar for my book has just been uploaded.

Advanced Excel Reporting Cover

It covers Chapter 5 and the topics include data cleansing and the Format as Table feature and getting external data.

Webinar Recordings

 

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.

dv_shortcut

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

In the Formula box enter the following formula

=NOT(ISTEXT(A2))

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

Click OK.

Not_Text

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.

Shift

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