excel.advanced.course - return entry field

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel.advanced.course - Return in the entry field

excel.advanced.course - Return in the entry field

resolvedResolved · Low Priority · Version Standard

Adam has attended:
Excel Advanced course
Excel VBA Intro Intermediate course

Return in the entry field

When you hit return in the entry field, it closes the entry.

Apart from putting into notepad and pasting into the excel entry field, is there any way to put a carriage return into that entry field?

Thanks,
Adam

RE: Return in the entry field

Hi Adam

ALT + ENTER will enable to put a carriage return into the cell.

Hope this helps

Sandy

RE: Return in the entry field

That's great - thanks.

RE: Return in the entry field

Hi Adam,

If you are happy with the answer you have received, we can mark this question as resolved.

Richard


 

Excel tip:

Saving your Excel Spreadsheet as a CSV File

In situations where you need to save your Excel spreadsheet as a CSV file, follow these simple steps.

Click the File tab and click Save As.
Enter a name in the File name field.
Click the drop-down arrow next to the Save as type field to select the file type. Scroll down the list and select CSV (comma delimited) (*.CSV)
Click Save

The data will now be saved to a separate CSV file which can be used in different applications.

View all Excel hints and tips


Server loaded in 0.09 secs.