Home |
Search |
Today's Posts |
#1
|
|||
|
|||
alt+enter does not work
For some reason the alt+enter function does not work for me when trying to
insert a line break within a cell. Is there any other way of doing it or, better still, any way I can enable it? I'd appreciate any help I can get on this one as it's driving me crazy trying to figure it out! Thanks in advance :-) |
#2
|
|||
|
|||
Hi!
Do you have Wrap Text selected? FormatCellsAlignment Another way to do it is to make the entry a formula: ="How does"&CHAR(10)&"this work?" This also needs to have Wrap Text selected. Biff "shazza" wrote in message ... For some reason the alt+enter function does not work for me when trying to insert a line break within a cell. Is there any other way of doing it or, better still, any way I can enable it? I'd appreciate any help I can get on this one as it's driving me crazy trying to figure it out! Thanks in advance :-) |
#3
|
|||
|
|||
Hi!
Yes, I have Wrap text selected. I tried your suggestion and it works which is great, however I have a LOT of text to enter which doing that way will take a long time. If I can figure out how to get the alt+enter working then that's the ideal. Good to have an alternative though :-) Thanks "Biff" wrote: Hi! Do you have Wrap Text selected? FormatCellsAlignment Another way to do it is to make the entry a formula: ="How does"&CHAR(10)&"this work?" This also needs to have Wrap Text selected. Biff "shazza" wrote in message ... For some reason the alt+enter function does not work for me when trying to insert a line break within a cell. Is there any other way of doing it or, better still, any way I can enable it? I'd appreciate any help I can get on this one as it's driving me crazy trying to figure it out! Thanks in advance :-) |
#4
|
|||
|
|||
.. have a LOT of text to enter
.. how to get the alt+enter working There are 2 Alt keys on the keyboard Try keying Alt + Enter with both, see what happens Or try borrow another keyboard and test it out (Could be just a worn-out keyboard crying out to be retired from service <g) -- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- |
#5
|
|||
|
|||
Thanks Max,
Funnily enough I've just plugged in another keyboard to my laptop and it seems to be working so obviously problem lies there. Good to know at last what the problem is! Thanks to both you and Biff for your help. "Max" wrote: .. have a LOT of text to enter .. how to get the alt+enter working There are 2 Alt keys on the keyboard Try keying Alt + Enter with both, see what happens Or try borrow another keyboard and test it out (Could be just a worn-out keyboard crying out to be retired from service <g) -- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- |
#6
|
|||
|
|||
You're welcome !
Thanks for the feedback .. -- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
set tab or enter keys to automatically move to different cells | Excel Discussion (Misc queries) | |||
Cell Selection after "Enter" | Excel Discussion (Misc queries) | |||
Is there a (non-binary) "if x then enter y" forumula? | Excel Worksheet Functions | |||
Work book formulas | Excel Discussion (Misc queries) | |||
when I protect my sheet enter tab, & arrow keys dont work... | Excel Discussion (Misc queries) |