Ctrl+Enter (Excel XP)

Topic

New Reply

This trick can be very handy.

It works with formulas as well as with constant values. Relative cell references in the formula in the active cell will adjust themselves automatically in the other cells.

Reply | Quote

Replies

No question this time!

Instead, I just discovered a feature that I thought others may find useful. It’s new for me but the rest of the World may already know of it. Anyway, if you need to enter the same information into several cells, there is a shortcut for doing so…

Just select the cells, (I’d hold down the Ctrl key and use the mouse to make selections), then type what you want in the last cell selected. Hold down Ctrl and press Enter. That’s it, whatever you typed into the last selected cell is now in every cell you selected.

This works with cells selected anywhere on the sheet. The selected cells do not have to be contigious, where the fill-across or fill-down method would work just fine.

Reply | Quote

Ricky
Thanks for sharing – it was a new one for me and will be useful.

Reply | Quote

Ricky
Thanks for sharing – it was a new one for me and will be useful.

Reply | Quote

Thanks – very useful.

Reply | Quote

Thanks – very useful.

Reply | Quote

Perhaps now you discovered already the trick, this other one can be of interest as complement for you

http://www.contextures.com/xlDataEntry02.html%5B/url%5D

Reply | Quote

Perhaps now you discovered already the trick, this other one can be of interest as complement for you

http://www.contextures.com/xlDataEntry02.html%5B/url%5D

Reply | Quote

And also useful are the shortcuts:

CTRL + D (which fills down however many cells are selected)

CTRL + R (which fills to the right however many cells are selected)

Reply | Quote

And also useful are the shortcuts:

CTRL + D (which fills down however many cells are selected)

CTRL + R (which fills to the right however many cells are selected)

Reply | Quote

No question this time!

Instead, I just discovered a feature that I thought others may find useful. It’s new for me but the rest of the World may already know of it. Anyway, if you need to enter the same information into several cells, there is a shortcut for doing so…

Just select the cells, (I’d hold down the Ctrl key and use the mouse to make selections), then type what you want in the last cell selected. Hold down Ctrl and press Enter. That’s it, whatever you typed into the last selected cell is now in every cell you selected.

This works with cells selected anywhere on the sheet. The selected cells do not have to be contigious, where the fill-across or fill-down method would work just fine.

Reply | Quote