Kingwood Underground
the heart and soul of our Kingwood, Texas family
Login - Create Account - Help
Clean out your garage on Kingwood bookoo! Or find local garage sales on Yard Sale Search.com
KU Live!

Excel help

who's talking here?

GCan 1
FishinKim 2
lolagirl 1
PS 1
~thekat~ 1

     » send to friend     » save in my favorites     » flag dangerous topic flag as a dangerous topic

FishinKim --- 15 years ago -

How do I print only the cells that have info in them? When I try to print, it prints all 500 cells that are there for info to be entered in. I am a total Excel idiot! TIA! 

~thekat~ --- 15 years ago -

highlight the area of the spread sheet you want to print then go to page layout, print area, and then set print area. 

PS --- 15 years ago -

Select the column(s) you want to print, then use the print area function (varies with Excel version)to select the print area. You may eventually want to clear the print area. 

GCan --- 15 years ago -

Highlight those cells you want to print. Go to "File" in the menu bar and scroll down to "Set Print Area". Then print the document. 

FishinKim --- 15 years ago -

Thanks! I'll give it a try! 

lolagirl --- 15 years ago -

You may need to set a filter first.
Click on Data/Filter, click on auto filter. Go to that column and click on the drop down filter tab and set the filter for those cells that are not blank. Then set your print area and print. 

page 1
Login to add your comments!

see more discussions about...


Online now:
hit counters

Terms of Service - Privacy Policy - Ice Box

Kingwood Underground