reight click a cell without exiting from input mode
You can actually do that. Before you right click, select the text yu
entered, (highlight it), right click, and click on Format Cells. After
formatting you can continue entering data into the same cell, or click on the
next cell, or press Enter to move to the next cell. Trick is to first select
the text you have already input. If you do not, the formatting will only
affect text input after the position where you right click.
eg If you type "asdf" then right click and select Bold as the format, OK out
and type in "qwer"and press Enter, you will get "asdfqwer" but "qwer" will
be bolded.
"Khoshravan" wrote:
after input data to a cell, I am looking for a shortcut key or a command to
select the cell and right click (do formatting or something elde), without
using enter. By eneter the active cell moves and I have to return beck to
desired cell. I now it is possible to change the "enter key" action through
optio but I want to keep that funtion of "enter key"
--
Rasoul Khoshravan Azar
Civil Engineer
Osaka, Japan
|