ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   help with filling in an array formula (https://www.excelbanter.com/excel-discussion-misc-queries/117626-help-filling-array-formula.html)

Caitlin

help with filling in an array formula
 
I can't figure out how to fill in an array formula. Help says to highlight
the cells and press control+shift+enter. I know that that's the way I've
done it before but I can't get it to work right now for the life of me.
Could I have something set on my computer and/or keyboard that is keeing it
from working??

Otto Moehrbach

help with filling in an array formula
 
Are you holding down both the Ctrl and Shift keys and then pressing Enter?
HTH Otto
"Caitlin" wrote in message
...
I can't figure out how to fill in an array formula. Help says to highlight
the cells and press control+shift+enter. I know that that's the way I've
done it before but I can't get it to work right now for the life of me.
Could I have something set on my computer and/or keyboard that is keeing
it
from working??




Don Guillett

help with filling in an array formula
 

try f2cse
--
Don Guillett
SalesAid Software

"Caitlin" wrote in message
...
I can't figure out how to fill in an array formula. Help says to highlight
the cells and press control+shift+enter. I know that that's the way I've
done it before but I can't get it to work right now for the life of me.
Could I have something set on my computer and/or keyboard that is keeing
it
from working??




Caitlin

help with filling in an array formula
 
Yes, I am holding down shift and control at the same time and then pressing
enter.

And do you mean pressing f2 and then literally pressing and the characters
c, s and e?

Thanks for the help...



"Don Guillett" wrote:


try f2cse
--
Don Guillett
SalesAid Software

"Caitlin" wrote in message
...
I can't figure out how to fill in an array formula. Help says to highlight
the cells and press control+shift+enter. I know that that's the way I've
done it before but I can't get it to work right now for the life of me.
Could I have something set on my computer and/or keyboard that is keeing
it
from working??





Caitlin

help with filling in an array formula
 
wow, I just realized what you meant. And it totally worked. I'll blame it
on my not being too great in the morning. Thanks soooo much!!!

"Don Guillett" wrote:


try f2cse
--
Don Guillett
SalesAid Software

"Caitlin" wrote in message
...
I can't figure out how to fill in an array formula. Help says to highlight
the cells and press control+shift+enter. I know that that's the way I've
done it before but I can't get it to work right now for the life of me.
Could I have something set on my computer and/or keyboard that is keeing
it
from working??





Don Guillett

help with filling in an array formula
 
glad to help

--
Don Guillett
SalesAid Software

"Caitlin" wrote in message
...
wow, I just realized what you meant. And it totally worked. I'll blame
it
on my not being too great in the morning. Thanks soooo much!!!

"Don Guillett" wrote:


try f2cse
--
Don Guillett
SalesAid Software

"Caitlin" wrote in message
...
I can't figure out how to fill in an array formula. Help says to
highlight
the cells and press control+shift+enter. I know that that's the way
I've
done it before but I can't get it to work right now for the life of me.
Could I have something set on my computer and/or keyboard that is
keeing
it
from working??








All times are GMT +1. The time now is 04:41 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com