Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Caroline Lackey
 
Posts: n/a
Default Printing after using column auto fit - not working

There seems to be a funky disconnect between my printer and excel. I've used
column auto fit to make sure all columns are large enough so that I don't get
the ####. It looks great on the screen, but when I do a print preview (and
actual print), I still get the ####. Therefore, I then have to go to each
column manually to adjust the width and keep checking the print preview to
make sure all the ### are gone.

Any ideas???
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

Change the font to something slightly smaller or increase the columnwidth (like
you're doing).

WYSIWYG ain't necessarily true!

Caroline Lackey wrote:

There seems to be a funky disconnect between my printer and excel. I've used
column auto fit to make sure all columns are large enough so that I don't get
the ####. It looks great on the screen, but when I do a print preview (and
actual print), I still get the ####. Therefore, I then have to go to each
column manually to adjust the width and keep checking the print preview to
make sure all the ### are gone.

Any ideas???


--

Dave Peterson
  #3   Report Post  
Caroline Lackey
 
Posts: n/a
Default

Thanks Dave. I thought this might be the case.

"Dave Peterson" wrote:

Change the font to something slightly smaller or increase the columnwidth (like
you're doing).

WYSIWYG ain't necessarily true!

Caroline Lackey wrote:

There seems to be a funky disconnect between my printer and excel. I've used
column auto fit to make sure all columns are large enough so that I don't get
the ####. It looks great on the screen, but when I do a print preview (and
actual print), I still get the ####. Therefore, I then have to go to each
column manually to adjust the width and keep checking the print preview to
make sure all the ### are gone.

Any ideas???


--

Dave Peterson

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Column Auto Width and Hidden Rows KWCounter Excel Discussion (Misc queries) 1 May 20th 05 12:59 AM
how to set up a column in excel so it can auto number Excel questions Excel Discussion (Misc queries) 2 March 10th 05 08:35 AM
troubleshoot custom Excel Auto Filters when the column is a # or d MEM Excel Worksheet Functions 1 March 8th 05 09:10 PM
Printing the last column on every page printed. naiveprogrammer Excel Discussion (Misc queries) 1 February 4th 05 11:16 PM
How can I sort an entire spreadsheet from a list prod sorter Excel Worksheet Functions 4 November 17th 04 03:43 AM


All times are GMT +1. The time now is 04:11 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"