Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom
Forum home » Delegate support and help forum » Microsoft Excel Training and help » introduction excel training - Inputting text in Excel
Resolved · Low Priority · Version Standard
Tom has attended:
Excel Intermediate course
When I am in MS Word, hitting the enter/return key means that the cursor drops down to the next line. How do I do this in Excel? I know there is a way to do this but I have forgotten! At the moment I have to press space bar until I get to the right edge of the box.
Alt + enter
|
Excel tip:Separate the year from a dateTo separate the year from a date use the =year() function, eg a date is in cell A1 and in A2 you wish to display the year enter the function =year(A1) |
We'll call during UK business hours
Server loaded in 0.09 secs.