Forum Discussion
CTRL + Enter in Excel for data entry
Quick tip to use CTRL + Enter which will help to get similar value on rest of the other space meaning I have 2024 want to paste that A1 to A10 instead of copy and paste simply select range from A1 to...
If you type 2024 in A1 and then select A1 to A10 and press Ctrl + Enter, all the selected cells (A1, A2, A3, ..., A10) will now all contain the value 2024.