Category Archives: MS Office

How 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 reading →

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 reading →