Excel 2007 : transformez des formules en valeurs

Vous êtes ici : Accueil > Astuces

Publié le : 15/06/2011 vers 14h
Mise à jour le : 03/06/2011 vers 12h
Catégories :
  • Office

Auteur(s) :
Gilles SALOMON (Membre depuis le 08/10/2008)
Société :
Fonction :
Contactez cet auteur - Affichez les ressources de cet auteur

Quand, avec Excel, vous créez une formule de calcul, par exemple =A3+A4, c'est généralement son résultat, par exemple 20, qui apparaît dans la cellule. Comment cacher cette formule et n'en afficher que le résultat ? Voici un moyen rapide et original.
Faites un pseudo-glisser-déplacer : Sélectionnez la plage de cellules concernées, maintenez le bouton droit de la souris enfoncé, faites glisser la bordure de la sélection… et remettez-là à sa place, puis lâchez le bouton de la souris. Dans le menu qui s'affiche, choisissez Copier ici les valeurs seules. Résultat paradoxal : une manipulation censée être neutre (un non-déplacement de cellules) peut quand même servir à quelque chose ! (Source 01 net)

Votre commentaire:

Votre pseudo :

Votre commentaire :

Saisir les caractères ci-contre dans le champ suivant :
 Rafraichir

PseudoCommentaire
gordon
01/02/2017 06:53:24
3oyHlS http://www.y7YwKx7Pm6OnyJvolbcwrWdoEnRF29pb.com
gordon
31/01/2017 18:32:58
3rIGr2 http://www.y7YwKx7Pm6OnyJvolbcwrWdoEnRF29pb.com
matt
30/01/2017 05:56:51
NY3dAQ http://www.y7YwKx7Pm6OnyJvolbcwrWdoEnRF29pb.com
chaba
30/01/2017 04:48:52
hgxZQd http://www.y7YwKx7Pm6OnyJvolbcwrWdoEnRF29pb.com
matt
29/01/2017 16:12:12
VMnbvn http://www.y7YwKx7Pm6OnyJvolbcwrWdoEnRF29pb.com
chaba
29/01/2017 16:09:40
UtJnf2 http://www.y7YwKx7Pm6OnyJvolbcwrWdoEnRF29pb.com
Barnypok
31/12/2016 11:35:15
lxPkMi http://www.FyLitCl7Pf7ojQdDUOLQOuaxTXbj5iNG.com
JimmiXzS
15/10/2016 03:43:28
5bAntw http://www.FyLitCl7Pf7kjQdDUOLQOuaxTXbj5iNG.com
JimmiXzS
14/10/2016 21:36:39
vtJo6d http://www.FyLitCl7Pf7kjQdDUOLQOuaxTXbj5iNG.com
matt
14/08/2016 11:39:11
oyc79s http://www.FyLitCl7Pf7kjQdDUOLQOuaxTXbj5iNG.com
Mark
11/05/2016 22:22:43
9Yvsc9 http://www.y7YwKx7Pm6OnyJvolbcwrWdoEnRF29pb.com
Leroy
08/10/2015 20:39:04
How much were you paid in your last job? city what is voltaren increasingly detectives The potential you've got here is not that you are going tobe selling fewer iPhone 5S...What you are doing here isattacking a brand new market, the trader said. Now they havecome up with a mid-range phone because there is a huge marketfor entry level smartphones.
Randy
08/10/2015 20:39:02
Free medical insurance delighted runner metronidazole or tinidazole) pills bathe Actual sales for August, not seasonally adjusted, were up11.1 percent from a year earlier. The jump is due to a move bythe government to tighten mortgage lending rules last summer,which dramatically reduced sales in the second half of 2012 andwill make year-over-year comparisons look stark this year.
Emmanuel
08/10/2015 20:39:00
I've got a full-time job coolness dandy wellbutrin sr 300 mg context The company's fiscal third-quarter earnings, released after the stock market's regular session ended, sent shares up as much as 5% in after-hours trading. During regular trading, shares fell 1.7% to $418.99; the stock is down 40% from its high in September.
Lenard
08/10/2015 20:38:58
Other amount snapped where to buy cytotec pills in the philippines smell walter Until the FDA deems there's sufficient evidence to implicate a specific food, federal confidentiality laws prevent the agency from releasing suspected brand names unless doing so is necessary for a recall, according to an FDA spokeswoman.
Mohammad
08/10/2015 20:38:56
I'm unemployed thirteenth generic wellbutrin xl qualities At a small protest Monday outside the Montreal, Maine andAtlantic headquarters in Hermon, Maine, environmental activistsspoke in French in a show of solidarity to neighbors in Quebec,then called for a moratorium on the transport of crude throughthe state, citing ailing infrastructure, inadequate safeguardsand environmental risk.
Elton
08/10/2015 20:38:54
I can't stand football whereby 25 mg of zoloft sentiment Lazarcheck refused to let a little overcooked pork extinguish his recipe’s flavor. Though he couldn’t add in the burnt bacon, he made his PenneWith Roasted Asparagus and Chick peas in a white cream sauce, and served it with chicken cutlets, sun-dried tomatoes and artichoke sauce.
Terrence
08/10/2015 20:38:52
I want to make a withdrawal squadron curls prozac nation quotes page numbers cyclist Filner did apologize through a videotaped statement for any misbehavior, but he said denied that he had ever sexually harassed anyone. He called himself a hugger of men and women, but promised to change how he acts.
Zoe
08/10/2015 20:38:50
The United States death detain albuterol hfa inhaler coupons dreary The violence has paralysed the port, shutting banks andbusinesses, setting around 300 houses on fire and groundingflights. The rebels made their surprise attack on Monday, tryingto march through the city to plant a flag of independence.
Santos
08/10/2015 20:38:48
What company are you calling from? youthful remainder comprar misoprostol costa rica breeding When the request for help came through, Kayani knew which one of the team he wanted to take with him to Peshawar on the helicopter that was standing by. Given Malala's age, paediatric intensive care specialist Fiona Reynolds was the obvious choice. Although she had her doubts about security in Peshawar, she had heard enough about Malala from news reports to feel the risk was worth taking. She'd been shot because she wanted an education, and I was in Pakistan because I'm a woman with an education, so I couldn't say 'no,' she says.
Nos partenaires : www.bestof-microsoft.com | www.exchangedump.com | www.exchangedump.com | www.formation-exchange.com | www.formation-management-dif.com | www.formation-mcpd.com | www.formation-pmp.com | www.formation-seven.com | www.formation-windows-7.com | www.formation-windows7.com | www.formation-windows-seven.com | www.certification-mcpd.com | www.certification-windows-7.com | www.consulting-exchange.com | www.e-managementinstitute.org | www.certification-mcitp.com | www.formation-mcsa.com | www.bestof-exchange.com | www.exchange-consulting.com | www.bestof-voip.com | www.formation-cisco.com www.formation-mcitp.com.com | www.laboratoire-exchange.com | www.messagerie-consultant.com | www.bestof-windows.com | www.bestof-sharepoint.com | www.messagerie-consultants.com | www.formation-mcts.com | www.consultant-messagerie.com