
140 Excel | How to add, remove or reposition chart legend?
Click on the chart and go under Chart Tools and Layout tab. In Labels section click on “Legend” and from the appearing menu choose whether y...
Radio and PodcastLive Radio & PodcastsOpening Radio and Podcast...

Radio and PodcastLive Radio & PodcastsFetching podcast shows and categories...
Radio and PodcastLive Radio & PodcastsFetching podcast episodes...

Giving daily Office tips for Word, Excel and Powerpoint so you can be more effective and have better results. For older Daily Tips please visit our website www.officetodo.com

Click on the chart and go under Chart Tools and Layout tab. In Labels section click on “Legend” and from the appearing menu choose whether y...

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 whic...

Click on the chart and go under Chart Tools and Layout tab. In Labels section click on “Chart Title” and from the appearing menu choose the...

Best used for this is the scatter chart. Select your table only including cells that you wish to be presented on the chart and go under Inse...

Best used for this is area charts. Select your table only including cells that you wish to be presented on the chart and go under Insert tab...

Best used for displaying multiple values comparison is a chart with bars. Select your table only including the cells you wish to be presente...

Best used for contribution display is a pie chart. Select your table only including the cells you wish to be presented on the chart and go u...

Best used for trends is a chart with lines. Select your table only including the cells you wish to be presented on the chart and go under In...

If you have for some reason chosen an inappropriate type of chart, you can easily change it. First select the chart and go under Chart Tools...

Best used for such a comparison is the chart with columns. Select your table only including the cells you wish to be presented on the chart...

Go to Review tab and under Tracking section click on “Track changes” to enable them. - Office ToDo

Right click on the bubble and choose “Delete Comment” from the menu. In case you wish to delete all comments in your document, go under Revi...

Select your text or part of the text you wish to comment and go to Review tab. Under Comments choose “New Comment”. To the right side of the...

One way, if you prefer not going to the taskbar, is to go under View tab and Window section. Click on “Switch Windows” and choose the docume...

Go to View tab under Window section and press on “Split”. You’ll get an opportunity to place the point where the split is created. Click onc...

First have those two documents open. From one document go under View tab and in Window section choose “Arrange All”. This way you’ll have tw...

Go under Home tab into Editing section and press on “Find”. In the new window type the word you wish to find and click on “Find next”. - Off...

If you need to replace a specific word in your document, press the button “Replace” under Home tab in Editing section. Under “Find what” typ...

The paragraphs work a lot like tables. Have your cursor in your selected paragraph and work around with the selections under Paragraph secti...

In Word you can sort text, numbers and dates. Select your data and click on the button “Sort”, which is located under Home tab in Paragraph...

First select the slide or slides from the Slides menu on the left. Multiple slides can be selected whilst holding down CTRL on your keyboard...

Go under Home tab into Slides section. Click on “New Slide” and choose Reuse Slides from the down appearing menu. On the right side of the s...

Go to Slide Show tab under Monitors section. From Resolution choose the appropriate setting. These settings will impact only the slide show...

You can add comments for the slide as whole and to certain parts of text. Simply have either the slide selected from Slides menu on the left...

Under Office button there’s Save As menu. From there instead of PowerPoint presentation choose PowerPoint Show. Give your show a name and cl...

First select the text for which you wish to change the language. Notice that on the bottom left corner of the screen you have three sections...

Notice that on the bottom right corner there’s a zoom in and out bar and just next to it there’s an icon called “Slide Show”. Just click on...

Select the slide and go under Animations tab and into Transition to this Slide section. Click on Advance Slide and uncheck “On Mouse Click”...

Go under Slide Show tab and to Set Up section. Choose the box “Use Rehearsed Timings” and click on “Rehearse Timings”. Now you can tailor yo...

For changing the size of the slides, go under the Design and to the Page Setup section. Click on the “Page Setup” button and from the appear...

To have Excel apply the coloring depending on the values inside the cells, you should apply color scales. To do this, select the cells you w...

Perhaps the easiest way is to enter the data bars inside the cells. To do this, select the cells you wish to be analyzed and go under Home t...

First select the cells or just one cell depending on whether there’s a specific area you wish to clear from rules or you wish for the whole...

First select your cells and go under Home tab into Styles section. Choose the first button from the row called “Conditional Formatting”. Fro...

First select your cells and go under Home tab into Styles section. Choose the first button from the row called “Conditional Formatting”. Fro...

First select your cells and go under Home tab into Styles section. Choose the first button from the row called “Conditional Formatting”. Fro...

First select your cells and go under Home tab into Styles section. Choose the first button from the row called “Conditional Formatting”. Fro...

First select your cells and go under Home tab into Styles section. Choose the first button from the row called “Conditional Formatting”. Fro...

First select your cells and go under Home tab into Styles section. Choose the first button from the row called “Conditional Formatting”. Fro...

Select the cells you want to be analyzed and go under Home tab into Styles section. Choose the first button from the row called “Conditional...

On the ribbon under Home tab in Font section there’s a button at the top right corner called “Clear Formatting”. Select your text and click...

On the ribbon there's Quick Parts option under Insert menu. The Document Property inserts for example information pulled from properties. Yo...

Go to the Office button, choose Word Options and under Proofing choose Custom Dictionaries. Select the first option - "Edit Word List" and a...

Go with your cursor to the end of the sentence or a word you wish to add a reference to. Then go to References tab and click on “Insert Foot...

Go to the Office button and press on “Word options”. Go under Advanced menu and remove a tick from “Typing replaces selected text”. - Office...

First make sure you haven’t selected the image. To enter a transparent Text Box that will be visible on top of the image, go to the Insert t...

First make sure you haven’t selected the image. To enter a transparent Text Box that will be visible on top of the image, go to the Insert t...

Go to the ribbon onto the Home tab under Paragraph section. Click on the icon at the top right corner. - Office ToDo

Go to the ribbon onto the Home tab under Paragraph section. Click on the icon at the top right corner. - Office ToDo

Have your cursor in the paragraph and drag the bottom square on the ruler. This will change the left indent for the entire paragraph. - Offi...