I came across a trick in Chandoo.org about quickly entering data into multiple cells. For example, if you have a rota and you need to enter a name in multiple locations, this trick is really useful.


View the video below to see how it’s done.

[flowplayer src=’https://s3-eu-west-1.amazonaws.com/the-excel-expert/multiple_simultaneous_data_entry.m4v’]


There is no practice file for this but I do suggest you open a new file in Excel and try it out.