SIMS exported Marksheets (Formatted) in Excel

[tben2505]

Why is there so much inflexibility with marksheets exported from SIMS?

 

In particular, in completing the comments, staff are struggling as the default cell size is too small, and they cant increase the height of the rows in Excel.

 

Does anyone know a workaround (apart from exporting unformatted obviously)

 

Cheers,

 

Tom

[tben2505]

I've discovered I can unprotect the sheets, adjust the cell sizes and reprotect them.

 

Although I have to do this for every marksheet, creating a macro to do it saves time so it can be done in minutes.

[vikpaw]

Do it in unformatted then get them to copy paste it into formatted for import. Some even just type in excel then copy in when done.