Software

Ask something
Discussion Locked

format cells in EXcel.

0 helpful
5 replies

by aomar

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

How do you format a cell in excel so you r able to press enter and stay in the cell,
i used to know but my memory cant help today.

there is a way when you press on a cell the formula bar would drop down with the content of the cell. please help.

5 replies

by zalog

The action performed by pressing ENTER is control in the Excel Options. From the Menu click Tools, Options and go to the Edit tab. Adjust the settings for the "Move selections after Enter". Uncheck the box to keep the cell pointer in the same cell when Enter is pressed.

by evers

If you are referring to having a second line of information in the same cell, type the first line of data and press Alt+Enter. This will start your second line of text.

This discussion is closed to new replies.