It may depend on the application you are using, but it should be possible. The first half of this video contains a potential solution that I think should work in most spreadsheet applications:
www.youtube.com/watch?v=XLyu...