page breaks #2
Can someone tell me how to get rid of the page breaks on my worksheets. I
find them to be distracting, espeically when I do not need them there at
Personally, I put a button on my working toolbar attached to this macro:
Public Sub TogglePageBreaks()
.DisplayPageBreaks = Not .DisplayPageBreaks
But you can also hide them by choosing Tools/Options/View and uncheck
the Page breaks checkbox.
If you don't care about printing the sheet, another alternative is to
choose File/Page Setup and click the "...A2002 bug: Text box (memo-field): division of words with diacritics
I'm having BIG problem with text boxes for memo-fields. A2002 (incorrectly)
divides words with Czech diacritics, see the attachment. It's OK when I
replace a letter with diacritics with a letter without diacritics.
Is there any workaround?
P.S. I have tried it with MS Sans Serif, font size 8, and Arial CE
(preferred), font size 9.
P.P.S. Same problem with reports...
Instead of attachment, pls, check out the images:
http://img175....Word legal templates
I want to know if Microsoft Word has legal pleading templates such as
WordPerfect to submit legal briefs.
Can't remember for sure but the first place to look is in File> Project
Gallery. If you don't find what you need there try here:
Even though not 'designed exclusively' for Mac they should present no
problem, but you might need to review the information on this page:
"Alberto Dominguez" <ad44...pages go down over the next page?
This is a multi-part message in MIME format.
I'm kinda new to Publisher so I've got a booklet going of about 20 =
pages. From time to time I'd like to add text or a graphic and have the =
whole "document" go down and over to the next page like it does in Word.
Am I missing something? Or are we stuck with having to make a new page =
and cutting and pasting over?
------=_NextPart_000_0025_01CA42D0.AF...Workbook Page Numbering #2
Any way I can number worksheet pages that reflect the
entire workbook? For example, let's say sheet1 has 3
pages and sheet2 has 4 pages... to have each page
print "page 1 of 7", "page 2 of 7"... thanks!
Select first sheet then right-click on the sheet tab and "select all sheets".
Then in Print check "Entire Workbook"
Gord Dibben Excel MVP
On Thu, 19 Aug 2004 07:10:51 -0700, "Andrew"
>Any way I can number worksheet pages that reflect the
>entire workbook? For example...How to start header on second page?
I want the header to start on the second page. Other programs prompt you
where to start. Excel doesn't seem to do this. Do I have to write a macro
to accomplish this? If so, how do I find out how to do that?
IF you mean that you want a constant row to appear on each PRINTED sheet
file>page setup>sheet>rows to appear
"LLeips" <LLeips@discussions.microsoft.com> wrote in message
> I want the header to start on the second page. Other programs p...A Word Macro to VLookup a Range in Excel
With a combination of VLOOKUP and MATCH formulas in Excel I'm able to grab a
cell's value from a multi-row, multi-column range. But I can do this only
from within Excel. The formulas look like these:
=IF(H4="",0,(VLOOKUP(H4,$A$1:$E$50,MATCH("REG",$A$1:$E$1,0),0)-VLOOKUP(H4,$A$1:$E$50,MATCH(IF(I4="","REG",I4),$A$1:$E$1,0),0))*IF(J4="","1",J4...Path in page footer
How can I include the full path of where the document resides on my
workstation, in the footer of my worksheets?
Private Sub Workbook_BeforePrint(Cancel As Boolean)
Dim wsSht As Worksheet
For Each wsSht In ActiveWindow.SelectedSheets
wsSht.PageSetup.LeftFooter = "&""Arial,Bold""&8" & Me.FullName
'This is workbook event code.
'To input this code, right click on the Excel icon on the worksheet
'(or next to the File menu if you maximise your workbooks),
'select View Code from the ...Excel should allow you to swap rows. Also swap columns
This is a general feature request for Excel.
It would be great if I could select 2 rows (using ctrl + click). Right-click
on one of those rows and have a menu choice called Swap.
Example: assume that I have selected row 2 and row 4,
...Web Page Login Page
Does anyone know how to create a login page iwhen developing a web page in
Publisher 2003 ?
MadPuppy looking for help
That is a server side function. Go to your host and read the FAQs or other
documentation on password protected folders.
"MadPuppy" <MadPuppy@discussions.microsoft.com> wrote in message
> Does anyone know how to create a login page iwhen developing a web page in
> Publisher 2003 ?
> MadPuppy looking for help
Some good information here. It's from my ISP.
http://www.i...Selection/Range different in Word 2010 ???
I'm testing my code on Office 2010 (latest Beta). Most everything
works, except i'm hitting a strange problem in one of my functions
that inserts text (piece by piece) into a doc.
I'm calling this function from another function that takes a string
with markup in it, e.g.
"Name, G. (2002). <i>Title of paper</i>. Santa Cruz, CA."
and turning it into a paragraph. I "walk" through the string, breaking
it into pieces that have or don't have markup. And then I insert each
piece at the end of a paragraph; if the piece has markup, then th...swap axes
In a line chart, Excel seems to predetermine the category axis - how can I
swap this so that my Y-value axis appears along the bottom?
Have a look at Jon Peltier's page
> In a line chart, Excel seems to predetermine the category axis - how can I
> swap this so that my Y-value axis appears along the bottom?
Andy Pope, Microsoft MVP - Excel
I've got the same problem as Fridgemaster. Andy, good try, but your solution
is not what we are asking. Prima...Word XP
A couple of times I have had this problem:
When I open Word. the view shows the side margins but not the top and bottom
margins (in Print Layout View). If I look at Page Setup, the top and bottom
margins are set correctly. I have not been able to see the top-bottom
margins in any view. Each time I could only fix this by using System
The same problem has just happened on my wife's PC, and I replaced her
normal.dot with mine, but that didn't fix the problem. Again the only way
we could fix it was with System Restore.
Can any one shed some light on this r...Huge blank gaps when cutting and pasting from Notebook view to regular Word doc
Operating System: Mac OS X 10.5 (Leopard)
Repeatedly whenever I try and copy from my notebook layout (where i take class notes) into a Word document, Word leaves HUGE gaps on the page which cannot be eliminated by deleting or back spacing. <br><br>There will usually be about a half of a page empty between the text that was already in my regular Word document, and the text I paste from my notebook document. I have tried EVERYTHING to eliminate this problem, as this feature is extremely important when consolidating my notes at the end of each semester. <br><...how to work writefile function with Microsoft Word
If we write any DOC file using MS Word i think we need
above functions.... Can anyone tell me what happned between WriteFile
& closefile functions.
if i hook WriteFile function & im using it like::::
BOOL WINAPI _WriteFile(
HANDLE hFile, // handle to file to write
LPCVOID lpBuffer, // pointer to
data to write to file
DWORD nNumberOfBytesToWrite, // number of bytes to write
LPDWORD lpNumberOfBytesWritten, // pointer to number of bytes...Margin Trouble with Custom Page Size
When I try to print in Publisher using a custom page size, printer or
Publisher adds approx 1.5" to the top of my page margin, no matter what I do.
Checked the printer settings in WordPad, all looks OK. Issue does not occur
when printing on 8.5X11 page, nor does it occur in MS Word. I don't have any
extra margin set in Master Page...have tried everything I can think of.
Under deadline to print invitations and getting desperate...help! Thanks.
How are you setting up your printer? Are you saving the custom setting? Are you
setting up your printer first? What model is your pr...Word wrap mode and space character
I have created derived CEdit box class, instance is created
from resource. In resource I have set attributes: Multiline=TRUE,
AutoHScroll=FALSE, AutoVScroll=FALSE .
All is working but I need adjusted behaviour in word wrap.
I have set width of my edit box resource to accept 8 characters
of Courier font.
When line in edit box is filled with non-space 8 characters and after it I
this space does not appear in next line and cursor remains on first line.
But this space appears in end of text buffer - I see it in memory. I must
press space again to see it in...Saving as web page
When publishing spreadsheets as web pages I would like to
set the page to fit within a full screen view. I have
some that fit and some that don't and I've worked with the
formats in Excel to fit everything within the screen on
all of them, but that doesn't seem to help.
Can I set the format to do this?
Thank you in advance for your assistance.
...center page top to bottom
How do I center my text top to bottom? In Word 2003 it was under page
On Wed, 6 Jan 2010 18:45:01 -0800, Sonja
>How do I center my text top to bottom? In Word 2003 it was under page
Assuming you now have Word 2007, it's in the same dialog but it takes
a different path to get there.
Click the Page Layout tab of the ribbon. In the bottom right corner of
the Page Setup group, click the little button to open the Page Setup
The setting you want is on the Layout tab of the dialog...Add Customer Number function to Collection Letters in Word
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
What do you mean by your request?
Charles All...Delete page
How do you delete a page from a Word document?
On Sat, 6 Feb 2010 15:31:02 -0800, Tom C <TomC@discussions.microsoft.com>
>How do you delete a page from a Word document?
Select it all, press the Delete key.
Note that this is not a Word forum, it's for a different program (Microsoft
Access, a database); the webpage can be confusing - find the list of products
on the screen and scroll down to one for Word.
John W. Vinson [MVP]
Press Backspace button until the page delete.
I always do so.
"Tom C" <TomC@discussions.microsof...inet worth report on home page
is there any way to view the net worth report on the mony 2005 home page like
you could in money 98. I can not find the option anyware.
...Deleting extra pages
I only need page 1-3. Page 4-6 shows grid lines and footer. How do I delete
I'd reset the print range.
file|print area|clear print area.
Debra Dalgleish has some notes on how to reset the last used cell at:
Sometimes this will clear up the problem of excel trying to print too much.
> I only need page 1-3. Page 4-6 shows grid lines and footer. How do I delete
> these pages(4-6)?
...Tutorials/Resources on how to make a Word Document 508 Accessable
I have a document in Word that I need to make 508 accessable because I work
for a fedeeral agency. I am ultimately going to convert it to acrobat format
but I hear it is much better to make the doc ument accessable in Word rather
than waitng until it is in Acrobat. I also found this to be true because
converting tables in acrobat format is a complicated task that I have still
not ben able to figure out.
So ... can anyone lead me to some good tutorials/resources on how to make a
Word Document accessable so when I convert it to Acrobat, the Acrobat file
can be read ...Outlook 2002 using word as e-mail editor
Out of 15 users using Outlook 2002 there is only one PC
that has a unbearable lag time while trying to open word
2002 to use as their e-mail editor.
Please help as i cannot find any solution for this other
than not using word at all.
What is different about this one user's setup? Software? User rights?
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. Due to
the (insert latest virus name here) virus, all mail sent to my personal
account will be deleted without reading.
After searching google.groups.com and finding no ans...