Posts Tagged ‘menu’

« Older Entries
Newer Entries »

Printing Different Pages in MS Excel

Wednesday, February 9th, 2011

Have you ever wondered how to print specific pages of your worksheet like you can do in MS Word? Well if you have, read on.

If each of your worksheets fit on one page (single sheet) then the answer to your question is fairly simple.  All you really need to do is select the worksheets that you would like to print, using your CTRL key to select each worksheet tab. Then when you print, only those worksheets will be printed.

However, if you would like to print specific pages from a worksheet that normally flows to multiple pages, then the answer is a bit more vexing.

One method is to temporarily hide the unwanted portions of your worksheet and then print the unhidden area. There is, however,  a much simpler resolution.

Follow the steps below to learn how:

  1. Click on View | Page Break Preview.
  2. MS Excel will display your worksheet, showing the various page breaks. In version 2007, this view is available to you by displaying the View tab of your Ribbon and clicking the Page Break Preview tool in the Workbook Views group.
  3. Select all cells in the first page you want printed.
  4. Hold down your CTRL key and select all the cells in your second page you want printed.
  5. Repeat steps 3 and 4 above,  for each page you would like to print.
  6. Click on File | Print to display the Print dialog box.  In version 2007, click Office button | Print.
  7. In the Print What area, select Selection.
  8. Click OK.
  9. MS Excel will print the pages you previously selected.
  10. Close the Page Break Preview display.

Versions 97, 2000, 2002, 2003, 2007

Tags: , , , , , , , , ,
Posted in Excel 2003, Excel 2007, Microsoft Office | No Comments »

Where is Close All and Save All Command in Word 2007?

Wednesday, January 27th, 2010

In previous versions of  MS Word it was easier to use the Close All and Save All command.  All you had to do was click the Shift key and hold it while you simultaneously clicked on File. The menu would then display those commands for you.

Unfortunately, these commands are not as readily available to you in version 2007.  Fear not though, you can still use these commands.

Follow the steps below to learn how:

  1. Click the small drop-down arrow to the right of your Quick Access (QAT) toolbar and select More Commands.
  2. Click on Customize in the left column.
  3. Click on Choose Commands From drop-down arrow and select Commands Not in the Ribbon.
  4. Select Close All.
  5. Click on the Add button.
  6. Select Save All.
  7. Click on the Add button.
  8. Click OK.

You will now have access to those commands on your QAT.

Tags: , , , , , , , , ,
Posted in Microsoft Office, Microsoft Office Word, Word 2003, Word 2007 | No Comments »

Calculate Totals Within a Table in MS Word

Wednesday, June 3rd, 2009

When you have a list of numbers and you want to show totals, you do not need to start Windows’ built-in Calculator to sum them.

MS Word can calculate totals and averages and do other simple calculations. In order to do this though, you must have your Tables and Borders toolbar visible.

Before you start, click on View | Toolbars or right-click on an empty space on an existing toolbar and select Tables and Borders.

Follow the instructions below to begin summing figures:

Simply place your cursor in a blank cell of your table, below or to the right ofthe numbers you would like to total.

Click the AutoSum (resembles a sideways letter M) button on the Tables and Borders toolbar to calculate totals automatically.

To make other types of calculations, Click on Table | Formula. This will open the dialog box.

If your figures should change, you must recalculate the formual. To do this, select the formula and press the F9 key.

When you place a formula in a table, the numbers appear with grey shading. They will not print in grey though. The grey shading simply lets you know that you have a formula, not just typed figures.

You can also total figures in paragraphs in MS Word. The Calculate function in MS Word ignores any text that is not a number, except for currency symbols, periods and commas, which it recognizes when they are part of a number.

For operations other than addition, you must include the mathematical operator. To force a calculation out of precedence order, enclose the expression in parentheses.

You can add the Tools Calculate button to any toolbar or shortcut menu by following the steps below:

  1. Select Tools | Customize.
  2. Click the Commands tab.
  3. In the Categories column, select All Commands.
  4. Scroll down until you find Tools Calculate.
  5. Drag the command to the Tools menu and place it wherever you  like or, you could just drag it to your toolbar.

It may appear greyed out as Tools Calculate is only available when you have selected text. By default, the Calculate command will add any set of selected numbers separated by white space. Word tmporarily displays the result in the status bar and also places it on the clipboard.

Tags: , , , , , , , , , ,
Posted in Microsoft Office, Microsoft Office Word, Office Productivity, Word 2003 | No Comments »

« Older Entries
Newer Entries »