Print que unjam

Print que unjam

It is technically known as printicus stuckities.

From the start menu, select Run, enter CMD, click OK, and type

Stop spooler

to halt the service.

Leave the CMD window open, wait a few seconds, and check the print que again-

the print job should be gone.

Type

net start spooler

in the CMD box.

Finito.

How to determine the number of Pinted Pages in Excel 2007

Excel 2007 - Tips-Determining The Number Of Printed Pages

If you need to determine the number of printed pages for a worksheet printout, you can use Excel's print preview feature, and view the page count displayed at the bottom of the screen.

This tip provides two ways to determine the number of printed pages -- one using the the Excel 4 (XLM) Get.Document macro function, the other using VBA.

Using an XLM macro in VBA

You can execute an XLM macro function from VBA, as follows:

PgCnt = ExecuteExcel4Macro("Get.Document(50)")

In the statement above, the number of printed pages in the active sheet is assigned to the PgCnt variable.

The VBA subroutine below loops through all worksheets in the active workbook and displays the total number of printed pages. Note that this may return incorrect results when using a user-specified print range.

Sub ShowPageCount()

PageCount = 0

For Each sht In Worksheets

sht.Activate

Pages = ExecuteExcel4Macro("Get.Document(50)")

PageCount = PageCount + Pages

Next sht

MsgBox "Total Pages = " & PageCount

End Sub

Using VBA

Stew Scott provided the VBA procedure below, which does not use XLM.

Sub NumberOfPrintedPages()

Worksheets(1).DisplayAutomaticPageBreaks = True

HorizBreaks = Worksheets(1).HPageBreaks.Count

HPages = HorizBreaks + 1

VertBreaks = Worksheets(1).VPageBreaks.Count

VPages = VertBreaks + 1

NumPages = HPages * VPages

Worksheets(1).DisplayAutomaticPageBreaks = False

MsgBox NumPages

End Sub

Excel 2007 Upgrade - Formatting And Printing

Excel 2007 Upgrade - Formatting And Printing

Q: How do I get my old workbook to use the new fonts?

A: Press Ctrl+N to create a blank workbook. Activate your old workbook and choose the Home tab. Click the very bottom of the vertical scrollbar in Styles gallery, and choose Merge Styles. In the Merge Styles dialog box double-click the new workbook you created with Ctrl+N. But this only works with cells that have not been formatted. For example, bold cells retain their old font.

Q. How do I get a print preview?

A. Try using the Page Layout view (icon on the right side of the status bar). Or, add the Print Preview button to your QAT.

Q: When I switch to a new document template, my worksheet no longer fits on a single page.

A: That's probably because the new theme uses different fonts. After applying the theme, use the Page Layout / Themes / Fonts control to select your original fonts to use with the new theme. Or, modify the font size for the Normal style. If page fitting is critical, you should choose the theme before you do much work on the document.

Q: How do I get rid of the annoying dotted-line page break display in Normal view mode?

A: Open the Excel Options dialog box, click the Advanced tab, scroll down and look for the 'Display options for this worksheet' section, and remove the checkmark from 'Show Page Breaks'.

Q: Can I add that 'Show Page Breaks' option to my QAT?

A: No. For some reason, this very useful command isn't available as a QAT icon.

Q: I changed the text in a cell to use Angle Clockwise orientation (in the Home / Alignment group). I can't find a way to get the orientation back to normal. There's no Horizontal Alignment option.

A: To change the cell back to normal, click the option that corresponds to the current orientation (that option is highlighted). Or, choose the Format Cell Alignment option and make the change in the Format Cells dialog box.

Q. I'm trying to apply a table style to a table, but it has no effect.

That's probably because the table cells were formatted manually. Remove the old cell background colors, and applying a style should work.

Q: I thought Office 2007 was supposed to support PDF output. I can't find the command.

A: You need to download a free add-in from Microsoft. Blame the Adobe attorneys. After you download and install the add-in, click the Office Menu button and then select Save As / PDF or XPS.