To change default settings for every new workbook, go to the Office button, choose “Excel options” and go to the “When creating new workbooks” section. Choose the settings suitable for you and when you are satisfied, click OK.
Continue readingCategory Archives: Excel 2007
How to change the color of markers on a graph? | Excel 2007
Right click on the data series you wish to change, choose “Format Data Series” and go under “Marker Fill” menu from the left. By default the filling is on “Automatic” which comes with the graph type selected. To change the coloring choose the option “Solid Fill” and from the selections appearing below determine the more appropriate color and transparency of it. The higher the transparency the more the markers see through.
Continue readingHow to add, remove or reposition text used to label each axis? | Excel 2007
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 readingHow to display trends over time on a chart? | Excel 2007
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 Insert tab into Charts section. Under “Line” choose the type of the line chart that suits you best. Unfortunately no live preview is applicable in this case.
Continue readingHow to apply filter to a column? | Excel 2007
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.
Continue readingHow to see top ten percent of your items on the list? | Excel 2007
First select your cells and go under Home tab into Styles section. Choose the first button from the row called “Conditional Formatting”. From there choose “Top/Bottom Rules” and “Top 10 % …” In the menu you can choose the percentage to be reached. By default the number is 10. From the right sided drop-down menu select the style you wish to apply. Notice that some only apply to text or background whilst others format both of those. If you are satisfied, click on “OK”. Remember that this percentage does not come from total value of the list, but from the top values forming 10% in terms of items.
Continue readingHow to disable the “read-only”? | Excel 2007
To change a file from read-only, right click on the file in your Explorer folder or desktop and choose Properties. From there uncheck the read-only box.
Continue reading