(Msg. 1) Posted: Wed Jul 23, 2008 8:08 am
Post subject: Prints Extra Rows & Columns Add to elertz Archived from groups: microsoft>public>excel>printing (more info?)
Excel frequently includes additional blank rows and/or columns in print or
print preview. Deleting these does not solve the problem. However, if I
close the file and re-open, the blank rows and columns are excluded, as they
should be. Any clues? Thanks.
Ted
(Msg. 2) Posted: Wed Jul 23, 2008 1:41 pm
Post subject: Re: Prints Extra Rows & Columns Add to elertz [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
The blank rows and columns most likely once had data that was celeared or
deleted.
If cleared but not deleted, Excel still counts those as part of the Used
Range.
You must select and delete then save the file to reset the used range.
Gord Dibben MS Excel MVP
On Wed, 23 Jul 2008 08:08:54 -0400, "koala824 at Comcast"
<koala824.DeleteThis@comcast.net> wrote:
>Excel frequently includes additional blank rows and/or columns in print or
>print preview. Deleting these does not solve the problem. However, if I
>close the file and re-open, the blank rows and columns are excluded, as they
>should be. Any clues? Thanks.
>Ted
>
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Search
Profile
Private Messages
Log in/Register/Password
Office