Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Larena

    How to make a thin underline by each group of values?

    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...
  2. Larena

    PowerPoint: Can Continual Re-use and modification Increase Corruption Risk?

    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...
  3. Larena

    QA

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

    New Windows Search: Cortana - Alternatives?

    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.
  5. Larena

    Mircosoft Excel, printing solution

    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.
  6. Larena

    Excel 2010 "Refresh" blocking data

    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...
  7. Larena

    Adding a new Template`

    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".
  8. Larena

    Upside down format? - Excel 2007 text

    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.
  9. Larena

    MSW2010: Increment date in header section of page in MS word doc

    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.
  10. Larena

    VLOOKUP #REF Error

    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)
  11. Larena

    Past Tense Dies?

    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".
  12. Larena

    Past Tense Dies?

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

    Word mail merge - emailing drops footer.

    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.
  14. Larena

    Consectutive dots treated as one character

    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.
  15. Larena

    A facility that allows my client to upload images onto his html-css website as administrator ?

    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.
  16. Larena

    Excel Formula returning Zero

    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.
  17. Larena

    Not Connected to a Network

    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...
  18. Larena

    Macro to fill in missing gaps

    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...
  19. Larena

    Office file repair tools - any recommendations?

    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.
  20. Larena

    XL 2010: Conditional Formatting Merging Worksheets from multiple Workbooks

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

Part and Inventory Search

Back
Top