ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   print selected cells in Excel (https://www.excelbanter.com/excel-discussion-misc-queries/228364-print-selected-cells-excel.html)

DEE

print selected cells in Excel
 
How do I print selected cells only from my Excel Worksheet (Excel 2003)?

How do I print only active text lines and none of the add'l blank lines on
the Excel Worksheet? I don't want to just print selected pages, but ONLY
lines with text. (Excel 2003)

Gord Dibben

print selected cells in Excel
 
Use autofilter to hide blank rows.

Print the resulting view.


Gord Dibben MS Excel MVP

On Tue, 21 Apr 2009 11:46:08 -0700, Dee
wrote:

How do I print selected cells only from my Excel Worksheet (Excel 2003)?

How do I print only active text lines and none of the add'l blank lines on
the Excel Worksheet? I don't want to just print selected pages, but ONLY
lines with text. (Excel 2003)



DEE

print selected cells in Excel
 
How do I access/use AutoFilter? And how do I print JUST selected cells?

"Gord Dibben" wrote:

Use autofilter to hide blank rows.

Print the resulting view.


Gord Dibben MS Excel MVP

On Tue, 21 Apr 2009 11:46:08 -0700, Dee
wrote:

How do I print selected cells only from my Excel Worksheet (Excel 2003)?

How do I print only active text lines and none of the add'l blank lines on
the Excel Worksheet? I don't want to just print selected pages, but ONLY
lines with text. (Excel 2003)




Gord Dibben

print selected cells in Excel
 
DataFilterAutofilter...................this info can be found in Help

Filter for non-blank cells.

I am assuming that "lines" means rows.


Gord

On Wed, 22 Apr 2009 05:39:02 -0700, Dee
wrote:

How do I access/use AutoFilter? And how do I print JUST selected cells?


"Gord Dibben" wrote:

Use autofilter to hide blank rows.

Print the resulting view.


Gord Dibben MS Excel MVP

On Tue, 21 Apr 2009 11:46:08 -0700, Dee
wrote:

How do I print selected cells only from my Excel Worksheet (Excel 2003)?

How do I print only active text lines and none of the add'l blank lines on
the Excel Worksheet? I don't want to just print selected pages, but ONLY
lines with text. (Excel 2003)





All times are GMT +1. The time now is 05:48 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com