excel course london - Filename and date automatic update.

Resolved · Low Priority · Version Standard

Wed 6 Dec 2006, 16:11 Delegate Ben said...

Ben has attended:
Excel Introduction course
Excel Intermediate course

Filename and date automatic update.

Is it possible to create a setting in an excel file (a scoring submission form) that will force the person opening and completing it to fill out one or more given cells, or better still the file name, in order to indicate who had amended the form and when?

(Like many web-based forms)

Ben

Thu 7 Dec 2006, 11:13 Trainer Richard said...

RE: Filename and date automatic update.

You could se the file to Read-only, which would mean the person saving the file would need to specify a different file name. You could specifiy the format:

ie:

ScoreSubmissionForm-YYYY_MM_DD-YourName.xls

To make the file read-only, simply right click on the file in windows explorer, choose properties, and then tick the ReadOnly box.

Excel tip:

Multiple Lines of Text in a Cell

As an alternative to the Text Wrapping facility, type a word or two, press Alt+Enter to get a new line, type more text, and continue the process for as many lines as you need. Enter as normal when you have finished.

The line break is not affected by changing the column width, as text wrapping. To remove this you must edit the cell and remove the invisible character and replace with a normal space.

View all Excel hints and tips

excel course london - Filename and date automatic update.

Filename and date automatic update.

RE: Filename and date automatic update.

Excel articles

Excel tip:

Multiple Lines of Text in a Cell