| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
User Comments Relocated - how to move back?
I have a user who was working in a very large excel spread sheet
(thousands of rows). He's not a computer savy user so I don't know what he did but he claims to have it some key that relocated all the comments in the spreadsheet. Now all the comments are grouped together in the same general location about halfway down the spreadsheet with lines going to each cell they belong to. Now, we have comments in the file that one must scroll several hundred rows down to see. Anybody have an idea of what happened? I've done some searching and found some vbscript that can relocate or recreate the comments but did my user use some function I don't know about and can this function be undone? I'm not an Excel expert, I'm a network admin who can answer questions that most users have about Excel but on strange items like this I'm a bit lost. I'd appreciate any help. Thanks! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
User Comments Relocated - how to move back?
Hello,
Type it as normal. In the formula bar, highlight the portion that requires changing to sub/super script. Click on Format, Cells and choose subscript or supercscript. -- Hope that helps, MarkN " wrote: I have a user who was working in a very large excel spread sheet (thousands of rows). He's not a computer savy user so I don't know what he did but he claims to have it some key that relocated all the comments in the spreadsheet. Now all the comments are grouped together in the same general location about halfway down the spreadsheet with lines going to each cell they belong to. Now, we have comments in the file that one must scroll several hundred rows down to see. Anybody have an idea of what happened? I've done some searching and found some vbscript that can relocate or recreate the comments but did my user use some function I don't know about and can this function be undone? I'm not an Excel expert, I'm a network admin who can answer questions that most users have about Excel but on strange items like this I'm a bit lost. I'd appreciate any help. Thanks! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
User Comments Relocated - how to move back?
I think you're responding to the wrong post as I don't have any need
for sub/super scripting, I need to get my user comments back to their original locations. MarkN wrote: Hello, Type it as normal. In the formula bar, highlight the portion that requires changing to sub/super script. Click on Format, Cells and choose subscript or supercscript. -- Hope that helps, MarkN " wrote: I have a user who was working in a very large excel spread sheet (thousands of rows). He's not a computer savy user so I don't know what he did but he claims to have it some key that relocated all the comments in the spreadsheet. Now all the comments are grouped together in the same general location about halfway down the spreadsheet with lines going to each cell they belong to. Now, we have comments in the file that one must scroll several hundred rows down to see. Anybody have an idea of what happened? I've done some searching and found some vbscript that can relocate or recreate the comments but did my user use some function I don't know about and can this function be undone? I'm not an Excel expert, I'm a network admin who can answer questions that most users have about Excel but on strange items like this I'm a bit lost. I'd appreciate any help. Thanks! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
User Comments Relocated - how to move back?
Try Debra's "Reset Comments to Original Position" at:
http://www.contextures.com/xlcomments03.html#Reset -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- wrote in message ups.com... I think you're responding to the wrong post as I don't have any need for sub/super scripting, I need to get my user comments back to their original locations. MarkN wrote: Hello, Type it as normal. In the formula bar, highlight the portion that requires changing to sub/super script. Click on Format, Cells and choose subscript or supercscript. -- Hope that helps, MarkN " wrote: I have a user who was working in a very large excel spread sheet (thousands of rows). He's not a computer savy user so I don't know what he did but he claims to have it some key that relocated all the comments in the spreadsheet. Now all the comments are grouped together in the same general location about halfway down the spreadsheet with lines going to each cell they belong to. Now, we have comments in the file that one must scroll several hundred rows down to see. Anybody have an idea of what happened? I've done some searching and found some vbscript that can relocate or recreate the comments but did my user use some function I don't know about and can this function be undone? I'm not an Excel expert, I'm a network admin who can answer questions that most users have about Excel but on strange items like this I'm a bit lost. I'd appreciate any help. Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| User forms "back" buttons | Excel Discussion (Misc queries) | |||
| Finding a record based on user input | Excel Discussion (Misc queries) | |||
| how do I make a word typed in a cell go to a specific cell in anot | Excel Discussion (Misc queries) | |||
| How do I protect my comments from being edited by another user? | Excel Discussion (Misc queries) | |||
| Graphics file/ How do I move it to the back of a worksheet? | Excel Worksheet Functions | |||
Linear Mode
