Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Closed Thread
 
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
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Hello
use the F4 button to toggle between absolute/relative references with the cell number selected
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
  #3  
Old 04-01-2019, 09:00 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Windows 7 64bit Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Duplicate Thread closed
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
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

Other Forums: Access Forums

All times are GMT -7. The time now is 05:37 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft