please tell me the use of ctrl+enter in some formula....
many times users tell that use crl+enter....why so....?
please tell me the use of ctrl+enter in some formula....
many times users tell that use crl+enter....why so....?
Regards,
abdul
Control+Shift+Enter= Array formula.
http://www.cpearson.com/excel/ArrayFormulas.aspx
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
@fotis:- thanks
When you are in editing mode pressing Ctrl+Enter will apply the same text or formula to the select range
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
test test test
Last edited by martindwilson; 02-26-2013 at 07:24 AM.
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks