A Thread for help using Microsoft Office applications

Message Bookmarked

Bookmark Removed

Is there an easy way to add a formatted header/footer to multiple documents in Word 2007? I'm talking about doing it like a batch where the Page number, filename and document title will be displayed in the correct font. It can't be too hard can it?

― the next grozart, Monday, 30 April 2007 11:40 (nineteen years ago)

Can you do it as a template (then cut and paste the documents into the template if you've already done them)?

― ailsa, Monday, 30 April 2007 13:34 (nineteen years ago)

You could write a VBA macro to do it.

― Forest Pines, Monday, 30 April 2007 13:49 (nineteen years ago)

I was using Microsoft Word earlier and it annoyed me so much I put my foot through the monitor - am I entitled to send them the bill?

― Michael Philip Philip Philip philip Annoyman, Monday, 30 April 2007 14:36 (nineteen years ago)

Ailsa seems to have the easiest solution, just create a template and C&P.

And here is my drafting hint - if you are in the UK, please ensure that your template is set to UK English, otherwise Word will helpfully automatically 'correct' some of your spellings, to somewhat irritating effect.

Yrs
"it took me longer to figure out why it kept US spellings even though I'd set the dictionary to UK than it outta"

― Sarah, Monday, 30 April 2007 15:07 (nineteen years ago)

― klankton, Monday, 30 April 2007 15:17 (nineteen years ago)

I can speak only for Word 2003 and 2004, but if they haven't totally fucked up 2007, this is very easy to do with a simple macro. The steps:

1. Go to tools -> record new macro. Assign it a keyboard shortcut if you like.
2. Push "start recording".
3. Edit a sample document.
4. Go to tools -> macros -> "stop recording".
5. For each document you want to run this on, open the document and hit the keyboard shortcut, save, and go on to the next.

― libcrypt, Tuesday, 1 May 2007 03:10 (nineteen years ago)

four years pass...

How can I search email subject lines in Office 2010 without first searching in that little box and clicking on Search Tools > Advanced Find after it finishes churning through my six work email inboxes?

― James Mitchell, Wednesday, 14 September 2011 09:34 (fourteen years ago)

view -> arrange by -> custom?

― Crackle Box, Wednesday, 14 September 2011 09:37 (fourteen years ago)

I do not have "arrange by" under "view".

― James Mitchell, Wednesday, 14 September 2011 10:40 (fourteen years ago)

oic we have 2007 here at work

before i trawl through all those horrible excel forums, does anyone know how to do batch processing in excel?

i want to run a macro in about 1000 spreadsheets without having to open each one up...

― Crackle Box, Friday, 16 September 2011 10:04 (fourteen years ago)

You must be logged in to post. Please either login here, or if you are not registered, you may register here.