How can I number these pages?
I have a workbook with 30 sheets. Some sheet contains more pages t
print. I have already made the setting print and the setting scale i
not the same for all sheets. I would like to
number (progressive number) and print all pages.
Ex WS1 Page1, WS1 Page2, WS2 Page3...
Someone can hepl me
Message posted from http://www.ExcelForum.com
In File - Page Setup, the First Page Number should be set to Auto for all
sheets. The pages wil now be sequential across all the sheets if all are
printed in one command.
mvpearl omitthisword at verizon period net
----------------...I want to print multi pages on one page.
I've tried going into set up and under page layout telling it to print 2
pages per sheet, but that doesn't work. Is there another way?
If, by "multi-pages" you really mean multiple worksheets on one page
that is not possible. You could add a 'summary' worksheet to combin
your data and print that with the "fit to page" option checked on th
Page Setup screen. Be careful with the 'fit to screen' as it can mak
the printout unreadably small.
swatsp0p...Today Conditional Format
I have a column which calculated a date based on 3 working days from a date
input into a diff column. What I want to do I have the calculated date
appear bold if that date has passed based on the current date.
For example if I input 01/08/11 the next column calculates 04/08/11 (3
working days). I want the caluclated date to appear bold when I open the
spreadsheet on the 05/08/11 ro show the calculated date has passed.
I can use conditional formatting but can't get the syntax right
Win XP Pro
Andy Roberts presented the following explanation :
> I ha...Two Condition Vlookup?
I am currently trying to create a function that searches through an
array for two exact column values which allows me to retrieve a third
column value. For example:
Type of Fruit Date Packaged Amount of Fruit
Apples June 100
Oranges June 50
Apples July 75
Grapes July 50
In this example, I would be looking to retrieve the Amount of Fruit
(Apples) that was packaged in July. I would be putt...How do I keep from printing blank pages in excel?
I'm trying to print only rows containing nonzero values in a specific column.
I can filter the data to show only rows with nonzero values but I am then
forced to reset my print area or I get blank pages. Is there an easier way?
You could press Ctrl-* to select just the current region, then use Print
Selection, rather than simply Print.
You can probably even record a macro incorporating those steps to speed it up.
> I'm trying to print only rows containing nonzero values in a specific column.
> I can filter the data to show only r...Hyperlink behavior Word 2007: correct page but wrong part of page
I've searched a lot of place but have not even seen anyone else having this
Document is a multi-page Word 2007 form template with hyperlinks for
In most cases clicking a hyperlink will take you to the correct page, and
the top of the page displays. However on some pages, it either displays the
bottom of the page and/or the top of the next page. Sometimes the cursor is
in the first form field of the following page.
With the template open, view field codes, show bookmarks and show text
boundaries, I still can't see what might be causing this behavi...Conditional formatting if condition of an if statement is true and a string value is displayed
I got a nested 'IF'-Formula in an excel cell that returns nothing if
the condition is false.
I would like to conditionally format this cell with grey shading if
the condition is true and a string value is displayed.
How can this be achieved using excel conditional formating
Help is much appreciated. Thank you very much in advance.
Let's say your doing this conditional formatting in cell K17. In
conditional formatting (xl2003) choose the FormulaIs: option and enter:
choose your formatt...Query condition by date range
I'm trying to create a query to base a report from. I need it to return
records within a date range that needs to be specified, as in specifying the
beginning date and having the current date as the end date. A field is
included in the query that has listed dates in the format mm/dd/yyyy. How
would I write the criteria? I have part of it ready - [Please enter starting
date:] . I know that's how you get the little question window.
On Tue, 4 Dec 2007 14:51:00 -0800, silva wrote:
> I'm trying to create a query to base a report from. I need it to return
> records within a...excel -10 sections
I have a 10 section worksheet that I need to have a footer that says Section
# page # on each page for printing the whole worksheet.
eg Section 1 Page 10 would the page 10 of the whole worksheet:
Section 3 Page 59 would be page 59 of the whole worksheet
I've used a macro to do this in WORD, but haven't ever tried it in EXCEL.
I'm guessing it would need a macro though.
> I have a 10 section worksheet that I need to have a footer that says Section
> # page # on each page for printing the whole worksheet.
> eg Section 1 Page 10 would the pag...Need help with conditional formula (Excel 97)
Can anyone give me the correct syntax for the following formula:
if A1 is blank, and B1 is more than zero, then display B1, otherwise
display nothing (blank cell)
met vriendelijke groetjes
"Jake D" <JakeD@djhtend.com> schreef in bericht
> Can anyone give me the correct syntax for the following formula:
> if A1 is blank, and B1 is more than zero, then display B1, otherwise
> display nothing (blank cell)
> Thank you
> ...Conditional Field in Queries
Is there a way to make a field in a query conditional so that it only
displays the value if the value is equal to something specifically
> Is there a way to make a field in a query conditional so that it only
> displays the value if the value is equal to something specifically
> set? Thanks.
Explain "the value is equal to something specifically set".
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
...How do i use Conditional formatting for 3+ conditions ?
I have a text box in a report which highlights in colour current members in
a list of past and present member names. I have six types of current members
that I want to highlight, but with conditional formatting I can only use 3
conditions in the members [Type] field. I have tried [Type]="Full member" Or
"Life member" but the "Or" doesn't work ! Is there a way to do this ?
thanks .. Roger
CF is limited to 3 contitions, but you can use OR in those expressions.
If you set Condition1 to Expression, you can use:
([Type] = "Full member") Or (...Conditional null value
Wondering if anyone can suggest a way to simplify the following code, which
I’m using in the OnFormat event of a report.
If Not IsNull(DLookup("[ICD2]", "EntryICDs", "[EntryNum] = " & Me!
Me![Field192] = Replace(DLookup("[ICD2]", "EntryICDs", "[EntryNum] =
" & Me![PtAcct#]), ".", " ")
If Not IsNull(DLookup("[ICD3]", "EntryICDs", "[EntryNum] = " & Me!
Me![Field194] = Replace(DLookup("[ICD...footers and page numbers
Can you change the place at which a footer occurs on the page. I want mine to
occur lower down. (pub 2007)
> Can you change the place at which a footer occurs on the page. I want mine to
> occur lower down. (pub 2007)
The "Footer" (just like the "Header") is merely a construct that
Publisher creates to make Word users feel more comfortable. It is in
fact a text box on your master page, movable and resizable just like any
Ed Bennett - MVP Microsoft Publisher
...How to remove page numbers from the display?
I opened a spreadsheet that is display large grey page numbers in the middle
of each page of this spreadsheet. These do not print. How do I turn off this
display of page number?
This is a feature of View|Page Break Preview.
Can you just go back to normal? View|Normal
Dale Bedford wrote:
> I opened a spreadsheet that is display large grey page numbers in the middle
> of each page of this spreadsheet. These do not print. How do I turn off this
> display of page number?
You are most likely in the Page Brake Preview mode. To switch to the normal
m...Help with Conditional formatting with Dates
I have a spreadsheet in which I have to monitor various dates which are in
different columns (i.e. (1) Date Tender Released, (2) Date Company Selected,
(3) Date Draft Contract Forwarded, (4) Date Contract Signed etc...).
Would if be possible to Conditional Format and have diffirent ROWs
highlighted for each individual Contracts (I have 300 running contracts
running) every time a date is filled in these different columns:
Initial Step (1) = Yellow (Call for Tender released)
Step (2) = Blue (Company Selected)
Step (3) = Brown (Contract under Process)
Step (4) = Green (Contract Si...Hyperlinks into VISIO page
While it is possible to link from one visio document shape to another visio
file, specific page, I am unable to find or determine (based on testing) the
html syntax for connecting from a hyperlink in a different kind of document
(like a word or excel file) to a specific page. The default seems to be open
to whatever page was last saved. Does anyone know the proper tag for creating
this link? #bookmark works for all other microsoft products, but doesn't seem
to work for VISIO? Thank you.
(and yes, I have already read all the topics in all groups and find no
answer - this is the third...Gridview button field only works on page 1 of grid
I've got a gridview in a Visual Studio 2005, .NET version 2.0 web app, which
displays many records. The grid's AllowPaging and AllowSorting properties are
set to true with the grid displaying 10 records per page.
There is a buttonfield column in the gridview which fires the grid
rowcommand event as follows:
Dim index As Integer
Dim selectedRow As GridViewRow
Dim filePath As String
'find the serial number of the record and open its change history
index = Convert.ToInt32(e.CommandArgument)
selectedRow = Me.SearchGrid.Rows(index)
Forgive me if "Conditional Sums" is not the accurate word for what I am
trying to accomplish... I'm at a loss for what to call this situation.
What I have is a spreadsheet totaling attendance figures for classes taught
by two people (Dave and Cary). Column A lists their name, and next to it in
Column B is the number of people who attended that class. What I need is a
formula that will look at the sheet and report in a given cell the total for
attendance for each person. I can work basic formulas like SUM, but that
will give the total for the entire column, when what I n...$ Amounts on Home Page
It appears that the only way to show a dollar amount for a report on the Home
Page of GP is to include a report under the Reminders area of the "To Do"
For example, if I want to set up as a reminder "Past Due Customer
Transactions" with an amount, it needs to be a SmartList link in this section.
It seems that the "My Reports" section would be able to accomodate a link to
the report with a total to go with it, but it doesn't. Is that what you're
The purpose of the My Reports list is to provide a list of reports. It ...XML Receipt and Conditions
I wanted to make a small adjustment to the receipt when a certain
condition is met.
If a particular word (eg. family) is typed into the comment on an item
I wanted something slightly different to happen to the receipt
I've just about got it, just stuck on the condition tag
I can get it using len but this makes it happen for any word, is there
anyway I can make it so that it is more specific ie Entry.Comment
<CONDITION>Entry.Comment like '%family%'&...Freezing a page?
I would like to know if there is a way to freeze a page so that a table and
every thing in it will not change size if you resize you explorer window.
What would you call this? Thanks
Is that an Excel Q?
On Mon, 11 Jul 2005 08:19:02 -0700, Bullet_Bob <Foljambe hotmail.com>
> I would like to know if there is a way to freeze a page so that a table
> every thing in it will not change size if you resize you explorer window.
> What would you call this? Thanks
Using Opera's revolutionary e-mail client: http://www.opera.com/ma...Line break in cell, char(10) square settings?
I have a problem regarding the char(10) square that appears when you press
"alt enter" to get a line break in a cell. (When using Wrap text)
When I use a cell reference to a cell with a line break the Char(10) square
appears in some of my excel xp or excel 2003 installations but not all of
I have tried to find some settings for this but I have not.
I need the squere to get the line break back when I send the information to
a database and back
Do you have any suggestions?
The square is what char(10...conditionally restricting values in excel
I want to restrict values in a particular column based on the value in other
column. For eg.
if column A has value int then column B should be restricted to values
if column A has value bool then column B should be restricted to values true
if column A has value string I dont want any validation to
be done and the list box should not appear.
Is this possible.....
How do I achieve this ? Can I use macros to do this? How?
as a starting point:
>I want to restrict ...Conditional formating condition..?
I have 2 CF conditions associated with a cell (C14), one of which is:
Formula is =OR($C$4="Fred SOMEBODY",C14<>"10:30:00")
What happens when this is true isn't important/relevant.
The value in the cell appears as 10:30 (formatted as custom/hh:mm) but the
value in the 'formula window' is actually 10:30:00.
This type of condition works fine when the cell contains a simple number (or
text) but I can't get it to work for either times or dates.
I have tried it with and without the inverted commas (around the time value)
and have tried using 10:30 ...