box Office tab 120 90

Office Tab

It enables tabbed browsing, editing and managing in Microsoft Office 2003, 2007, 2010, 2013 and 2016. User can open multiple documents in single tabbed window, just like using tabs in IE 8/9, Firefox and Google Chrome.

Read More Download Buy now

  Box2010 Office ProPlus 120 90

Classic Menu for Office

Bringing back classic view and old look of Office 2003 to Microsoft Office 2007 / 2010 / 2013 or Office 365. It shows the old menus and toolbars on the new ribbon interface. Users don't need any training after upgrading to Office 2007, 2010 and 2013.

Read More Download Buy Now

Kutools-for-Excel-120x90

Kutools for Excel

KuTools for Excel is a handy Microsoft Excel add-ins collection to free from time-consuming operations. It includes 120+ powerful features and functions for Excel 2016, 2013, 2010, 2007 or Office 365 (Excel).

Read More Download Buy now


KTW-120x90

Kutools for Word

Kutools for Word is a powerful Word add-in that frees you from time-consuming operations which majority of Word users have to perform daily! It includes 100+ powerful features and functions for Word 2013, 2010, 2007-2003 or Office 365 (Word).

Read More Download Buy now


Kutools 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 2013, 2010 or Office 365!

Read More Download Buy now

Word_Tab_32Tabs for Word - Brings Tabbed Document Interface in Microsoft Word 2003/2007/2010/2013/2016 (32/64bit).

Read MoreDownloadBuy now

Exce_Tab_32Tabs for Excel - Brings Tabbed Document Interface in Microsoft Excel 2003/2007/2010/2013/2016 (32/64bit).

Read MoreDownloadBuy now

Ppt_Tab_32Tabs for PowerPoint - Brings Tabbed Document Interface in Microsoft PowerPoint 2003/2007/2010/2013/2016 (32/64bit).

Read MoreDownloadBuy now

Project_Tab_32Tabs for Project - Brings Tabbed Document Interface in Microsoft Project 2003/2007/2010/2013/2016 (32/64bit).

Read MoreDownloadBuy now

Visio_Tab_32Tabs for Visio - Brings Tabbed Document Interface in Microsoft Visio 2003/2007/2010/2013/2016 (32/64bit).

Read MoreDownloadBuy now

Access32X32Tabs for Access - Brings Tabbed Document Interface in Microsoft Access 2007/2010/2013/2016 (32/64bit).

Read MoreDownloadBuy now

Pubblisher32x32Tabs for Publisher - Brings Tabbed Document Interface in Microsoft Publisher 2003/2007/2010/2013/2016 (32/64bit).

Read MoreDownloadBuy now

for empty category blog or list

Print

How to print worksheet without blank rows in Excel?

. Posted in 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