Re: [AI] Comment in Excel
Ok! Actually I want to protect the hidden sheet from making it unhide without password. I don't want to show the users the data of this sheet. -Original Message- From: zoher kheriwala Sent: Thursday, March 28, 2013 7:52 PM To: accessindia@accessindia.org.in Subject: Re: [AI] Comment in Excel 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" To: 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/accessindia@accessindia.org.in/ To unsubscribe send a message to accessindia-requ...@accessindia.org.in 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/accessindia@accessindia.org.in/ To unsubscribe send a message to accessindia-requ...@accessindia.org.in 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/accessindia@accessindia.org.in/ To unsubscribe send a message to accessindia-requ...@accessindia.org.in 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 p
Re: [AI] Comment in Excel
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" To: 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/accessindia@accessindia.org.in/ To unsubscribe send a message to accessindia-requ...@accessindia.org.in 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/accessindia@accessindia.org.in/ To unsubscribe send a message to accessindia-requ...@accessindia.org.in 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/accessindia@accessindia.org.in/ To unsubscribe send a message to accessindia-requ...@accessindia.org.in 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
Re: [AI] Comment in excel
Thank you Zohar. The shortcuts are working fine. -Original Message- From: zoher kheriwala Sent: Thursday, March 28, 2013 11:28 AM To: accessindia@accessindia.org.in Subject: Re: [AI] Comment in excel Put your curser in the cell where you want to incert the comment, If you want to incert the new comment then press alt+r, c. and type the comment and hit enter, to read the comment press alt+shift+apostafy. to edit the comment, press alt+r+t and to delete the comment press alt+r+d. zoher kheriwala taheri menswear mumbai. skype id zoher.kheriwala - Original Message - From: "Mukesh" To: "Access India" Sent: Thursday, March 28, 2013 5:13 AM Subject: [AI] Comment in excel Dear Friends, How to insert/read/delete the comment in excel with a help of key board? I’m using m. s. office 2007 and windows 7 home premium. 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/accessindia@accessindia.org.in/ To unsubscribe send a message to accessindia-requ...@accessindia.org.in 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/accessindia@accessindia.org.in/ To unsubscribe send a message to accessindia-requ...@accessindia.org.in 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/accessindia@accessindia.org.in/ To unsubscribe send a message to accessindia-requ...@accessindia.org.in 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
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/accessindia@accessindia.org.in/ To unsubscribe send a message to accessindia-requ...@accessindia.org.in 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/accessindia@accessindia.org.in/ To unsubscribe send a message to accessindia-requ...@accessindia.org.in 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
Re: [AI] Comment in excel
Put your curser in the cell where you want to incert the comment, If you want to incert the new comment then press alt+r, c. and type the comment and hit enter, to read the comment press alt+shift+apostafy. to edit the comment, press alt+r+t and to delete the comment press alt+r+d. zoher kheriwala taheri menswear mumbai. skype id zoher.kheriwala - Original Message - From: "Mukesh" To: "Access India" Sent: Thursday, March 28, 2013 5:13 AM Subject: [AI] Comment in excel Dear Friends, How to insert/read/delete the comment in excel with a help of key board? I’m using m. s. office 2007 and windows 7 home premium. 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/accessindia@accessindia.org.in/ To unsubscribe send a message to accessindia-requ...@accessindia.org.in 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/accessindia@accessindia.org.in/ To unsubscribe send a message to accessindia-requ...@accessindia.org.in 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
[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/accessindia@accessindia.org.in/ To unsubscribe send a message to accessindia-requ...@accessindia.org.in 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
Re: [AI] Comment in excel
Hi Mukesh, I am on office 2010 so the steps may differ for you. Check the review tab of the ribben. That has an option to insert comments. Pranav 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/accessindia@accessindia.org.in/ To unsubscribe send a message to accessindia-requ...@accessindia.org.in 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
[AI] Comment in excel
Dear Friends, How to insert/read/delete the comment in excel with a help of key board? I’m using m. s. office 2007 and windows 7 home premium. 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/accessindia@accessindia.org.in/ To unsubscribe send a message to accessindia-requ...@accessindia.org.in 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