Blog Archives

Tom’s Tutorials For Excel: Copying Your Page Setup to Multiple Worksheets

Tom’s Tutorials For Excel: Copying Your Page Setup to Multiple Worksheets

Establishing your Page Setup preferences can involve a lot of steps. You won’t want to repeat those same steps over and over for each worksheet where you’ll want the same preferences.

To show the Page Setup dialog box…

Read more ›

Posted in Tom's Tutorials for Excel
Tags: , , , , , , , , , , , ,

Tom’s Tutorials For Excel: Entering an Ampersand in Your Header or Footer

Tom’s Tutorials For Excel: Entering an Ampersand in Your Header or Footer

If you’ve ever wondered why a custom header or footer does not show an ampersand (&) when you want to show it, there’s a small trick to making that happen. All it takes is two ampersands in succession,

Read more ›

Posted in Tom's Tutorials for Excel
Tags: , , , , , , , , , , , , ,

Tom’s Tutorials For Excel: Formatting Cell Contents as Invisible

Tom’s Tutorials For Excel: Formatting Cell Contents as Invisible

Here’s how you can make a cell’s contents be invisible, while keeping the cell’s rows and/or columns unhidden. In the following pair of pictures, employee salaries are in column F, but you want them hidden while column F remains visible.

Read more ›

Posted in Tom's Tutorials for Excel
Tags: , , , , , , , , , , , , ,

Tom’s Tutorials For Excel: Printing Some Sheets, Not Printing Others

Tom’s Tutorials For Excel: Printing Some Sheets, Not Printing Others

In some cases you want an easy way to print only certain sheets from your workbook.
There are two approaches — identifying which sheets to include, or which sheets to exclude.
Below are two macros,

Read more ›

Posted in Tom's Tutorials for Excel
Tags: , , , , , , , , , , , , ,

Tom’s Tutorials For Excel: Set Page Breaks For Specified Areas

Tom’s Tutorials For Excel: Set Page Breaks For Specified Areas

If your worksheet has areas of data that you want to print on separate pages, you can easily establish page breaks based on a wide choice of cell properties or text values. With the following macro for the pictured example,

Read more ›

Posted in Tom's Tutorials for Excel
Tags: , , , , , , , , , , , , ,

Tom’s Tutorials For Excel: Count Your Workbook’s Total Printable Pages

Tom’s Tutorials For Excel: Count Your Workbook’s Total Printable Pages

Ever want to know how many total pages would print from all your workbook’s worksheets?

This macro will tell you:

Sub GetPrintablePageCount()
Dim iSheet%, iCountStart%, iCountEnd%
iCountStart = 0: iCountEnd = 0
For iSheet = 1 To Worksheets.Count
If Sheets(iSheet).Visible = xlSheetVisible Then
Sheets(iSheet).Activate
iCountStart = iCountEnd + 1
iCountEnd = iCountEnd + ExecuteExcel4Macro(“INDEX(GET.DOCUMENT(50),1)”)
MsgBox “The sheet named ” & Sheets(iSheet).Name & vbCrLf & _
“has its printable pages starting at number ” & iCountStart & vbCrLf & _
“and ending at number ” & iCountEnd,

Read more ›

Posted in Tom's Tutorials for Excel
Tags: , , , , , , , , , , , ,

Tom’s Tutorials for Excel: Print a Word document from Excel

Tom’s Tips for Excel: Print a Word document from Excel

Here is the Tuesday blog length post from Tom Urtis. This one is so handy!

Sub PrintWordDoc()
‘Declare object variables.
Dim WdApp As Object, wddoc As Object
‘Open Word
Set WdApp = CreateObject(“Word.Application”)
‘Open the Word document to be printed.

Read more ›

Posted in Tom's Tutorials for Excel
Tags: , , , , , , , , , , , , ,