Excel

This Week’s Tip : MS Excel – Applying Custom Validation

Posted in Weekly Tips

MS Excel – Applying Custom Validation

Excel

DID YOU KNOW … that Data Validation prevents invalid data from being entered?

One example may be to prevent duplicate data being entered; another may be stopping spaces being entered at the beginning or end of a cell. You can even add a message to help those using the spreadsheet understand the rules for inputting the data.

Click a link below to find out more.

MS EXCEL 2016

MS EXCEL 2013

Scroll down and follow the Mouse to sign up to our Weekly Tip Newsletters.

Our Weekly Tips are sent out every Tuesday.  Learn something new every week – in Bite Size chunks of learning.

bitsy

Sign up for our free weekly tip

Receive a free nugget of IT Learning every week! It will give you a good feel for how we write and design our lessons and you could learn something new every week too!