Search:

Type: Posts; User: TroyWells; Keyword(s):

Page 1 of 20 1 2 3 4

Search: Search took 0.03 seconds.

  1. Showing (or formatting) only columns that have an item in another column

    I am using Excel 2010. I use it all the time, but not the super advanced stuff, and that is what I need. I have a sheet1 with over 11,000 rows. I have another sheet, sheet2, with about 30 rows. I...
  2. Replies
    3
    Views
    1,504

    Maybe my description wasn't clear. If you need to...

    Maybe my description wasn't clear. If you need to do something until you get to the end of the document, this is a good way to do that.
  3. Replies
    3
    Views
    1,504

    Easy way to find end of document

    You all have given me great help throughout the years, including recently. This time, I want to share an answer rather than a question. I tried various methods for finding when I had reached the end...
  4. Replies
    2
    Views
    753

    Perfect! Just what I needed. Thanks!!

    Perfect! Just what I needed. Thanks!!
  5. Replies
    2
    Views
    753

    Find string in style name

    I need to check if a string is in the name of the style of the selected text. For example if Selection.Range.Style contains "stylename", then I need to perform some actions. The style name may not be...
  6. Actually, I just found a solution that works for...

    Actually, I just found a solution that works for the second method using "EXACT":

    =IF(EXACT(B4242,C4242),TRUE)

    Is it possible to do that with conditional formatting? I tried but could not get...
  7. That worked well for the most part. Thanks!! The...

    That worked well for the most part. Thanks!! The only downside I found is that this is not case-sensitive. For example, it shows "KM" and "Km" as identical. I still learned a lot, and appreciate the...
  8. Conditional Format based on adjacent cells being equal

    Is it possible to conditionally format cells when the adjacent cell is equal to it? For example, if b170 = c170, then format one or both cells with some sort of shading?

    If so, how?

    Thanks!!...
  9. Conditional Format based on Language Contained

    Is it possible to conditionally format a cell (like adding shading) based on whether that cell contains text in a certain language (like Chinese or French)?

    Thanks!!
  10. As best I can tell, I do have the Arabic language...

    As best I can tell, I do have the Arabic language pack, and this is not a font issue. I need to convert the HTML encoding to Arabic script, just as happened automatically when I tried my first post...
  11. Forgive me for reposting, but I tried in 2...

    Forgive me for reposting, but I tried in 2 different browsers (Firefox 13, and IE9), and could not get the "Edit Post" feature to work. This is what I was going to edit my post to say: As many do,...
  12. Decoding HTML Encoding of Foreign Language Text in a Spreadsheet

    As many do, our company translated our GUI and messages into many foreign languages. I am responsible for editing (the English) and managing translation of these. I recently asked for a dump of all...
  13. Autohide stops when desktop sharing starts

    Autohide stops working when I start a desktop sharing session, sometimes using IM, sometimes using other software, such as Bomgar. If I reboot, it works again, but that is a pain to shut everything...
  14. Adding Page Number Links to TOC entries in Master TOC made from RD Fields

    We have several Word documents we have to keep separate. We then generate a table of contents using RD fields in a separate document. We then combine the documents into a single PDF. Is there a way...
  15. Replies
    1
    Views
    1,327

    Missing Sheet Tabs

    We are using Excel 2007 to open an xlsx file that is stored on a SharePoint site. All of a sudden, several users can no longer see the sheet tabs along the bottom. We have selected the Show sheet...
  16. Replies
    1
    Views
    1,112

    Typing in Fields in Text Boxes

    I am using Word 2007. We have a document that is mostly a form with check boxes and fields users can type in when the document is protected. However, we also want to type in a field on the cover page...
  17. Andrew, That was a great find!! A couple of...

    Andrew,
    That was a great find!!

    A couple of things:
    1. I could not find any way to control the amount of space between the first consecutive heading and its corresponding bottom border. The...
  18. We have bottom borders on styles Heading 2...

    We have bottom borders on styles Heading 2 through Heading 5. While I know it is likely not a best practice, there are occasions where I have a Heading 3 right after a Heading 2. The problem is that...
  19. I have a template worked on by others. Some of...

    I have a template worked on by others. Some of the list styles indent and outdent to the same horizontal locations as other list levels without changing the number formatting. In other words, it does...
  20. Replies
    2
    Views
    523

    Perfect! Thanks!!

    Perfect! Thanks!!
  21. Replies
    2
    Views
    523

    How do I edit the style gallery? I want to be...

    How do I edit the style gallery? I want to be able to change the order in which styles appear in the gallery. How do I do this?

    Forgive me if I missed it somewhere, but I have looked and could not...
  22. Replies
    2
    Views
    539

    Unfortunately, the uninitiated may add paragraphs...

    Unfortunately, the uninitiated may add paragraphs with other styles, so I know I cannot do much to prevent these styles from being added. However, I would like to keep these styles from automatically...
  23. Replies
    2
    Views
    539

    I would like to set and keep the recommended...

    I would like to set and keep the recommended styles list as is. I know someone could manually change it later, but I don't want it to happen on accident.

    The problem is, if I copy text in to a...
  24. Replies
    3
    Views
    3,756

    I noticed when I put graphics in a header/footer...

    I noticed when I put graphics in a header/footer that they show up faded, even in Print Preview. Text in a footer shows up just as vibrant as text outside the footer.

    Is there a way to have...
  25. I have a macro I have used for years in Excel...

    I have a macro I have used for years in Excel that works just fine, except for one small usability issue. Before I run the macro, I have to manually select the cell that I last edited (i.e. where I...
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4