AYUDA AL ENTRAR FORMULA

M

mespinalt

New Member
Joined
Apr 7, 2006
Messages
17
HOLA:
TENGO UN PROBLEMA AL TRATAR DE ENTRAR UNA FORMULA CONFIRMADA CON LAS TECLAS CTRL+SHIFT+ENTER.

COMO DEBO HACER ESTA ENTRADA?

GRACIAS

MESPINALT
 

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.
Sort by date Sort by votes
Si es que Excel le dice «You cannot change part of an array» (Usted no se puede cambiar parte de una fórmula matricial), es que hay que seleccionar todas las celdas de la matrix antes de editar una celda. Esto se puede hacer por medio de Ctrl+/ o con Edit | GoTo... | Special (botón) | Current Array (opción)

Si es otra cosa, entonces favor explicar un poco mejor qué tipo de problema está experimentando.
 
Upvote 0
You must log in or register to reply here.

Similar threads

D
  • Question Question
Practica de excel
Replies
0
Views
174
danielaleon25
D
M
  • Question Question
Save Close Files
Replies
0
Views
277
MILTINO
M
J
  • Solved
Interconexión de Formularios
Replies
7
Views
809
Fluff
Fluff
Z
  • Solved
Sumar.si y buscarv en una función Let
Replies
6
Views
755
zelarra
Z
F
  • Solved
Ayuda con formula
Replies
3
Views
703
DanteAmor
DanteAmor

Forum statistics

Threads
1,226,730
Messages
6,192,708
Members
453,748
Latest member
akhtarf3

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top