If you want to move to the next line inside the cell, first make sure you are inside the cell by double clicking the cell and when your cursor is in the correct spot, hold down “ALT” and press “ENTER” on your keyboard.
Continue readingCategory Archives: Excel 2007
How to change the chart type? | Excel 2007
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 and Design tab. From there the very first button on the ribbon is called “Change Chart Type”. Click on it once and you’ll be able to try again with hopefully a more suitable chart type for you.
Continue readingHow to see bottom ten percent of 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 “Bottom 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 bottom values forming 10% in terms of items.
Continue readingHow to compare pairs of values? | Excel 2007
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 Insert tab into Charts section. Under “Scatter” choose the type of scatter that suits you best. Unfortunately no live preview is available on this case.
Continue readingHow to keep the columns still hidden after copying the whole table? | Excel 2007
First unhide the columns. If you want to copy the whole table then to unhide all the columns hidden, simply select the entire worksheet and click on the column labels with your right mouse button and choose “Unhide”. When this is done, select and copy the data. Afterwards use the „Undo” command to hide all the columns that were unhiden. Now paste the previously copied data.
Continue readingHow to automatically format if the values are higher than specified amount? | Excel 2007
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 Formatting”. From there choose “Highlight Cell Rules” and “Greater Than …” From the new menu choose the amount from which the cells are formatted and 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”.
Continue readingHow to compare values across categories on a chart? | Excel 2007
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 and go under Insert tab into Charts section. Under “Column” choose the type of the column chart that suits you best. Unfortunately no live preview is applicable in this case.
Continue reading