Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 19
Default Show and copy values in formula bar containing a formula

If I have a formula in a cell or cells, is there a way I can view and/or copy
the values/results from that formula in the formula bar?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,047
Default Show and copy values in formula bar containing a formula

Hy,

If I have uderstood what are you looking for, try to copy, paste special |
Values

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Timbo" escreveu:

If I have a formula in a cell or cells, is there a way I can view and/or copy
the values/results from that formula in the formula bar?

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 19
Default Show and copy values in formula bar containing a formula

Marcelo,

Actually, I'm wanting to copy part of the value (not the formula) from the
formula bar and then paste into another cell. Since the formula is in the
formula bar, I haven't seen where I can view the value in the formula bar.

Thanks.

"Marcelo" wrote:

Hy,

If I have uderstood what are you looking for, try to copy, paste special |
Values

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Timbo" escreveu:

If I have a formula in a cell or cells, is there a way I can view and/or copy
the values/results from that formula in the formula bar?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Need help to write formula in Excel to auto show only cells with values Genesis[_2_] Excel Discussion (Misc queries) 6 August 17th 07 04:06 PM
Can I link a spreadsheet but only show values rather than formula tartanspice Excel Worksheet Functions 0 November 21st 06 11:32 AM
Show values in formula instead of cell reference pnorgate Excel Worksheet Functions 6 August 20th 06 09:31 AM
Copy/Paste how to avoid the copy of formula cells w/o calc values Dennis Excel Discussion (Misc queries) 10 March 2nd 06 10:47 PM
How to Copy Values Only, Not Formula? mapen New Users to Excel 3 February 26th 06 10:57 AM


All times are GMT +1. The time now is 12:41 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"