Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

Closed Thread
 
LinkBack Thread Tools Display Modes
  #1  
Old 04-01-2019, 06:35 AM
rafael.soteldo@gmail.com rafael.soteldo@gmail.com is offline Windows 10 Office 2013
Novice
 
Join Date: Apr 2019
Posts: 3
rafael.soteldo@gmail.com is on a distinguished road
Default Microsoft Excel 2013: Cambiar fácilmente una referencia de celda a absoluta

Hola:



Alguien conoce una forma de cambiar una referencia de celda a absoluta con una simple acción?

Por ejemplo, tengo la celda C14, y la quiero cambiar a $C$14 sin tener que colocar los signos de $, sólo con seleccionar el texto y presionar algo, para que C14 cambie a $C$14.

O que al crear una fórmula, por ejemplo "=BUSCARV(" si hago clic en una celda, aparecería esa celda, por ejemplo C14, pero si mantengo presionado algo como CTRL, o algo así, aparecería $C$14 por ejemplo.

Eso me facilitaría la edición de fórmulas.

Gracias de antemano,

Rafael
  #2  
Old 04-01-2019, 08:59 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Windows 7 64bit Office 2010 64bit
Moderator
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,367
Pecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of light
Default

Hello
use the F4 button to toggle between absolute/relative references with the cell number selected
__________________
Problem solved ? Let others know by clicking " Thread Tools" then " Mark thread as solved".( This can be undone if need be)
Want to thank for the help received ? Click the scales symbol in the upper right corner of a post from the person you want to thank.
  #3  
Old 04-01-2019, 09:00 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Windows 7 64bit Office 2010 64bit
Moderator
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,367
Pecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of light
Default

Duplicate Thread closed
__________________
Problem solved ? Let others know by clicking " Thread Tools" then " Mark thread as solved".( This can be undone if need be)
Want to thank for the help received ? Click the scales symbol in the upper right corner of a post from the person you want to thank.
Closed Thread

Tags
excel 2013 formula

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Using Macros in Microsoft Word 2013 Jacqui.Spinks Word VBA 0 03-02-2017 07:43 AM
Exporting specific data fields from MS Word 2013 to a MS Excel 2013 spreadsheet Labyrinth Word 7 07-19-2016 01:35 PM
Format Issue Microsoft Word 2013 user1234 Word 0 05-20-2015 07:00 PM
How to install Microsoft Office 2013 from HomeBusinessRetail.img lysdexic Office 1 02-01-2015 04:31 PM
Outlook Problems With Microsoft Office 2013 expatinsiam Outlook 0 08-23-2014 11:18 PM


All times are GMT -7. The time now is 09:17 AM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft