EXCEL:printing row headings at the top of every page.
I have looked at the EXCEL help and am not able to get row
headings at the top of every page. I see the sheet tab
and I see where I am "supposed" to enter the rows to be
printed at the top of every page. HOWEVER these cells
are "grayed out" i.e. inaccessible. Is there something
else I need to do before I can access this function? It
seems simple enough, but I am not able to enter rows to be
Are the sheets grouped? as this will cause that to happen, in which case you
need to ungroup and set the print area.
Ken.............Inserting rows into sheet that contains a formula
I have a typical financial sheet where the columns sum (sum(a5:a15)) and the
rows sum (sum(a5:h5)). The summation columns are locked and the sheet
Is there a technique whereby I can have the user insert a row which will
keep the formats and row sum as well as changing the formula in the column
The following method is not foolproof but generally it works OK.
Insert a blank row between the bottom of data to be summed and the row with
the sum formulas.
Include the blank row in the sum formula.
Protect the blank row along with the formulas and what...Missing pages when PDF entire workbook
Operating System: Mac OS X 10.6 (Snow Leopard)
Hi Guys <br><br>I have an Excel query that is baffling me. I have a workbook with 46 sheets. When I go to PDF them, I choose "Entire Workbook", preview shows 46 pages so I select my folder and let it do the work. <br><br>No matter what happens it will only do 38 individual PDF's, and every time. <br><br>I have tried selecting a different printer, deleting a sheet that wont PDF and recreating it, renaming a sheet that wont PDF, PDF a selection and nothing ...Removing words from the standard dictionary
I'm the sort of person who spells role as r�le and I've often wondered if a
mechanism exists to remove the word "role" from the standard dictionary, or
perhaps override it somehow, with my preferred spelling.
Similarly, I never find a use for the word "poser" in my business
communications, but frequently type it in place of "power", with
unfortunate consequences. So I'd remove "poser" from the dictionary as
Is there hope for me, and my Office 2003?
http://www.ringers.org.uk (Personal Webpage)
http://hedgeh...clip art inserted into business card prints solid black box
I have entered clip art into a business card, it shows up fine on "Print
Preview" but when it actually prints, it is a solid black box.
What format is the image? High-resolution pictures can cause this especially if
they are a 48 bit tiff. Import the clipart into an editing program and change
the image resolution.
Mary Sauer MSFT MVP
"Mendy" <Mendy@discussions.microsoft.com> wrote in message
news:54608BE3-54BC-4D0...Convert a word address and data list to excell
I help with a food pantry and the existing cliant data list was created in
word seperated by commas. I am told to put all 1500 or so cliants in to note
pad, then put them on one line (data of each cliant seporated by 7 commas and
their children seporated by ;) then I can put them into excell. Well I am
only up to the C's and have been doing it for 3 weeks now. Plus we keep
adding new ones every week which are not in order now.
If anyone could help me with this I would so appreciate it.
if they're still in Word, select the list and choose edit / replace
in...Word e-mail message window stops responding
MS Word 2002 e-mail message window stops responding after coping and pasting
The Word is chosen in Outlook as an e-mail editor.
The window appeared after clicking reply in the Outlook.
Please, inform me of your reply: click Message menu, then 'Reply to all' in
Outlook Express (this sends your reply to the newsgroups and to my email
address at the same time) or inform me by sms to 79163876746 from
www.mts.ru/sms or to my ICQ#135557327 or by messenger to
Mr. Dmitriy Kopnichev
- Upgrade to the latest service pack ...VBA: Insert Page Breaks code is not working in Excel 2010
I have a snippet of VBA code to insert page breaks after a particular row.
This works fine in Excel 2007, but it doesn't in another Excel 2010 machine.
It doesn't seem right to me that VBA code would behave differently in
different versions of Excel. Am I missing something??
RE: Am I missing something??
Yes, your code.
"iswarya" <u59539@uwe> wrote in message news:a6e77011b51d5@uwe...
>I have a snippet of VBA code to insert page breaks after a particular row.
> This works fine in Excel 2007, but it doesn...Macro that inserts lines
I have this macro that inserts a line if the value in D changes and copy the
value in D to A. I want this macro to only start looking in D14 or from row
tx for all the help
Dim row_index As Long
Application.ScreenUpdating = False
lastrow = ActiveSheet.Cells(Rows.Count, "A").End(xlUp).row
For row_index = lastrow - 1 To 2 Step -1
If Cells(row_index, "D").Value <> _
Cells(row_index + 1, "D").Value Then
Cells(row_index + 1, "D").EntireRow.Insert _
Cells(row_index + 1, 1).Value = Cells(row_index + ...Powerpoint VBA textbox tab order
Hi all I have a powerpoint presentation with a number of textboxes on each
slide. I would like to be able to setup a tab order for these. I am used to
using this sub in excel (on keydown)
If KeyCode = 9 Then
However it seems that the powerpoint textboxes don't have an activate method.
Do you mean a standard textbox shape in PowerPoint, or a VBA textbox control?
If you mean the latter, it has a .setFocus method, but I don't think it's
available outside of a UserForm.
"Bob Fishel&qu...directly emailing word or excel document
From either Word or Excel 2007 - File - Send as email attachment I get the
error Logon Failed, you must log on to Microsoft Exchange to access your
address book. I am using Windows Live Mail and have set thjis as my defalt
...Dynamics GP Collection Letters in Word
I would recommend that Microsoft add a document date option for the
collection letters. Not everybody goes off of the due date.
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.
http://www.microsoft.com/Businesssolutions/Community/NewsGroups/dgbrowser/en-us/default.mspx...40 page book using Publisher 2003
I want to create a 40 page document in Publisher similar to a book. The page
numbers & contents do not print in order. Can you please assist in determine
how I can write this small book using using Publisher 2003? Thanks!
Are you setting up your page as a booklet? If you select booklet in page setup,
the pages will print in the correct order. What problems are you having? There
is a specific process to print booklets to get it correct if you do not have a
Do you have a duplex unit?
Mary Sauer MSFT MVP
news://msnew...Inserting a Flash Animation on an email
How can insert a flash animation to an email. Where
does .swf file has to be so the person that receive the
email can see the animation?
...Problem with PowerPoint Slideshows
I have an iMac with Office 2004. On several occasions when someone has
sent me a PowerPoint presentation, my computer freezes up when I try
to view the presentation. When I save the presentation to my computer
and try to view it as a slideshow, it also freezes up. Would welcome
You have mentioned someones sends you PPT presentation. Can you give us more
information? Is it purely Mac presentation or some PC's one come into place:
Are there any images in the presentation (which format they are)? Are there
any inserted tables, chart form Excel and other object from...CListCtrl slowing down after several insert's/delete's
Here's a twist on a classic question on CListCtrl being slow to remove
thousands of records. I'll first described the setup then the various
tests I did. The program is running on Win98, I guess on XP I won't even
know if there's a difference, but I am curious about why it gets slower
after multiple fill in a listctrl.
I have an executable acting as the main program. Menu option calls a
dialog box (call it DIALOG A) in a DLL which displays ~250 records. This
listctrl loads in a flash. Upon selecting a record from the list,
another window (call it DIALOG B) is di...trying to get Word tables into Publisher
I am taking over the job of finishing a school directory from someone that
used Word to input the student data. She put only ten students on a page and
I need to change that to fit more students on a page because the directory
has become too large.
Each student entry is taking up 3 lines in the table; each line has 3 fields
<student name><phone><street addr>
<dad name><dad phone><city zip>
<mom name><mom phone><family email>
In lines 2 and 3 in each entry, the columns are aligned. But in the first
line, the student name field is longer th...Loading in the BODY section of HTML from a web page
I know you can use the Web Query feature to load in elements of a web page.
However I wan to do the following:
- Specify the parameter for a URL (e.g www.yada.com/page.asp?=<PARAMETER>)
and have Excel get the body of the html from that page, for 100 different
pages (the parameter will just be a number), and have each body be loaded
into a different cell
- I'll then process that body to extract the essential info.
How can I do this for the 100-odd diff pages? I can do it fine just for one,
manually specifying the parameter with Web Query....
...Insert File (Insert as Text) Into Contacts
I'm using O2003. I have a number of files I always insert into my
contact's notes. By default, the Insert button on the "Insert File"
dialog defaults to inserting the file. Is there a way to change this
button to default to "Insert as text"
srm <email@example.com> wrote:
> I'm using O2003. I have a number of files I always insert into my
> contact's notes. By default, the Insert button on the "Insert File"
> dialog defaults to inserting the file. Is there a way to change this
> button to default to "Inse...Unable to insert record in table
Using SQL Server 2005.
I have a table with one required field (key field, var type int) and various
other optional fields.
Yesterday, my Access VBA code failed to action the following SQL statement:
INSERT INTO ORDERS (OrderID) VALUES (9121165)
I got a time out error and a report that the record could not be inserted
(error code -2147217887).
So I opened SQL Server Managment studio and opened the table. When I tried to
insert a new record using the same OrderId, I first got a timeout error and
could not add the record. AFter OK'ing the error, I was able to cli...Sql insert statment from from list box to table or form
I have the following list box called list0 with the following in row
SELECT tblCityStateZip.City, tblCityStateZip.State,
i have a form called frmpeople with the following
SELECT tblCityStateZip.Zip, tblCityStateZip.City,
What i want to do is when user double clicks on city state zip in the
list box will insert those in the form called people where it says
Well, is the list0 listbox also on ...Why won't word alphabetize a list of email addresses?
I typed a list of single spaced email addresses separated by paragraphs and
want to alphabetize them. When I try, I get an error message "Word cannot
sort fields in the selections." How can I sort this list? Thanks!!!
In the Sort dialog, for "Sort by," make sure you have "Paragraphs" selected
instead of "Field 1" or anything else.
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
"Sort list of email addresses" <Sort list of email
firstname.lastname@example.org&...Word uses up a lot of memory
When I open a file of Word97-03, it uses up a lot of memory.
eg. My RAM is 4GB and it uses up 1,002,188K for WINWORD.EXE
Sorry, but this newsgroup is for questions about Access, the database
product that's part of Office Professional.
You'd be best off reposting your question to a newsgroup related to Word.
Should you do that, it might help the responder to know more about your
setup. What version of Word are you using? What Operating System? What else
is running at the same time and so on.
Doug Steele, Microsoft Access MVP
how do I insert those little faces in my emails in outlook express?
Try posting this in an Outlook Express news group - this is not one of them.
Outlook is a part of Microsoft Office and is what this group supports.
Outlook Express is a part of Internet Explorer and has its own news groups.
You can also find some good Outlook Express information here:
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact.
ALWAYS post your Outlook version.
How to ask a question: http://support.microsoft.com/KB/555375
After f...Insert File Path
In Word 2007, I would like to have either a shortcut key or a QAT button to
insert the full file path of my document. I use this very frequently in the
File path and Insert file path commands are not available in Customize
How can I do this?
Save the field as an AutoText entry and assign a keyboard shortcut.
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
"gordo" <email@example.com> wrote in message
> In Word 2007, I would like to...