tips for printing and viewing electronic copy

davers5 · Feb 28th, 2002, 10:37 AM

I want to print my excel worksheet with the least amount of space between the cells (but still be able to see seperation) and then also be able to see, in the electronic copy, the actual number (NOT the pound sign because the numbers won't fit in the cell). Is this possible? Is there some relationship between the GUI and what is printed? Is there a font that is better for printing and viewing?

Thanks,

Dave

Corni · Mar 23rd, 2002, 08:37 AM

Select all cells and apply autofit for columns:

Cells.Select
Seleaction.Columns.Autofit

Yogi Anand · Mar 23rd, 2002, 08:48 AM

Hi davers5:
In addition to what Corni suggested, you may also want to try print settings as follows:
1) adjust your column widths and font sizes so you can actually see the numbers and not the # signs
2) Then FILE|PAGE_SETUP|PAGE|choose the option FIT_TO say 1 page wide by 1 page tall or to suit your needs

HTH
Please post back if it works for you ... otherwise explain a little further and let us take it from there!

Mar 23rd, 2002, 08:48 AM	#3
Yogi Anand MrExcel MVP Join Date: Mar 2002 Location: Michigan USA Posts: 11,452	Hi davers5: In addition to what Corni suggested, you may also want to try print settings as follows: 1) adjust your column widths and font sizes so you can actually see the numbers and not the # signs 2) Then FILE\|PAGE_SETUP\|PAGE\|choose the option FIT_TO say 1 page wide by 1 page tall or to suit your needs HTH Please post back if it works for you ... otherwise explain a little further and let us take it from there! __________________ Regards! Yogi Anand, D.Eng, P.E. Energy Efficient Building Network LLC www.energyefficientbuild.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 28th, 2002, 10:37 AM	#1
davers5 Board Regular Join Date: Feb 2002 Posts: 255	I want to print my excel worksheet with the least amount of space between the cells (but still be able to see seperation) and then also be able to see, in the electronic copy, the actual number (NOT the pound sign because the numbers won't fit in the cell). Is this possible? Is there some relationship between the GUI and what is printed? Is there a font that is better for printing and viewing? Thanks, Dave

Mar 23rd, 2002, 08:37 AM	#2
Corni Board Regular Join Date: Mar 2002 Location: Brampton Posts: 324	Select all cells and apply autofit for columns: Cells.Select Seleaction.Columns.Autofit