Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel shld allow for coment boxes w/ formulas 'mini popup sheet'
Sometime you want to tie out a number but you don't want to insert lines and
a worded discription is too long. I want to suggest a feature that would essentially work the same way that inserting a comment would, however, within the comment you have cells that you can pull numbers into from the sheet and add functions to in order to show how the number in the orignial cell was calculated. This would save haveing to insert column that are need in an otherwise standard template or have to write a very long worded explaination. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...et.f unctions |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel shld allow for coment boxes w/ formulas 'mini popup sheet'
Maybe something like this?
=a2*a1+n("days worked in A1 * daily wage in A2") Everything after the "n" will not be shown in the cell but you can see it in the formula bar. Gord Dibben MS Excel MVP On Wed, 19 Sep 2007 08:00:01 -0700, TylerJo wrote: Sometime you want to tie out a number but you don't want to insert lines and a worded discription is too long. I want to suggest a feature that would essentially work the same way that inserting a comment would, however, within the comment you have cells that you can pull numbers into from the sheet and add functions to in order to show how the number in the orignial cell was calculated. This would save haveing to insert column that are need in an otherwise standard template or have to write a very long worded explaination. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...et.f unctions |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel shld allow for coment boxes w/ formulas 'mini popup shee
Thanks for the tip, I didn't know that one and that will come in handy. What
I was trying to describe would be just like a comment box in the way that there would be a small triangle in the corner of the cell and when you put the focus on the triangle a box would pop up. Instead of seeing just text you would see a two column (or more) grid that would esentially work like a new sheet. So if I had a number 59,000 10,000 <----Comment Box-------------------- 2,000 -- 100 - Days -- -------- -- 10 - DpD -- 71,000 -- 10,000- Totl -- --------------------- Then if you clicked into were the 10 was you would could still use a formual, for instance maybe that 10 dose come from Sheet two, but you don't want to show it on Sheet one. There are many ways around this as fair as having the information there, but not have it show (hiding rows or columns) but where my though was that I do not want to change the spread sheet AT but I want to be able to electronicly be able to review a brief break out of a figure. The same way a comment box lets you explain it. Just a thought. Thanks for the reply, I will be using your tip! Cheers "Gord Dibben" wrote: Maybe something like this? =a2*a1+n("days worked in A1 * daily wage in A2") Everything after the "n" will not be shown in the cell but you can see it in the formula bar. Gord Dibben MS Excel MVP On Wed, 19 Sep 2007 08:00:01 -0700, TylerJo wrote: Sometime you want to tie out a number but you don't want to insert lines and a worded discription is too long. I want to suggest a feature that would essentially work the same way that inserting a comment would, however, within the comment you have cells that you can pull numbers into from the sheet and add functions to in order to show how the number in the orignial cell was calculated. This would save haveing to insert column that are need in an otherwise standard template or have to write a very long worded explaination. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...et.f unctions |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Mini Toolbar | Excel Discussion (Misc queries) | |||
Popup boxes for dates? | Excel Worksheet Functions | |||
popup note when a sheet is accessed | Excel Discussion (Misc queries) | |||
Removing the : in the coment field | Excel Discussion (Misc queries) | |||
Non-functional Popup Menu Boxes | Charts and Charting in Excel |