Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Hi
In the invoice template there are a couple of cells that when you click on them a yellow box that looks similar to a comment box appears with instructions for that cell. How do I create and delete these and what exactly are they? Thanks Jon |
#2
![]() |
|||
|
|||
![]()
Jon,
To add these comments do the following:- Pick the cells/row and/or columns that you want to have these comments appearing on, then select DATA €“VALIDATION€”Input Message Tab. In this key in the comments that you want to appear and presto they will appear. Please ensure that the TICK box is ticked. To delete ones that you dont want, select DATA€”Validation€”Input Message and basically delete them. HTH Pank "Jon" wrote: Hi In the invoice template there are a couple of cells that when you click on them a yellow box that looks similar to a comment box appears with instructions for that cell. How do I create and delete these and what exactly are they? Thanks Jon |
#3
![]() |
|||
|
|||
![]()
Thanks. Microsoft definately needs to document that feature better.
"Pank" wrote: Jon, To add these comments do the following:- Pick the cells/row and/or columns that you want to have these comments appearing on, then select DATA €“VALIDATION€”Input Message Tab. In this key in the comments that you want to appear and presto they will appear. Please ensure that the TICK box is ticked. To delete ones that you dont want, select DATA€”Validation€”Input Message and basically delete them. HTH Pank "Jon" wrote: Hi In the invoice template there are a couple of cells that when you click on them a yellow box that looks similar to a comment box appears with instructions for that cell. How do I create and delete these and what exactly are they? Thanks Jon |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
In Excel, how do you create a multi page Invoice Template? | Excel Discussion (Misc queries) | |||
Template in Excel | New Users to Excel | |||
How do I change the invoice number assigned in Invoice template... | Excel Discussion (Misc queries) | |||
Add lines to invoice template | Excel Worksheet Functions | |||
Excel 98 Invoice Template | Excel Worksheet Functions |