Quick Links ▼

Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

excel.advanced.course - Return in the entry field

Resolved · Low Priority · Version Standard

Reply Fri 12 Oct 2007, 10:26Delegate Adam said...

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

For upcoming training course dates see: Pricing & availability

Reply Tue 16 Oct 2007, 13:27Trainer Sandy said...

RE: Return in the entry field

Hi Adam

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

Hope this helps

Sandy

Reply Tue 16 Oct 2007, 16:45Delegate Adam said...

RE: Return in the entry field

That's great - thanks.

Reply Tue 23 Oct 2007, 10:12Trainer Richard said...

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 articles

· Features of Microsoft Excel that assist in Analysis of Financial Data
· Excel 2010 A Glance Into The Future
· Do You Need To Upgrade From Excel 2003 to Excel 2007?
· Some Examples Of Excel Text Formulas
· How To Link Between Spreadsheets In Excel

Excel tip:

Hide columns in an Excel 2010 Worksheet

If you don’t want part of the Excel worksheet to be visible or when you don’t want certain data to appear in print outs, then a simple solution is to temporarily hide a column or multiple columns.

Hiding a single column:

1)Right click on the column header of the column you want to hide (this is the grey bar along the top edge of the worksheet)
2)Choose Hide from the menu
3)This column will now be hidden from view

Hide more than one column:

1)In the column header drag select to highlight the columns you want hidden
2)Right click and choose Hide from the menu

View all Excel hints and tips