Pegar fórmula sin que se cambien las referncias

M

Miguelsp

New Member
Joined
Apr 23, 2003
Messages
48
Hola de nuevo

Tengo en una celda una fórmula del tipo

=a2+b2

si copio y pego 3 filas más abajo me pondrá

=a5+b5

pero yo quisiera que me lo copiase igual sin necesidad de tener que poner los $. ¿es posible?

Gracias
 

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college
Sort by date Sort by votes
GRACIAS PABLO

Miraré en ASAP ya que manualmente sólo me permite una fórmula cada vez y tengo casi media hoja con fórmulas....

un saludo

M.
 
Upvote 0
You must log in or register to reply here.

Similar threads

M
  • Question Question
¿Cómo ejecutar una macro automáticamente, cada vez que el resultado de una fórmula en una celda arroje un valor específico?
Replies
4
Views
2K
Peter_SSs
Peter_SSs
J
  • Solved
Macro que controla cambios en varias celdas de un rango / Macro that handles changes in multiple cells in a range
Replies
3
Views
4K
Fluff
Fluff
P
  • Question Question
Combinar datos de una lista de registro de personas
Replies
0
Views
704
Pelopincho
P
V
  • Question Question
Formulario único para dar de alta filas en tres tablas diferentes
Replies
0
Views
1K
Valentin Baeza
V
C
  • Question Question
Fechas y numeros que se escriban
Replies
5
Views
961
mrshl9898
M

Forum statistics

Threads
1,223,937
Messages
6,175,510
Members
452,650
Latest member
Tinfish

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