Office Tab v 11.00

Adding Tabbed Interface for Office

It enables tabbed browsing, editing, and managing of Microsoft Office applications. You can open multiple documents / files in a single tabbed window, such as using the browser IE 8/9/10, Firefox, and Google Chrome, and also save and close all Office documents with just one click. It's compatible with Office 2016, 2013, 2010, 2007, 2003 or Office 365! Demo

Read More Download Buy now

Classic Menu for Office

Bringing Back Your Familiar Menus in Office

Restores the old look of Office 2003 to Microsoft Office 2016, 2013, 2010, 2007 or Office 365. Don’t lose time in learning or finding commands on the Office Ribbon. We're not just bringing back the Classic menu but also making it easier to use. Supports all languages of Office. It is very easy to deploy in company. We also provide Classic Menu for Office 2007.

Read MoreDownloadBuy Now

Kutools for Excel v 12.00

120+ Powerful Features for Excel

Kutools for Excel is a powerful add-in that frees you from performing time-consuming operations in Microsoft Excel application. The add-in has 120 + powerful features and functions for Excel/Office 2016, 2013, 2010, 2007 or Office 365!

Read More Download Buy now

Kutools for Word v 8.00

100+ Powerful Features for Word

Kutools for Word is a powerful add-in that frees you from time-consuming operations which majority of Word users have to perform daily! It can save your time from using Microsoft Word / Office 2016, 2013, 2010, 2007, 2003 or Office 365!

Read MoreDownloadBuy now

Kutools for Outlook v 5.00

20+ Powerful Features for Outlook

Kutools for Outlook is a powerful add-in that frees you from time-consuming operations which majority of Outlook users has to perform daily! It can save your time from using Microsoft Outlook/Office 2016, 2013, 2010 or Office 365!

Read More Download Buy now

for empty category blog or list

How to print worksheet without blank rows in Excel?

When printing worksheet, the blank rows will be printed out as well. For some Excel users, they tend to print worksheet without blank rows in order to compact the data and save papers. But how to print worksheet without blank rows in Excel. This article provides two methods for you.

Hide blank rows before printing with VBA code

Delete blank rows before printing with Kutools for Excel

Recommended Productivity Software

Office Tab: Use tabbed interface in Office as the use of web browser Chrome, Firefox and Internet Explorer.
Kutools for Excel: Adds 120 powerful new features to Excel. Increase your productivity in 5 minutes. Save two hours every day!
Classic Menu for Office: Brings back your familiar menus to Office 2007, 2010 and 2013 (includes Office 365).

arrow blue right bubbleHide blank rows before printing with VBA code

Hint


Before printing the worksheet, you can run the below VBA code to hide blank rows in a specified range. Please do as follows.

1. Press the Alt + F11 keys to open the Microsoft Visual Basic for Application window.

2. In the Microsoft Visual Basic for Application window, click Insert > Module. And then copy and paste below VBA code into the Module window.

VBA code: Hide blank rows in selected range

Sub HideBlankRows()
	Dim xRg As Range
	Dim xCell As Range
	Dim xAddress As String
	Dim xUpdate As Boolean
	Dim I As Long
	On Error Resume Next
	xAddress = Application.ActiveWindow.RangeSelection.Address
	Set xRg  = Application.InputBox("Please select a range", "Kutools for Excel", xAddress, , , , , 8)
	Set xRg  = Application.Intersect(xRg, ActiveSheet.UsedRange)
	If xRg Is Nothing Then Exit Sub
		If xRg.Areas.Count > 1 Then
			MsgBox "Don't support multiple ranges", , "Kutools for Excel"
			Exit Sub
			End If
			xUpdate = Application.ScreenUpdating
			Application.ScreenUpdating = False
			For I = 1 To xRg.Rows.Count
				xRg.Rows(I).EntireRow.Hidden = (Application.CountA(xRg.Rows(I)) = 0)
			Next
			Application.ScreenUpdating = xUpdate
		End Sub

3. Press the F5 key to run the code, then a Kutools for Excel dialog box pops up, please select the range with blank rows you don’t want to print, and then click the OK button.

Then all blank rows in selected range are hidden immediately. Then you can start printing the worksheet without blank rows.

Note: After printing, you can unhide these blank rows with the following VBA code.

VBA code: Unhide all blank rows in selected range

Sub UnhideRows()
	Dim xRg As Range
	Dim xCell As Range
	Dim xAddress As String
	Dim xUpdate As Boolean
	On Error Resume Next
	xAddress = Application.ActiveWindow.RangeSelection.Address
	Set xRg = Application.InputBox("Please select a range to unhide the blank rows", "Kutools for Excel", xAddress, , , , , 8)
	Set xRg = Application.Intersect(xRg, ActiveSheet.UsedRange)
	If xRg Is Nothing Then Exit Sub
		xUpdate = Application.ScreenUpdating
		Application.ScreenUpdating = False
		xRg.EntireRow.Hidden = False
		Application.ScreenUpdating = xUpdate
	End Sub

arrow blue right bubbleDelete blank rows before printing with Kutools for Excel

If you want to print worksheet without blank rows, we recommend you to delete all blank rows with the Delete Blank Rows utility of Kutools for Excel, and then you can print the worksheet manually.

Kutools for Excel: with more than 120 handy Excel add-ins, free to try with no limitation in 60 days.

1. Click Kutools > Delete > Delete Blank Rows > In Selected Range/In Active Sheet/In Selected Sheets/In All Sheets based on your needs. See screenshot:

Note: For deleting blank rows in a range, please select this range firstly and then apply the function.

2. Then a dialog box pops up to tell you how many rows have been deleted, please click the OK button.

Now all blank rows are deleted. You can start printing your worksheet.

Note: This utility support Undo Ctrl + Z.

If this utility is helpful, you can download and try the free trial now!

Is your problem solved?

Recommended Productivity Tools

The following tools will greatly save your time and effort, which one do you prefer?
Office Tab: Using handy tabs in your Office, as the way of Chrome, Firefox and New Internet Explorer.
Kutools for Excel: 120 powerful new functions for Excel, Increase your productivity in 5 minutes. Save two hours every day!
Classic Menu for Office: Bring back familiar menus to Office 2007, 2010, 2013 and 365, as if it were Office 2000 and 2003.

Kutools for Excel

gold star1 Amazing! Increase your productivity in 5 minutes. Don't need any special skills, save two hours every day!

gold star1 More than 120 powerful advanced functions which designed for Excel:

  • Merge Cell/Rows/Columns without Losing Data.
  • Combine and Consolidate Multiple Sheets and Workbooks.
  • Compare Ranges, Copy Multiple Ranges, Convert Text to Date, Unit and Currency Conversion.
  • Count by Colors, Paging Subtotals, Advanced Sort and Super Filter,
  • More Select/Insert/Delete/Text/Format/Link/Comment/Workbooks/Worksheets Tools...

Screen shot of Kutools for Excel

btn read more     btn download     btn purchase

Feature Tutorials for Kutools for Excel / Word / Outlook