Question description:
This user has given permission to use the problem statement for this
blog.
I have seen Excel spreadsheets with a section above the worksheet for adding comments or to track the progress or changes on the worksheets.
The comment section I am talking about is completely independent of the worksheet and changes in the worksheet do not affect the comment section at the top.
I'm not sure if this is from a more expensive version that I do not have or if it is an add on.
Any help appreciated.
Solved by I. A. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
13/03/2018 - 08:39
Hello :)
User
13/03/2018 - 08:42
Are familiar with what I am describing?
Excelchat Expert
13/03/2018 - 08:42
Yes, it sounds like a text box
Excelchat Expert
13/03/2018 - 08:43
Does that sound familiar?
User
13/03/2018 - 08:43
I don't think it is a text box.
Excelchat Expert
13/03/2018 - 08:43
Can you desribe it a little more please.
Excelchat Expert
13/03/2018 - 08:43
What do you mean by a comment section at the top?
User
13/03/2018 - 08:44
Similar to the Excel spreadsheet having two sections.
Excelchat Expert
13/03/2018 - 08:45
When you scroll down does the comment section stay visible?
Excelchat Expert
13/03/2018 - 08:45
For instance, if you scrolled to row 100, can you still see the comments?
User
13/03/2018 - 08:45
Yes it is not in the worksheet
Excelchat Expert
13/03/2018 - 08:45
Does it have separate cells or is it just one big comment box?
User
13/03/2018 - 08:46
between the worksheet area and the formula area. I have seen it say in an accountant's office from a distance.
User
13/03/2018 - 08:46
It appears you are able to add a date then comment then move to the next line to do the same.
User
13/03/2018 - 08:46
Like there are two worksheet areas.
Excelchat Expert
13/03/2018 - 08:47
Okay, can you tell me what your intended use is for this comment section?
User
13/03/2018 - 08:48
Just that to date and document changes to the worksheet and expected deadlines or responses.
User
13/03/2018 - 08:48
And to be able to scroll back to familiarize myself after not touching the worksheet for a space of time
Excelchat Expert
13/03/2018 - 08:49
I see. based on your description, I thought it was a text box. You can achieve the same by using a textbox at the top while locking the scroll view, but it will be within the sheet at the very top rather than on above the formula bar.
User
13/03/2018 - 08:50
Yes, but it will be blocking out the menu or parts of the worksheet. What I am trying to describe was built in and Excel made space between the menu and the worksheet.
Excelchat Expert
13/03/2018 - 08:51
I'm reviewing, but haven't found anything in relation to that.
Excelchat Expert
13/03/2018 - 08:51
I'll continue reviewing though.
User
13/03/2018 - 08:52
I thought it would be something to add or a box to check under the developer tab or view tab or options tab but I have not found anything so I decided it must be an add in.
User
13/03/2018 - 08:54
Makes me feel better it was not an easy answer for you!
Excelchat Expert
13/03/2018 - 08:54
Yes, sorry. I wish it was :(
User
13/03/2018 - 08:55
When the time runs out then our time is over?
Excelchat Expert
13/03/2018 - 08:55
Yes, you can extend the session. However, I don't feel that I will be able to answer this for you.
User
13/03/2018 - 08:56
OK! Thanks for listening!
User
13/03/2018 - 08:56
Have a good day!
Excelchat Expert
13/03/2018 - 08:56
Have you ever used the comments option?
Excelchat Expert
13/03/2018 - 08:56
by right clicking on a cell and inserting a comment that goes with the cell?
User
13/03/2018 - 08:56
Comment that appear in the cells?
User
13/03/2018 - 08:56
yes
Excelchat Expert
13/03/2018 - 08:57
Ah, okay, that is the only alternative suggestion that I have at this time.
User
13/03/2018 - 08:57
Ok thanks!
Excelchat Expert
13/03/2018 - 08:57
You're very welcome!
User
13/03/2018 - 08:57
The next time I see it, I will inquire.
Excelchat Expert
13/03/2018 - 08:58
Okay, please do :)
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.