Microsoft Excel Question:
Download Questions PDF

Can you tell me how I can put comments in my spreadsheet for instructions that pertain to a specific cell in Microsoft Excel?

Answer:

First you will need to click on the specific cell that you want the comment to refer to. Go to Insert on the menu bar and then select Comment. You can now type your message. After typing your message you can click outside of the comment box onto another cell. You can tell that there is a comment associated with that cell because a small red triangle will be in the upper right hand corner of the cell. When you want to see the comment, you can either put your mouse over the cell and it will appear or you can set Excel to always show comments. To do this you will need to go to Tools on the Menu bar and select Options and then click on the View tab. Then, choose the Comment & Indicator option in the Comments section and then click on OK.

Download MS Excel Interview Questions And Answers PDF

Previous QuestionNext Question
Please tell me how I can split combined data into separate columns in an Excel spreadsheet. For example I have a spreadsheet that contains the city and state (i.e. Kennett Square, PA) in the same column and I would like to have them in two separate columns?I create lots of graphs with Excel. Unfortunately, the options to which Excel defaults are not the ones I use most. Is there any way to change the graph defaults to the ones I prefer?