Select the cell you want to show all text and go under Home tab into Alignment section. Next click on “Wrap Text” and notice how the text is entirely shown in the cell.
Continue readingCategory Archives: Excel 2007
How to filter a list of data for multiple items? | Excel 2007
First off you need to apply filter to your column. To do that select the row, cell or cells you wish for the filter to appear and go to Home tab under Editing section. Click on “Sort & Filter” and choose “Filter” from the menu. Now click on the appearing small arrow inside the cell and uncheck “(Select All)” from the selection menu and check the boxes representing the items you wish to appear on your selection.
Continue readingHow to change the orientation of a text in a cell? | Excel 2007
Select the cell or cells and go under Home tab into Alignment section. Notice that there is a button just at the top middle of the section called “Orientation”. Just click on the button and choose from the menu the orientation you wish for the text to be shown in.
Continue readingHow to add a data table to a chart? | Excel 2007
Click on the chart and go under Chart Tools and Layout tab. In Labels section click on “Data Table” and from the appearing menu choose whether you wish for the table to show up in the first place or whether the table should include the legend keys as well. The last option is handy in case you wish to remove the legend from the chart.
Continue readingHow to insert image into the cell? | Excel 2007
You can’t insert image into the cell but you can snap image to the grid, so it will remain in the same location. When an image is selected the “Picture tools” tab will open. Under Arrange section click on “Align” and choose “Snap to Grid”. Move your image to the right cell
Continue readingHow to add, remove or reposition chart legend? | Excel 2007
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 you wish for the legend to show in the first place, or the placement of it if you decide to show it on the graph.
Continue readingHow to change the dots on the line graph? | Excel 2007
Right click on the data series, choose “Format Data Series” and go under “Marker Options” menu from the left. Under Marker Type select whether you want the markers to be Automatic, None or Built-in. “Automatic” comes with the chart type, “None” obviously means that no markers are used and “Built-in” enables you to select from the down appearing menu the more suitable marker. Under “Size” you can determine the size of the marker as well.
Continue reading