Search:

Hello, I help to run a small community group and we need to arrange a rota to cover attendance at meetings. For the regulart weekly meeting, we have four roles which need filling each week, and for...

Thanks Charles, I'll try a modified version of your macro. Thanks Frank

I have a spreadsheet with several sheet tabs, each with a list of addressees. To create my letters, I mail merge to Word using the named range on sheet one, then I want to move to the named range on...

My spreadsheet date is used to create a pie chart, with the legend on the right. The space I have is too small to show all the titles, only the first four out of the six pie-slices shows up in the...

I have scanned a sheet of paper on which I have handwritten a paragraph of two. It came through as a pdf file, with the handwriting clearly readable on screen. I was able to print it to OneNote 2007...

I'm using W2007 to edit a document for someone else, they tried to create or insert a table and it's got stuck up against the top left edges of the page.

I can move it in by setting the first...

I found I could set a selection to not spell check using the set language dialog box, which has a do not check spelling tick box.

I'm using 2007 - Review tab > Proofing group > Set language
...

I'm spell checking a long academic document, and want to avoid clicking ignore every time an author's name is flagged up as not recognised.
How can I set the bibliography so that "Text marked do...

I can't manage a screenshot, but with two or more calendars open in he same window, the tabs with the calendar name at the top of the calendars have a horizontal button which lets you combine the...

As it turns out, yes we can!
I came back to this after leaving it awhile, noticing that the 'home' calendar appears in the My Calendars section of the left hand side column.
From here I can open...

At work I use Outlook 2007 and open shared calendars to display them side by side in the same window. I can even overlap them. At home I use Outlook 2010 and copied the pst file onto my usb stick....

I now realise I have to use Heading 1 for slide titles and Heading 2 for bullet points. My word doc started out with H2 section headings, and bullet point as, well, bullets.
It seems that you need...

I was told about this command, found in the 'all commands' list of the QAT customise dialog. Apparently is lets me send a Word doc to PP directly, with headings getting changed to slide titles. This...

Hello Colin,
I can see how your solution works now. I was not able to unhide all columns after using the refresh button, by (I thought) keeping the name field blank - hoping to restore the sheet to...

Hello Catherine, thanks for this but custom views won't do the job. They only save a pre-chozen set of show/hide columns and I need to have excel choose which ones to hide according to changing...

Hello Colin and RG,
I've not been able to make either of your suggestions work yet, but don't fully grok the code. I'm spending a bit of time this evening on it and will report back with news. Many...

Many thanks RG!

I want the path to my open document to appear in the footer, so that people can find the original of a printed version when time comes to update the document. This was easy in previous version, but I...

I have various items in my to do list, including emails flagged for followup, hot contacts from the contacts folder, and of course many task item. Some task items have no particular urgency, belong...

Hello Retiredgeek, this almost works - the trouble is where the range of columns is being counted. It works perfectly for Moe, as he is on holiday on day 10. For other staff, the rows up to the last...

On my spreadsheet, I record annual leave, sick absence, training away-days etc for a whole department. I would like to be able to show only the columns with for example an 'AL' for annual leave on...

I have to keep track of several people's calendars, using the shared calendar function in outlook. I use 'open in new window' and tick each calendar in turn, ending up with about six windows, each...

Wow, this is so helpful, the VBA is something I will try out as well.
Many thanks Andrew and Pam!

Thanks Pam, this worked perfectly.

I spend a lot of time 'correcting' the direct formating applied to documents by other people, and having only the four styles which I need, normal, heading 2,...

The styles group on the home tab of the word ribbon has many styles which I never use. I can remove them one by one but they always reappear when I use word again. Can I fix it so that only the...