Tue 20 Feb 2018

Solution - Challenge 69- Need Help in Not Showing Comments

By |Tuesday, February 20th, 2018|Categories: Solutions|Tags: |0 Comments

Below is a possible solution to Challenge 69 - Need Help in Not Showing Comments

These are not comments but Data Validation Messages..

Select the cell where pop up message is appearing > Data tab > Data Validation > The pop message is in the Input Message > Either you can remove messages or just say clear all.

To remove them in block -
1. Select rows 1 to 7 > Data tab > Data Validation > Clear All
2. Select rows 20 to 22 > Data tab > Data Validation > Clear All

Sat 20 Jan 2018

Challenge 69 - Need Help in Not Showing Comments

By |Saturday, January 20th, 2018|Categories: Challenges|Tags: , |2 Comments

Download the workbook. Whenever I select a cell, the yellow box pops up. I need your help to provide me instructions to remove these.

The workbook can be downloaded from Challenge 69 - Comments

The solution to above challenge will be published after a month i.e. on 20-Feb-2018.

Sat 07 Feb 2015

Tips & Tricks 77 - Inserting picture in the comments box

By |Saturday, February 07th, 2015|Categories: Tips and Tricks|Tags: , , |0 Comments

The below discussion is for Excel 2013. If a cell is selected and it has comments, the comments will be displayed. Sometimes, there may be a need to display picture when you select a cell. I answered this question on Microsoft Community Forum and I have decided to reproduce it here.

1. Right click the cell > Edit Comment
2. Now, you need to right click on the border of the comments box. Do not select the comments inside the box and choose Format Comment. Since, you are inserting picture, hence you should not have comments in the box, anyway. So, there is no question of selecting comments inside the box. Once again, I will repeat that RIGHT CLICK ON COMMENTS BOX BORDER AND SELECT FORMAT COMMENTS.
3. Now, you will get Format Comments box and you need to select Color and Lines tab.
4. Click on Color: box and select Fill Effects.

1

5. When you click Fill Effects, choose Picture tab and select picture from there. By default, it starts connecting online to select picture. Most probably, you would like to select a picture on your computer. You may like to choose Work Offline here.

1

6. Now, you can have effect of picture in your comments like below -

1

Sat 11 Oct 2014

Tips & Tricks 59 - Remove Comments from All Sheets in a Workbook

By |Saturday, October 11th, 2014|Categories: Tips and Tricks|Tags: , , , , |0 Comments

In an earlier tip, I talked about how to remove all comments from a sheet. But that works on a sheet. If you want to remove from all sheets in one go rather than doing for every sheet separately, use following trick -

1. Office Button > Prepare > Inspect Document

1

2. A warning message will come, press Yes.1

3. In the next box which comes, DESELECT all box except Comments and Annotations. Press Inspect.1

4. If comments are found, it will say so. Press Remove All. This will remove All comments from the Workbook.1

Sat 04 Oct 2014

Tips & Tricks 57 - Remove All Comments from a Sheet

By |Saturday, October 04th, 2014|Categories: Tips and Tricks|Tags: , , |0 Comments

1. Home Tab > Find and Select > Comments - This will select all the cells where comments are there.

1

2. Home Tab > Clear > Clear Comments - This will clear all comments from the sheet

1

Sat 20 Sep 2014

Tips & Tricks 53 - Print Comments in the Sheet

By |Saturday, September 20th, 2014|Categories: Tips and Tricks|Tags: , , |0 Comments

1. You need to show the comments which you want to print or you can show all comments in the sheet. To show the comments

 Show Comments in the Sheet

2. First step is mandatory for printing the comments. Only those comments will be printed which are shown in the sheet.

3. ALT+PSP

1

4. After setting up page, you can fire the print.

Sat 20 Sep 2014

Tips & Tricks 52 - Show Comments in the Sheet

By |Saturday, September 20th, 2014|Categories: Tips and Tricks|Tags: , , |2 Comments

1. If you want to show all comments in the sheet -

1.1 Go to Review tab and click on Show All Comments.

1

2. If you want to show selected few comments (not all) in the sheet -

2.1 Click a cell where the comment is.

2.2 Go to Review tab and click on Show / Hide Comments. If step 1 is not followed, Show / Hide Comments will be greyed out. Another option is to right click and you will have Show/Hide Comments in the menu.

Note - This has to be done for all cells individually where you want to show the comments. Selecting all cells and then clicking on Show / Hide Comments will be showing comments only in last selected cell.

1