Printing right to the edge of the page without borders???
I have an image that I need to print to the exact page size (A5). I have
changed the image dimensions to match the page dimensions but when I print it
keeps cutting part of the iamge off?? Does anyone know how I can fix this??
> I have an image that I need to print to the exact page size (A5). I
> have changed the image dimensions to match the page dimensions but
> when I print it keeps cutting part of the iamge off?? Does anyone
> know how I can fix this??
Maybe your printer doesn't print
full bleed (edge to edge)?
"How to find ...Delete blank rows Macro
Using MS Excel 2000.
Help creating a macro please.
I need to search the range A1:A10000 and if the cell is blank I want to
delete the entire row.
Thanks in advance.
"Richard" <Richard@discussions.microsoft.com> wrote in message
> Using MS Excel 2000.
> Help creating a macro please.
> I need to search the range A1:A10000 and if the cell is blank I want to
> delete the entire row.
> Thanks in advance.
Dim lrow as Long...Extracting Text from a Cell
I have a column in excell that has 1-4 names in each cell.
I would like to extract the names into 4 seperate cells
(column). The names are seperated by a comma and a soft
I'd appreciate any help.
Look at Data>Text To Columns
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
"Tony" <firstname.lastname@example.org> wrote in message
> I have a column in excell that has 1-4 names in each cell.
> I would like to extra...Report = Blank?
I have a report that I got from this forum, and when I
use it, everything is fine. The problem I am currently
having though is if say I try and generate the report
using RegisterID & Date then I get a blank report...if I
try one or the other, then I am fine...I pretty much
tried every angle with RegisterID and with Date, and
nothing...any advise would be great, as I have seen this
happen with other reports as well, where the final
outcome is a blank report.
"When I run into problems, we more often than not fix them ourselves.
Can't put a price on ...how to get the address of the ceected cell
How can I get the address of a cell whenever I click on it
Look at the top left of your screen, to the left of the formula bar.
It's called the name box.
Here's how in code............
Vaya con Dios,
"yosi_lb" <email@example.com> wrote in message
> Hi Everybody
> How can I get the address of a cell whenever I click on it
'This is worksheet event code, which m...Merging Cells with Information
I have a list of foods in column B and their
corresponding measured amount in column A. I would like
to have this information available in one cell so I can
use a dropdown list. Is there a way to do so?
12 fl. Oz BEER
4 fl. oz. White Wine
I would like the above to read:
Beer 12 fl. Oz.
White Wine 4 fl. oz
In C1 enter this formula:
Copy down as needed. Then you can delete columns A and B.
>I have a list of foods in column B and their
>...Deleting Blank Characters in a Cell
I have a list of names with email addresses of attendees of a seminar
series that I am trying to compile into a list that can be copied and
pasted into an email (using BCC as the methodology for emailing).
The challenge that I have is that when these files were exported from
the database to excel (not sure how), all of the cells contain exactly
100 characters even though the email address may only contain 13-20
characters. Is there a way to "trim" the blank characters after the
last character that is used by a letter instead of blank character
Thanks in advance!
--...Blank .msg attachments
Here's an odd one,
When an email has been forwarded to, or replyed to and is using the 'attach
as attachment' option (as opposed to embed text), the message is delivered
with attachment, but the attachment appears blank. It is only .msg
attachments that have this problem, everything else gets thru fine (.doc,
..xls, .exe etc.) The attachment is 64bytes long, and has nothing in it.
Exchange 2003, Windows 2003 and Outlook 2003 being used.
Any ideas anyone?
The man with no shoes.
MCSE (W2K3, W2K), MCSA (W2K3, W2K), MCSE+I (NT4), CCNA + others....
All replies to group pleas...Blank Cells #4
I am trying to do the following:
1 - In Cell A4 display the SUM of A1 + A2 + A3 if at least one of these cells is not empty.
2 - In Cell A6 display A5-A4 if both cells are not empty.
How can I do this?
Portland, Oregon USA
(free and commercial excel programs)
wrote in message
> I am trying to do ...conditional formatting:highlight row based on blank or non-blank c
Does anyone know if, and how, is possible to use Conditional Formatting
feature to automatically highlight the whole row if a specific cell in that
row is non-blank (or blank)?
Yes, first select your row then in your conditional formatting select
"formula is" from the drop down menu and type:
depending on weather you want the condition to apply when your cell is
blank or non blank.
pinmaster's Profile: http://www.excelforum....Counting cells depending upon a cell value.
I've a table with the cell range a1:AE28.
For the odd no. rows of the table, starting with the first row the
possible values are "DG", "YL", "DR" and "DB".
For the even no. rows of the table, starting with the second row the
possible values are "G", "R" and "B".
I need a formulae to calculate the count of cells having a value as
"DG", for all the cells having values as "G".
Thanks for your help....
p.s. here is a sample of the table, to give an idea
First row--- DB DG DG DG DG YL D...Counting With Blank Rows
If I have a column of numbers like this:
How do I count the number of items between the blanks so it will look like I
have it in the example. The number to the right and bottom is the count. So,
for the numbers 4,5 6 the count is three. For 7,8 9 the count is three and for
the numbers 2,7,4,1 the count is four.
Is there a way to do this withoug using a macro?
You need to use the "count" function. If the rows in your example are 1-12
and the column is A, for the first group you'd type in (in column B)
"=count(a1:a...disable/lock a cell based on the contents of another cell
using a formula is it possible to disable/lock another cell?
In my worksheet cell A1 can only contain "H" or "E"
If A1 = H, I do not want anybody to be able to populate B1.
1. You could set up Data, Validation on B1 such that =A1<>"H" would be your
2. The second alternative is to add a Worksheet_Change macro that would
store the value of B1 and if that cell were changed when A1 = H the macro
would return the original value to B1, replacing the users entry.
Of course neither of these are fool proof since the user could change A1 to...Charting blanks as spaces
I know you can chart blank cells as spaces by clicking it in the
options...this is a little different.
The cell it is charting as an if function in it to display a blank cell.
So when D3 is blank it should display in cell D6 a blank. But when it charts
it, it charts it as a zero. I want it to chart it as a gap.
I tried =if(D3="",NA(),D5-D3), This way i get a "#N/A" error in my cell,
which i can hide through conditional formating. but when i click display>data
labels>values in chart options it displays "#...Stationery on every email killing disk space
I am writing this email for an Exchange admin who is constantly running out
of disk space
on her Exchange server. This is Exchange 2000 with outlook 2000 clients.
Someone told the admin that since all of the clients send HTML emails on
company stationery, the
stationery is taking 80% of her disk space. Apparently no one removes
messages from their SENT
1. Does anyone know of a utility that can remove/strip stationery from all
folders except the OUTBOX?
2. Does anyone know how to compact or zip all the files in the Exchange
3. Does anyone know if there is a way to trash SEN...Blank, yet not blank
I copied some info from a database and pasted it to Excel where I wanted to
manipulate the data. I notice that some of the cells, though appearing to
be blank (and not showing 0 either), still responded to a simple formula
like IF(OR(A1="",A1=0),1,0) giving the answer as 1.
Can anyone tell me what's happening here, as it does mean I need to
unneccessarily extend the formulas to exclude these cells.
> I copied some info from a database and pasted it to Excel where I wanted to
> manipulate the data. I notice that so...Lookup cell for documents in a folder
I am trying to create an overview of the time spent on projects. People hand
in weekly time-charts in excel format where the projects are referenced by a
standard number. So in effect I have a lot of separate excel files from which
I would like to create a summary, which also updates when a new file is added
to the folder.
I have no idea if this is possible and if it is, how one should accomplish
it. Can anyone help?
There's a lot of information that would be needed for a complete solution,
but I'll outline generally what would be needed.
This would have to be done wi...Text not consistantly appearing in adjacent cells
I have a multi page spread sheet where there are a few
My pages have a header that spans several columns once it
pulls in an organization's name. On most of the pages the
header appears fine even though it displays over several
columns. On a few of the pages the header only appears
partially -- displaying only the characters that will fit
in the column width of the cell containing the header.
As all of the adjacent column cells the header appears
next to are blank, I just merged all the cells to
eliminate this problem, however on two of my sheets I made
v...Removing spaces from imported data
I copied and pasted some "numerical" data from a table
into an excel worksheet. I needed to sum up several
columns worth of data but each time it enters the sum as
So, after experimenting I found that there is a space
after each number. I tried using the TRIM and LEFT/RIGHT
functions and neither worked as far as allowing me to sum
up the columns.
When I retype the number, it obviously works. I tried
formatting the cells to numbers before and after trying
the TRIM function but to no avail.
Is there a way to get this data into a useable format and
if so, h...BLANK FORM / QUERY
My database is pretty basic with tables, forms, queries etc. I'd like to
display a form that allows me to type in a figure in the first field and the
rest of the fields will populate automatically. I'm not sure how to create a
query where the field awaits input. Thanks in advance.
In the query's criteria box, use square brackets:
[Enter a value]
or from a form:
in the first case, you will be prompted. In the second, you will only be
prompted if the form isn't open.
Arvin Meyer, MCP, MVP
http:/...Lock cells but allow data entry ONLY!
Can I protect my Excel spreadsheet to allow data entry and nothing else (i.e. formatting, changing column widths, changing formulas, etc.
* Highlight all the cell(s) you want to be able to enter data into.
* Right-click and choose *Format Cells.*
* On the *Protection* tab take the tick out of the *Locked* box.
* Highlight all the cells which contain the formulas you want to remai
* Right-click and choose *Format Cells.*
* On the *Protection* tab make sure there is a tick in the *Locked
* Go to * Tools > Protection > Protect Sheet*
* Tick *Select ...Blank Records in Catalog Merge
I am printing a directory with the following information:
The records that do not have an entry under "Child's Name" are coming out
(...with a blank space where the "Child's Name" field would be.)
Even worse (and more confusing when reading the final document) is when the
record has neither a "Child's Name" entry nor a "Phone Number" entry, and you
Basically, I want it to ignore the line if there is no data in the field.
Accord...How do I get rid of extra white space when row autofit is on?
When row autofit is on, I get a lot of extra white space above or below text
in the cell with the most text. How do I get rid of it without manually
adjusting every row?
I don't get it for all the cells, but this might work for you...
make the columnwidth just a bit wider--then autofit the rowheights.
(It might just make the problem occur on different cells, though.)
> When row autofit is on, I get a lot of extra white space above or below text
> in the cell with the most text. How do I get rid of it without manually
> adjusting every row?
Dave Pe...Blank Document no longer blank
Every time Word opens, words and a picture (that were used at one time)
appear as the blank document. I cannot find any place/button/option that will
remove the words or picture from the default new document
See http://word.mvps.org/faqs/apperrors/blankdocnotblank.htm for tips on how
to remove content from the Normal.dot(x)
Hope this helps
> Every time Word opens, words and a picture (that were used at one time)
> appear as the blank document. I cannot find any place/button/option that will
> remove the words or p...Page shows up in print preview, but prints blank...
I'm trying to print a booklet with graphics on both the front and back
covers. The back cover graphics and text appear fine in print preview, but
when I send it to the printer, it prints blank. The front cover is fine.
Help! Thanks in advance to anyone who can help me.
How to troubleshoot problems that you may experience when you try to print to a
local printer by using Office programs in Windows XP
Have you checked the manufacturer's web page for your model printer? There maybe
an updated driver.
Mary Sauer MSFT MVP