Click on File on the ribbon.
Click on Open and RecentContinue reading
Select the list; go under Data tab and Data tools section. Choose “Remove duplicates”. Now you can choose which columns are searched for duplicates. Press “OK”. A message will let you know how many duplicates were found.Continue reading
Place your cursor inside a placeholder and go under Home tab into Paragraph section. In case you have applied a direction change, go under the same menu in “Text Direction” and choose “More Options” from the menu. From the appearing new window remove a check in front of “Wrap text in shape”. This will remove the wrap and your text is shown in a straight line.Continue reading
Right click on the hyperlink and choose „Remove Hyperlink”. Unfortunately it’s not possible to remove all the hyperlinks at one go so in case of numerous links, the removing has to be manual and individual.Continue reading
Click on the chart and go under Chart Tools and Layout tab. In Labels section click on “Axis Titles” and from the appearing menu choose which axis you wish to edit. From the next selection determine whether you wish for the title to show up or not. Also choose the placement for the title if you decide to show it on the chart. Unfortunately no live preview is shown however you get a pretty good image of the display from the little picture before every selection.Continue reading
When you have just created continuous line then you can click on the lighting button and undo the line. You can also stop it from doing that again in the future. The button will disappear when you have done some more actions afterwards.Continue reading