If you have too many cells across a particular row or too many rows in a column in your Microsoft Word table, a quick way to decrease the number of cells or rows is to use the Tables and Borders toolbar. To use the toolbar to merge cells, follow these steps:
- If the Tables and Borders toolbar is not visible, right-click any toolbar and click Tables And Borders to activate it.
- Select the cells you want to merge.
- Click the Merge Cells button on the toolbar.
You can also quickly change the dimensions of your table by using the toolbar's Split Cells button. For example, to change a 2-by-2 table to an 8-by-8 table, select the table, click the Split Cells button, and enter 8 for the number of columns and 8 for the number of rows. If want to divide a single cell into two columns and two rows, follow these steps:
- Click the cell you want to change and click the Split Cells button.
- Enter 2 as the Number Of Columns and 2 as the Number Of Rows.
- Clear the Merge Cells Before Split check box and click OK.
Sort four or more columns of Excel data at once
Microsoft Excel's sort command lets you sort three fields at once. But what if you need to sort four or more fields at one time? For example, suppose you want to sort your customers in this order (the customers’ first names, last names, addresses, and cities are in columns A, B, C, and D, respectively):
- Region (column E)
- State (column F)
- Zip Code (column G)
- Sales (column H) within each zip code
To do this, you will need to run the sort function twice in reverse order, as shown in the following steps:
- Select the data you want to sort.
- Go to Data | Sort.
- Select Sales from the Sort By drop-down box.
- Select Zip Code from the Then By drop-down box.
- Select State from the second Then By drop-down box.
- Click OK.
- With the data still selected, go to Data | Sort.
- Select Region from the Sort By drop-down box.
- Click OK.
Add a Close Form command button to your Access form
Once you disable the Close button on a Microsoft Access form, you might be perplexed as to how users can close the form when they are done. You can simply use the command wizard to add a button to the form that, when clicked, will allow users to exit the form.
First, you need to open the form in Design View, and make sure the Control Wizard button in the toolbox is selected. Then, follow these steps:
- Click the Command Button tool, and then click where you want the button to appear in your form.
- Select the Form Operations category and then click Close Form under Actions.
- Select the default text or type your own, and click Next.
- Enter a name for the command, such as CloseForm button, and then click Finish.