P
Parantap
Suggestions are both for Word and Excel where applicable. These suggestions
are mostly based on office 2000.
1. Word count should be in Excel too and should give such information like
- How many characters are there in a cell,
E.g. How many “aâ€, “Aâ€, “bâ€, “B†Etc. are there in a cell
- How many symbols are there in a cell,
E.G. How many “!†“+†“=†Etc. are there in a cell.
- How many Upper case characters
- Lower
- Vowels
- Vyanjan
- Spaces
- Size in KB
- Is any formula used in the cell? If yes then how many sub formulas are
there in a main formula?
In Microsoft word above mentioned points should be given as a result word
count.
2. There should more divider sticks while we split the work sheet (both
vertical and horizontal) we can select that how many divider sticks we want,
both vertical and horizontal
3. Hide and Unhide actions should also be repeated if we press F4 or there
should another button that repeats the action of Hide – Unhide.
4. When we cut, then there should a facility of Paste Special same as like
“Copyâ€.
5. Freeze pan action should be used more than one time at a time both
horizontal and vertical. In short Freeze Pan should also be used for 2 or
more times.
6. Transpose should have an extra facility to transpose the selected cells
from down to up and up to down.
Like,
1
2
3
4
5
Can be transposed as
5
4
3
2
1
Dream. The programming made in excel should be converted in to C, C++, VB,
JAVA & All other languages. Excel Should be the common platform for all other
languages.
7. Suppose some rows and columns are hidden. In this situation there should
an option in which we can copy only visual cells and paste them anywhere.
Same way Paste Special should have an option to paste on only visual cells.
8. Paste Special should have an option to write only value of formula like,
=a1+c3, =if(g1<>4,g2,h4) etc.
9. There should an option that allows not to save in selected cell
10. There should an option of Unhide from this to that. (This line to that
line)
11. Remove Border in Different Shape: We can draw borders in excel. There
should an option to remove border in the same manner we draw. Like we can
draw border in square shape then removing that border in square shape should
also be made available.
12. Formula For making any number two digits, three etc digits by putting 0
in the left side of a number. Like if we want to make 1 in 4 digits, 0001
should be the formula result
13. When formula is long, and the formula bar is full then the formula
display begins in the second line and therefore we cannot see row name A, B,
C, D then it becomes difficult to check the formula. There should something
helpful.
14. When we press f2 to see the formula then the next few cells in the right
side are becomes invisible to see the box. There should be something trick to
see those cells.
15. Unhide should be done from both upper and lower side. (One by one
and from “this to that†option should be available.)
16. Formula- write the text from a cell till “ “(Two Spaces come) or
Write the sentence till “&†not come.
17. What changes have made within the worksheet that should be
maintained. We can also recover our work from that point. So there should two
kind of “SAVE†1. Internal Save that can help us not to loose any entered
data. If electricity gone or any thing else then entered data will be lost.
2. External Save that we are already using as “SAVEâ€.
18. Replace Option should have a facility to replace more than one thing
together at one time. Like if selected criteria contains a5=1,a5=2,a5=3 if we
want to replace 1 to 2, 2 to 3 and 3 to 1, then we have to replace 3 times.
If we replace 1 to 3 or 3 to 1 at first time then there will be problem that
we can not replace 3 to 1 or 1 to 3 otherwise all 1s will be 3s or all 3s
will be 1s. So if there is a option like
Replace 1
Replace 2
Replace 3
And more in a single selection at a time, then there will be no problem.
19. Find, Replace, Goto windows should be displayed on the top of the
screen when used. Because of that window, we cannot see data near the
displayed area because there is a window of Find, Replace or Goto. We have to
move that window. If from the beginning that window is displayed on the top
or the bottom of the screen, because the word, which we have to find, is
displayed in the middle of the screen.
Or there is another way that the found data should be displayed from the top.
In short the found data (result) should not behind the window.
20. There should an option in the popup menu of the right click (Spelling or
Grammar Mistake – Red or Green Underline)
Ignore All and > Cut
Copy
So we don’t have to copy or cut the word again after ignoring the
underline.
21. Increase Indent and Decrease indent should have a selection to skip
minimum space (as one space).
22. There should an option to make bold or differ the words those are
grammatically false or having spelling mistakes.
E.g. we select a paragraph, when we click the right mouse button then in the
pop up menu there should an option to differ the words those are under lined.
There should two options, one for green and one for red. So that if we copy
the text at any other place like in paint brush or compose e-mail box or any
other place, we can differentiate those words.
23. Drawing toll bar should have another button like “Square†by which we
draw a square.But the square about which I am telling should have an extra
facility to show the height and length of the square exactly connected with
that square. We can also change the parameters like inches, foot, and
centimeters etc in compressed form. Whichever parameter we want to use should
make available to us.At least it should provide an approximate figure of the
square.
24. In Microsoft word there should be a facility to give Name or
Identity to any selected Paragraph, line, or any character or criteria.
Example. Here is given the paragraph.
I believe in hearing great ideas of an ordinary man who just knows what he
wants to do. He doesn’t know the proper words or style what he wants to say.
He always tries to explain the thing what he wants to do, in any style or
format. It is the duty of the authority to respond him in a proper manner.
Step – by – step.
1. Select the paragraph.
2. Right click on the selection.
3. Here I want to suggest a button in the pop up menu named “GIVE IDENTY†or
anything like that.
4. While clicking on that button word will ask us to give a name or identity
to that selected paragraph. (or line or any character, number, criteria etc.)
5. There should be a place in which the name is displayed while the cursor
is moving on from that paragraph which has given a name. Just as like the
Column no, Page No. is displayed on line.
Assume that we have given a name or identity to above paragraph as “Book
Name – Referenceâ€.
Now when the cursor is on that paragraph, “Book Name – Reference†will be
displayed on the screen at the lower right part of the screen.
25. The word “well wisher†in Microsoft word contains mistake while
indicates the grammar check (Green) line. While we right click on the green
underlined word “well wisherâ€, the MS Word suggests “well-wisherâ€. Again the
word “well-wisher†becomes green underlined word!! And asks for check the
grammar. When we again make right click on “well-wisherâ€, it again asks for
“well wisherâ€!
26. If we type “I†instead of “inâ€, “I†becomes an uppercase character. It
is necessary. But when we use backspace to type “in†the “I†does not become
in lowercase character. It may also necessary. I just want to say that if it
is possible to convert the uppercase “I†into lowercase “I†while
backspacing, then it will help a lot to the users.
If again we give space after “Iâ€, it should become an uppercase “Iâ€.
----------------
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/com...bfc7eb&dg=microsoft.public.word.docmanagement
are mostly based on office 2000.
1. Word count should be in Excel too and should give such information like
- How many characters are there in a cell,
E.g. How many “aâ€, “Aâ€, “bâ€, “B†Etc. are there in a cell
- How many symbols are there in a cell,
E.G. How many “!†“+†“=†Etc. are there in a cell.
- How many Upper case characters
- Lower
- Vowels
- Vyanjan
- Spaces
- Size in KB
- Is any formula used in the cell? If yes then how many sub formulas are
there in a main formula?
In Microsoft word above mentioned points should be given as a result word
count.
2. There should more divider sticks while we split the work sheet (both
vertical and horizontal) we can select that how many divider sticks we want,
both vertical and horizontal
3. Hide and Unhide actions should also be repeated if we press F4 or there
should another button that repeats the action of Hide – Unhide.
4. When we cut, then there should a facility of Paste Special same as like
“Copyâ€.
5. Freeze pan action should be used more than one time at a time both
horizontal and vertical. In short Freeze Pan should also be used for 2 or
more times.
6. Transpose should have an extra facility to transpose the selected cells
from down to up and up to down.
Like,
1
2
3
4
5
Can be transposed as
5
4
3
2
1
Dream. The programming made in excel should be converted in to C, C++, VB,
JAVA & All other languages. Excel Should be the common platform for all other
languages.
7. Suppose some rows and columns are hidden. In this situation there should
an option in which we can copy only visual cells and paste them anywhere.
Same way Paste Special should have an option to paste on only visual cells.
8. Paste Special should have an option to write only value of formula like,
=a1+c3, =if(g1<>4,g2,h4) etc.
9. There should an option that allows not to save in selected cell
10. There should an option of Unhide from this to that. (This line to that
line)
11. Remove Border in Different Shape: We can draw borders in excel. There
should an option to remove border in the same manner we draw. Like we can
draw border in square shape then removing that border in square shape should
also be made available.
12. Formula For making any number two digits, three etc digits by putting 0
in the left side of a number. Like if we want to make 1 in 4 digits, 0001
should be the formula result
13. When formula is long, and the formula bar is full then the formula
display begins in the second line and therefore we cannot see row name A, B,
C, D then it becomes difficult to check the formula. There should something
helpful.
14. When we press f2 to see the formula then the next few cells in the right
side are becomes invisible to see the box. There should be something trick to
see those cells.
15. Unhide should be done from both upper and lower side. (One by one
and from “this to that†option should be available.)
16. Formula- write the text from a cell till “ “(Two Spaces come) or
Write the sentence till “&†not come.
17. What changes have made within the worksheet that should be
maintained. We can also recover our work from that point. So there should two
kind of “SAVE†1. Internal Save that can help us not to loose any entered
data. If electricity gone or any thing else then entered data will be lost.
2. External Save that we are already using as “SAVEâ€.
18. Replace Option should have a facility to replace more than one thing
together at one time. Like if selected criteria contains a5=1,a5=2,a5=3 if we
want to replace 1 to 2, 2 to 3 and 3 to 1, then we have to replace 3 times.
If we replace 1 to 3 or 3 to 1 at first time then there will be problem that
we can not replace 3 to 1 or 1 to 3 otherwise all 1s will be 3s or all 3s
will be 1s. So if there is a option like
Replace 1
Replace 2
Replace 3
And more in a single selection at a time, then there will be no problem.
19. Find, Replace, Goto windows should be displayed on the top of the
screen when used. Because of that window, we cannot see data near the
displayed area because there is a window of Find, Replace or Goto. We have to
move that window. If from the beginning that window is displayed on the top
or the bottom of the screen, because the word, which we have to find, is
displayed in the middle of the screen.
Or there is another way that the found data should be displayed from the top.
In short the found data (result) should not behind the window.
20. There should an option in the popup menu of the right click (Spelling or
Grammar Mistake – Red or Green Underline)
Ignore All and > Cut
Copy
So we don’t have to copy or cut the word again after ignoring the
underline.
21. Increase Indent and Decrease indent should have a selection to skip
minimum space (as one space).
22. There should an option to make bold or differ the words those are
grammatically false or having spelling mistakes.
E.g. we select a paragraph, when we click the right mouse button then in the
pop up menu there should an option to differ the words those are under lined.
There should two options, one for green and one for red. So that if we copy
the text at any other place like in paint brush or compose e-mail box or any
other place, we can differentiate those words.
23. Drawing toll bar should have another button like “Square†by which we
draw a square.But the square about which I am telling should have an extra
facility to show the height and length of the square exactly connected with
that square. We can also change the parameters like inches, foot, and
centimeters etc in compressed form. Whichever parameter we want to use should
make available to us.At least it should provide an approximate figure of the
square.
24. In Microsoft word there should be a facility to give Name or
Identity to any selected Paragraph, line, or any character or criteria.
Example. Here is given the paragraph.
I believe in hearing great ideas of an ordinary man who just knows what he
wants to do. He doesn’t know the proper words or style what he wants to say.
He always tries to explain the thing what he wants to do, in any style or
format. It is the duty of the authority to respond him in a proper manner.
Step – by – step.
1. Select the paragraph.
2. Right click on the selection.
3. Here I want to suggest a button in the pop up menu named “GIVE IDENTY†or
anything like that.
4. While clicking on that button word will ask us to give a name or identity
to that selected paragraph. (or line or any character, number, criteria etc.)
5. There should be a place in which the name is displayed while the cursor
is moving on from that paragraph which has given a name. Just as like the
Column no, Page No. is displayed on line.
Assume that we have given a name or identity to above paragraph as “Book
Name – Referenceâ€.
Now when the cursor is on that paragraph, “Book Name – Reference†will be
displayed on the screen at the lower right part of the screen.
25. The word “well wisher†in Microsoft word contains mistake while
indicates the grammar check (Green) line. While we right click on the green
underlined word “well wisherâ€, the MS Word suggests “well-wisherâ€. Again the
word “well-wisher†becomes green underlined word!! And asks for check the
grammar. When we again make right click on “well-wisherâ€, it again asks for
“well wisherâ€!
26. If we type “I†instead of “inâ€, “I†becomes an uppercase character. It
is necessary. But when we use backspace to type “in†the “I†does not become
in lowercase character. It may also necessary. I just want to say that if it
is possible to convert the uppercase “I†into lowercase “I†while
backspacing, then it will help a lot to the users.
If again we give space after “Iâ€, it should become an uppercase “Iâ€.
----------------
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/com...bfc7eb&dg=microsoft.public.word.docmanagement