FAQ's
Excel: Create a new line within the same cell
- In FAQ's
To enter paragraphs of text within the same cell in Excel use the key combination of ALT+Enter at the end of each line.
How to access local drive from Remote Desktop
- In FAQ's
Whilst working remotely, if you need to access files from (or copy files to) your C: drive or USB stick, you need to edit your Remote Desktop settings before signing in.
To do this:
How to re-assign a USB drive letter
- In FAQ's
If you have a conflict with mapped drive letters when you try to use a USB memory stick this may help.
For example, if you already have a drive mapped to the letter E: when you insert a USB memory stick, although the device is recognised you may not be able to access if from the "My Computer" window.
To assign a different letter to the USB memory stick:
Avoiding data truncation when merging from Excel into Word
- In FAQ's
A problem can occur when merging cells from Excel to Word that contain more than 255 characters. This can cause problems particularly if the Excel data is being used as a database of information to be linked into a Word document using mail-merge.
The process steps are:
Read more: Avoiding data truncation when merging from Excel into Word
Correcting Date Format when merging from Excel into Word
- In FAQ's
When you merge date fields from Excel into Word documents the date formats may be lost which can be a significant problem causing confusion and potentially serious misunderstandings for scheduling.
To correct this:
Read more: Correcting Date Format when merging from Excel into Word
FAQ's