Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hiding formulas
How does one hide formulas in cell that are not yet being used, another words if i copy a formula down several rows, but only enter info each day when i go to print the report for that day it shows all of the info plus the next formulas. -- Donald ------------------------------------------------------------------------ Donald's Profile: http://www.excelforum.com/member.php...o&userid=15171 View this thread: http://www.excelforum.com/showthread...hreadid=493310 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hiding formulas
Check if the cell being referred to has data. For example
=IF(A10="","",A10*5) when A10 is empty, you will see nothing. -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Donald" wrote in message ... How does one hide formulas in cell that are not yet being used, another words if i copy a formula down several rows, but only enter info each day when i go to print the report for that day it shows all of the info plus the next formulas. -- Donald ------------------------------------------------------------------------ Donald's Profile: http://www.excelforum.com/member.php...o&userid=15171 View this thread: http://www.excelforum.com/showthread...hreadid=493310 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hiding formulas
Thanks for the info, but here is a stupid question when I put this formula in the unused data cell, It still shows the formulas, example: a-1 and b-1 are is where the data will be entered so a1+b1 should be empty and the formulas start in c1. a-1 b-1 c-1 d-1 e-1 a1+b1 b1-a1 b1/a1 I want to hide the results of the formulas until data is put into a-1 b-1 -- Donald ------------------------------------------------------------------------ Donald's Profile: http://www.excelforum.com/member.php...o&userid=15171 View this thread: http://www.excelforum.com/showthread...hreadid=493310 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hiding formulas
You could check for a count of numbers in the range first:
=if(count(a1:b1)<2,"",a1+b1) And so forth. Donald wrote: Thanks for the info, but here is a stupid question when I put this formula in the unused data cell, It still shows the formulas, example: a-1 and b-1 are is where the data will be entered so a1+b1 should be empty and the formulas start in c1. a-1 b-1 c-1 d-1 e-1 a1+b1 b1-a1 b1/a1 I want to hide the results of the formulas until data is put into a-1 b-1 -- Donald ------------------------------------------------------------------------ Donald's Profile: http://www.excelforum.com/member.php...o&userid=15171 View this thread: http://www.excelforum.com/showthread...hreadid=493310 -- Dave Peterson |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hiding formulas
Which cell do I add this too? -- Donald ------------------------------------------------------------------------ Donald's Profile: http://www.excelforum.com/member.php...o&userid=15171 View this thread: http://www.excelforum.com/showthread...hreadid=493310 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hiding formulas
All of your formula cells.
Donald wrote: Which cell do I add this too? -- Donald ------------------------------------------------------------------------ Donald's Profile: http://www.excelforum.com/member.php...o&userid=15171 View this thread: http://www.excelforum.com/showthread...hreadid=493310 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Array Formulas take waaaay too long... | Excel Worksheet Functions | |||
Hiding formulas | Excel Worksheet Functions | |||
Hiding Formula's | New Users to Excel | |||
Hiding formulas in Excel 2000 | Excel Discussion (Misc queries) | |||
Excel, problem with hiding formulas.... please help! | Excel Worksheet Functions |