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 readingAuthor Archives: Karl
How 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 readingHow to change the orientation of the slide? | Powerpoint 2007
For changing the orientation of the slide, go under the Design tab and to the Page Setup section. Click on the “Slide Orientation” and switch between Portrait and Landscape.
Continue readingHow to create forms for users to fill in? | Word 2007
Probably the best way to keep the formatting unchanged and all the settings in place is to have the text entered into a table. We’re going to do a sample here for better understanding. Go to the Insert tab and under the button “Table” select three rows and two columns. For our first row we’ll use the “Merge” function. Select both cells and go under Table Layout tab. From there choose the option “Merge Cells”.
Continue readingAdding Notes | Powerpoint 2007
Add notes to every slide to leave you reminders. Add notes below the slides.
Continue readingHow to make all text visible in the cell by showing the text on multiple lines? | Excel 2007
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 reading