![]() |
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
|
|||
|
|||
|
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) |
| Ads |
|
#2
|
|||
|
|||
|
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) |
|
#3
|
|||
|
|||
|
> 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) > |
|
#4
|
|||
|
|||
|
Data>Filter>Autofilter...................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) >> |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How do I print only a selected area in Excel 2007 | cbanditos | Excel Discussion (Misc queries) | 1 | January 14th 09 01:02 AM |
| Setting up Excel to print only selected cells | JRoberts1 | Excel Discussion (Misc queries) | 1 | October 5th 08 08:39 PM |
| How to print selected columns that are not adjacent in Excel | Patlee | Excel Worksheet Functions | 0 | May 26th 07 02:00 AM |
| setting print area to selected cells | [email protected] | Excel Discussion (Misc queries) | 4 | November 30th 06 09:29 PM |
| can I print selected cells only within a worksheet | martin hanley | New Users to Excel | 1 | January 4th 05 08:07 PM |