excel course london - filename and date automatic

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

TrustPilot

starstarstarstarstar Excellent

  • Home
  • Courses
  • Promotions
  • Schedule
  • Formats
  • Our Clients

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel course london - Filename and date automatic update.

excel course london - Filename and date automatic update.

resolvedResolved · Low Priority · Version Standard

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



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


Server loaded in 0.08 secs.