To hide them simply click on the “x” sign at the right top corner. To show the pane again, move your cursor at the edge of the screen and drag the pane to be visible.
Continue readingAuthor Archives: Karl
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 hide the table gridlines? | Word 2007
Select the table and right click on the table. Choose “Borders and Shading” from the menu. Under Borders tab choose “None” from the left handed menu.
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 filename to header or footer? | Word 2007
Go into the header mode by clicking with your right mouse button on the header and choose “Edit Header”. To add custom information go to the “Insert” section under the Header & Footer tools tab on the ribbon and click “Quick parts”. In the menu choose “Field”. You will get a list of what you can add into your header. Find “Filename” from the list. Choose how you want the data to be formated. If you want the file path also then add check to “Add path to filename”. Press “OK” to finish.
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 make an image transparent? | Powerpoint 2007
One easiest solution is to go under Picture Tools Format tab and click on “Picture Effects”, which is located in the Picture Styles section. From there choose “Preset” and move to “Preset 8”. Simply hover over to see the live preview and if it suits you.
Continue reading