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 “Above Average …” From the appearing 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 readingAuthor Archives: Karl
How to insert photo album presentation in black and white? | Powerpoint 2007
Go on Insert Tab under Illustration section. Press the button “Photo album”. Press “File/Disk” to choose your pictures. You can choose multiple files all at once. After choosing files in “Picture options” click “ALL pictures black and white”. Press “Create”.
Continue readingHow to quickly apply the percentage style? | Excel 2007
Select the cell or cells and go under Home tab into Number section. To apply a percentage style onto a cell, click on the button with a percentage sign on it.
Continue readingHow to apply track changes? | Word iPad?
Go to Review tab and look for Track changes. On the slider drag from left to right until the slider is green. Now the Word tracks the changes you make to the document.
Continue readingHow to add a comment? | Word iPad
Tap and hold on screen close to the area you want to place the comment for. From menu choose Select and from appearing blue bubbles drag the selected area. From the new menu choose New comment.
Continue readingHow to replace {PAGE} with actual page number? | Word 2013
If you are seeing {PAGE} or {NUMPAGES} and no actual page number then you have toggled to show field codes instead of values. Use keyboard shortcut ALT+F9 and actual values will appear.
Continue readingCreating new presentation | Powerpoint 2007
In this lesson we show you how to get started with your first PowerPoint presentation.
Continue reading