Search results for query: *

I know this thread is a couple of weeks old, but I have another possible solution. How about using conditional formatting to apply a bottom border each time the group changes? Assuming that the groups are in column 3 and there is a header, the following formula for a condition on rows 2 and...

Every time a document is saved there is a tiny chance of introducing a corruption. If the document is a large file size (e.g. includes lot of pictures) the save takes longer and so there is more opportunity for a corruption to occur. Unfortunately from what I've seen over the years, people will...

Summed up my day very well![bigsmile] Except the bit about escaping my desk to get to a bar.

Everything" is my favourite. I haven't used it for years, but installed it again once I found that searching Win 10 for *.reg was returning all kind of files that don't have a .reg file extension. Happy now.

I use projectors all the time. What's on the left on the projector, PC screen and printed are always the same. If you display the spreadsheet on a normal PC screen, does it loo the same as the projector or the printout? That will help to work out which one is backwards.

It sounds like you have an image that is, or was once, connected to a macro. If you right-click, does that select the picture? If so, try this: Right-click the image Left-click somewhere else in Excel, as long as it's not in the worksheet (title bar, blank part of the ribbon, etc)- this should...

You can also include the style in normal.dotx so you don't need to load a specific template to use it. In the style's properties (right-click > Modify), you can specify that the style should be available to "New documents based on this template".

What a strange request! I don't know of any way to do this inside a cell. However, you could type into a text box, and then rotate the text box 180 degrees - click the text box to select it, then drag the green dot above it to rotate the box.

Your code works for me, so I maybe your section headers are linked, which would cause them all to be the same. When you select a section's header, if it says "Same as Previous", then turn off the "Link to Previous" button. You'll need to check each section.

This should work. You need to look in columns P to R and return a value from the third column in that range. =VLOOKUP(A2,P2:R17000,3,FALSE)

Yup,IPGuru! I found it irritating the first time I hear this, I am finding it irritating right now as I think of it, and I expect I will find it irritating next time it occurs. Oh, and I can't find an emoticon that adequately represents "mildly irritated".

I noticed the same thing here is Australia just recently, & find it quite irritating.

When you perform an email merge from Word, it ignores the header or footer, so you need to include all text that's to be part of the email in the body of the document.

I just had a play with this, and found that "..." as typed into the macro is not actually the … characters that are displayed in the worksheet. If you type ... into a cell in Excel, then copy it from the formula bar into the macro it should work.

I recommended ZenPhoto - I haven't tried the others in the link Chris posted, though. ZenPhoto uses CSS so you can customise it to have the same look and feel as the rest of the site, you can set up individual user accounts, and photos can be uploaded using a web interface or via FTP.

In the example, why does B3 =Sum(B1:B2) = 12? Shouldn't it be 7? Just wondering whether it's a typo, because if it's actually displaying 12 then there's something else going on.

If you don't want to see something on the Metro screen, you can get rid of it. For apps that you'll never use, right-click the icon, then click Uninstall at the bottom of the screen. If you're unsure whether you'll use it, but don't want to see it there, right-click and unpin it. Then you can...

If this is just a one-off fix, I'd use a formula instead of a macro. Assuming aaa is in cell A2, enter =IF(B2="",C1,B2) into C2, then copy C2 into the rest of column C. If column B contains a value, it will use that. Otherwise it will pick up the value from the cell above it. ColA, ColB...

If, as you say, people are getting impatient when saving, they may be killing processes or shutting down resulting in only part of the file being saved. If this is the case, it may be not be possible to repair them.

You can use the format painter to copy formatting, including conditional formatting, between workbooks opened in the same instance of Excel.