Users’ of Google’s Spreadsheet application can now designate blocks of cells that only they can modify when they allow their worksheets to be edited by others. By locking certain cell ranges, users ...

Q. I’ve been trying to give descriptive names to spreadsheet cells—rather than use cell-location codes (A1, B2 and so forth)—and while sometimes it works, other ...

Q. I share several of my spreadsheets with colleagues. Each periodically enters data into various worksheets. Every now and then one of them accidentally enters data in the wrong cell, or, worse, in a ...

It may be a surprise to learn that you can define names of cells in Microsoft Excel instead of using the letter and number combinations. This makes it friendlier to read and understand. For example, ...