Does anyone know if you are able to re-number the rows in Excel 2000? I
am refering to the numbers generated by excel on the extreme left of
the spreadsheet. Some how the numbering got out of sequence. Does
anyone know how the rows get out of sequence? When I attempt to delete
rows to test if the numbering changes, the rows renumber automatically.
Based on my test, I'm not sure how the rows numbers got out of sequence
in the first place.
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from...after selecting grindlines, why does it still print without any?
After I select with grindlines , why does it still show none?
go to the last tab in Page Setup dialog and select gridlines.
Two different settings - one for the screen and one for printing.
"cson" <email@example.com> wrote in message
> After I select with grindlines , why does it still show none?
Assuming you are selecting "gridlines" in the Page Setup>Sheet dialog.
Perhaps you have "Draft Quality" checked also.
Gord Dibben Excel MVP
On Fri, 25 Ma...How to do print and printpreview in non-view class?
In view class, we can do print and printpreview with OnPrint,
OnPreparePrinting, etc. function. In non-view class, how to do?
> In view class, we can do print and printpreview with OnPrint,
> OnPreparePrinting, etc. function. In non-view class, how to do?
Not sure about preview, but you can certainly do printing fairly
easily. There's an article on the KB called "HOWTO: Print from a Class
Other Than CView (Q133275)" that shows this.
Try this article for printing without the Doc/View framework:
http://www.codeproject.com/printi...Outlook 2002 Calendar Printing Problem
When I try to print my calendar I get the following error
"Unable to save the print settings. Make sure the file
C:\Documents and Settings\bng\Application
Data\Microsoft\Outlook\OutlPrnt exists and can be written
How to I correct this problem?
...IWebBrowser2:How to set HTML page content from a Stream contains <img> with src set to relative path rather than full image path
I try to use IWebBrowser2 to load html content from a stream, which contains
image with "src" set to relative file path rather than full file path, it
seems IWebBrowser2 can not resolve the image path even I put the executable
and the image file under the same directory. The dynamic html content is
simple as "<html><head><title>test</title></head><body><img
src='test.jpg'></body></html>". Could you tell me how to do that?
I use IHTMLDocument2::write to load html content dynamically.
Thanks a lot.
...Implementing a Label with certain data in Chart
Dear All !
I have a data set plotted in Excel.
Is there any way to show automatically the minimum, maximum and median value
of this data set on the chart? (In a form of label or anything similar)
Minimum and maximum values are already part of data set.
Median value is a calculated value and is in another cell(not part of data
Thank You in advance
I'd probably do this in a manner similar to what Jon Peltier shows here for
the Vertical Category Axis.
You could then create a custom format for each "Label" s...modifying predefined page designs (or creating a variation of predefined page designs)
I have inserted a photo gallery using:
INSERT / PAGE / PHOTOS / PHOTO GALLERY WITH LINKS.
This generates a main gallery page with 12 images, each linked to a
photo detail page.
My problem is that I would like to modify the format of the photo
detail pages--but preferably before inserting the photo gallery so I do
not have to modify all 12 photo detail pages every time a gallery is
I cannot find the photo detail page definition/template.
Can it be modified?
Can I create a modified version PHOTO GALLERY WITH LINKS based on the
Any help would be greatly appreciated!
Thanks...Close header button
I am in a footer and the "Close Header and Footer" button is not illuminated
and will not work.
If you can't get the "Close Header and Footer" button to work, press the
escape key and it will close the head and footer.
> I am in a footer and the "Close Header and Footer" button is not illuminated
> and will not work.
If the "close header and footer" button does not work, press the escape key
and it will close the header and footer.
> I am in a footer and the "Cl...Print address labels
Getting this message word cannot start converter mswrd632 or DOSWRD32
Click the Fixit button at
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP
My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
"Robneedshelp" <Robneedshelp@discussions.microsoft.com> ...Journal Entry List will not print
For Outlook 2002 -
I'm not sure what I am doing wrong but each time I try to print or preview
my journal view, I end up with this popup note "You cannot preview message
headers until they are downloaded".
I have tried searching knowledge base FAQs to no success. What does this
message mean??? I can print or preview a single entry but not my custom view
Please supply the steps you're using to try to print.
Sue Mosher, Outlook MVP
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
...Printing Old Publisher 98 File in Publisher 2002
A file from an Old Version of Publisher (98) won't print
on the New Version of Publisher (2002) on my HP 6MP Laser
Printer. How do I resolve this problem?
Whilst attempting to develop brick-based storage technology, Ed reads a
message from Ron Ward <Ronward@myibocs.com>
> A file from an Old Version of Publisher (98) won't print
> on the New Version of Publisher (2002) on my HP 6MP Laser
Have you worked through the print troubleshooter?
How exactly is it not printing? Do other programs print? Do other
Publisher documents print?
Have you gone to the websi...Lost Some Row Numbering
Somehow, when I cloned a worksheet to unused worksheet in my
workbook, the numbering (in the left-most column) has lost the 1st 5
values (I failed to copy the 1st 5 rows). IOW, my worksheet starts with
Row 6 and continues down from there. I can't find anything in Google
that tells me how to fix this, so I'm asking here. Please advise. TIA
these lines are probably masked
Le 2012-01-19 17:22, Mike Copeland a �crit :
> Somehow, when I cloned a worksheet to unused worksheet in my
> workbook, the numbering (in the left-most column) has lost the ...Condtional Formatting
My conditional formatting applies to cells (see row numbers):
When I insert 10 rows between row 41 and 42, the condition now applies to
cells as follows:
1. Is there a way that the condtions will not be copied to rows 42 to 51?
Or, the condition will apply only to each cell, i.e."
etc. to =$B$51
Use the absolute column reference of $B and the relative row reference of
41 to get the seconf optiont.
To not have the CF copied to the inserted rows, turn off the option to
"exte...bmp within header or footer
It seems I am not able to put a bmp of my company logo of the header or
footer. If I want to have my logo on a spreadsheet, it can only be in the
body of the spreadsheet, and looks goofy as it is "dangling" below the
Thanxs from SoCal
what Excel version are you using?
"Justin" <firstname.lastname@example.org> schrieb im Newsbeitrag
> It seems I am not able to put a bmp of my company logo of the header
> footer. If I want to have my l...How to roll down a new page
I have a welcome page that show for a instant and then is replaced with the
It would be nice if the Home page unrolled on top of the welcome page or
slid in from the side like a slide might or the wecome page looked like a
I have no idea how such things are accomplished.
Can you give me a place to read up or a sugestion as to what to google?
Check out ASP .NET AJAX or Silverlight Develpment.
" Cal Who" <CalWhoQQ@roadrunner.com> wrote in message
>I have a we...Printing Question #2
I want to print sheets from several books, having the
page numbers sequential (as tho they were all in the same
book). Is this possible?
It might be easiest to just create a new workbook, copy all the worksheets from
each workbook into that new workbook.
Then rearrange the worksheets in the order you want
select all the worksheets
File|page setup and fix the footer/header the way you want (if you want a common
page number location)
Then File|print|Entire Workbook
(I'd check it with print preview first.)
If you have multiple workbooks open, you can use
...after each slide return to a certain slide
I have a game created in powerpoint, when asked the question and given the
answer I need to return to the same slide where the questions are, what do I
need to do this so when I click the mouse it returns to that slide?
On 2/22/10 11:01 AM, Mary Sue wrote:
> I have a game created in powerpoint, when asked the question and given the
> answer I need to return to the same slide where the questions are, what do I
> need to do this so when I click the mouse it returns to that slide?
Here are a couple of things to try:
(1) If they click on a butto...Money 2003 Std. Printing reports
Using Money 2003 Standard Edition. I am trying to print a report. Having
adjusted the width of the 'Payee' column so all is visable, I somehow
managed to move the Date column also. The result is that the date now runs
into the payee names without any space, making it very untidy to read.
I tried clicking on the divider again between the Date and Payee colums but
it seems locks, no matter which way I move it, the distance between the two
columns remains the same.
Microsoft seem to want everything to remain as you last used it, as when I
try closing down and restarting, it presents its...Row Limit in Excel
I work a lot with excel and I know that the row limit is 65,536, but I need
more than that. Is there any way to make the number of rows infinite or at
least to give me a certain amount of more rows. If there is please let me
know. Thank you.
Molly, that is all there is, per sheet.
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
"Molly" <email@example.com> wrote in message
news:FD2C7921-E249-4...Receipt / Invoice printing Terms & Due date
We do a lot of charging on customer accounts. Is there a way to show the
Terms and the Invoice due date on each invoice / receipt?
Thanks in advance,
The only way I have been able to accomplish this is by putting the
terms into a customer custom text field and printing that on the
receipt. We then created a customization that will populate a receipt
variable with the current date + the number of days in the terms. I
have not been able to use any other receipt variable to get this to
New West Technologies
Check out amazing RMS extensions:
http:...Rows to columns
Hello all..............first post from an extremely newbie Excel user.
My apologies if this particualr forum isnt the correct one for this
post, however here goes :)
OK, I've attached scren print of an excel spreadsheet (small extract of
a larger one). On it there are columns A -> F. In column C there are 4
or 5 rows relating to one address.
What i'm trying to do is move these rows into one single row, but move
the number at the start of the address into the column in front. The
ain is to be able to sort the entire work sheet into alphabetical order
based on the street. Hopef...Unable to delete rows/columns
Worksheets open with over 60,000 rows and many columns. Selecting cells and
using the delete command does not work. Assume there is there is no links
from worksheets to any other document because "Links" command is not
what does 'does not work' mean. Do you get an error?
"charles Callahan" <firstname.lastname@example.org> schrieb im Newsbeitrag
> Worksheets open with over 60,000 rows and many columns. Selecting
>...Transport row`s data into separate etiquettes
hello, I wanted to make the data in the rows to be settled as etiquettes for
later printing. I heard there was a way to transport them automatically. I
would appreciate any answer, thanks.
What are "etiquettes", tickets, labels? Perhaps the use of Microsoft
Word, and Mail Merge and supply your Excel file as the data source.
> hello, I wanted to make the data in the rows to be settled as etiquettes for
> later printing. I heard there was a way to transport them automatically. I
> would appreciate any answer, thanks.
...Add row after column of duplicate info
I want to know if there is a way to have Excel
automatically insert a blank row after a column if the
number in the column changes.
Would like for it to automatically insert as below:
Insert blank row here
Insert blank row here
Insert blank row here
Can anyone help with this? It would be greatly
Data|subtotals can add a line with subtotals between cells with common values.
You can use the outline symbols to show just the subtotal line,
select those visible rows
...Printing doc to Document Image Writer then displays in image viewe
I’m programmatically printing a Word Document to the Office Document Image
Writter. After calling the wordDocument.PrintOut( ) method, the image of the
document is then displayed inside of my default image viewer (which in this
case, is IrfanView 4.2). Is there a way to suppress the “shelling out” and
just process the document?
Any help is appreciated!
Office Document version: 2007
Visual Studio 2005