Well you can protect the selected work sheet allowing other sheets to be
unprotected.
go to the sheet which you want to protect and press incert+shift+s and go to
protect sheet and it will ask for the password, hit tab to go to ok and
reenter the password you are done.
an alternet waty is press alt+r, ps and follow the above procedure.
zoher kheriwala taheri menswear mumbai. skype id zoher.kheriwala
----- Original Message -----
From: "Mukesh" <[email protected]>
To: <[email protected]>
Sent: Thursday, March 28, 2013 5:46 PM
Subject: Re: [AI] Comment in Excel
Dear Apoorv,
Thank you for your quick step by step guidance. It's very helpful.
I have one more query as follows:
I have created names in name manager in a workbook. I have created a
programme and want to hide the 'information' sheet only to avoide any
problem of data change by anyone else except me. But I don't want to
protect other sheets in that workbook. How to do this?
I want to use those names in other workbooks on my computer without
creating it in each workbook. How can I use those names in another
workbook? I want to avoide the laborious job of creating names in each
workbook.
Thanking you in anticipation.
-----Original Message-----
From: Apoorv Kulkarni
Sent: Thursday, March 28, 2013 11:23 AM
To: Accessindia
Subject: [AI] Comment in Excel
Hello,
Let me break my reply in 2 parts. 1) inserting comments, and 2) reading
comments:
1) Inserting comments
Step 1: go to the cell where you wish to insert comment
Step 2: press APPLICATION key on your keyboard to bring up the application
menu. If you don't have a dedicated applications key, press SHIFT + F10.
Step 3: go down the menu till you find the "Insert Comment" option and
press
ENTER
Step 4: Type your comment and press ESCAPE
2) Reading Comments in Excel
Step 1: Go to the JAWS Quick Setting - Excel dialog box by pressing INSERT
+
V.
Step 2: type "comment" in the edit box and go down till you find "Comment
detection"
Step 3: Press F6 and check the box for turning the comment detection on
and
press ESCAPE. Checking this option will make JAWS alert you whenever the
active cell has a comment.
Step 4: To get a list of cells in the worksheet containing comments, press
CTRL+SHIFT+APOSTROPHE. This will bring up a dialog box which will contain
a
list of all cells containing comments.
Step 6: If you are in a cell containing comments and you wish to read the
comment, press ALT+SHIFT+APOSTROPHE.
Hope this helps.
Regards,
Apoorv
Register at the dedicated AccessIndia list for discussing accessibility of
mobile phones / Tabs on:
http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessindia.org.in
Search for old postings at:
http://www.mail-archive.com/[email protected]/
To unsubscribe send a message to
[email protected]
with the subject unsubscribe.
To change your subscription to digest mode or make any other changes,
please visit the list home page at
http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in
Regards
Mukesh Baviskar
Mobile: 9403161157
Skype id: mukeshbaviskar
Blog:
http://mukeshbaviskar.blogspot.com
Register at the dedicated AccessIndia list for discussing accessibility of
mobile phones / Tabs on:
http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessindia.org.in
Search for old postings at:
http://www.mail-archive.com/[email protected]/
To unsubscribe send a message to
[email protected]
with the subject unsubscribe.
To change your subscription to digest mode or make any other changes,
please visit the list home page at
http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in
Register at the dedicated AccessIndia list for discussing accessibility of
mobile phones / Tabs on:
http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessindia.org.in
Search for old postings at:
http://www.mail-archive.com/[email protected]/
To unsubscribe send a message to
[email protected]
with the subject unsubscribe.
To change your subscription to digest mode or make any other changes, please
visit the list home page at
http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in
