About 396 results
Open links in new tab
  1. Make all text ALL Caps in Excel - Microsoft: Office | Tek-Tips

    Feb 2, 2005 · Hello I am trying to capitalize all text in one specific column. I am unable to find the button or command to make all lowercase text ALL CAPS. Can anyone...

  2. Small Caps Font in Excel | Tek-Tips

    Feb 25, 2003 · There is a small caps font in Word which will make your first letter a larger cap then the rest of your upper cap text. Is there any way to get this font in Excel? Seems that if …

  3. Making Excel respond to keystokes using VBA - Tek-Tips

    Jul 16, 2002 · I am trying to save a file in excel using the SaveAs function, due to the need of making the file an Excel 5/95 & 97 compatible. Everything works fine, however when the …

  4. How to: change entire Excel spreadsheet to all Caps | Tek-Tips

    Feb 1, 2001 · Hi all, I have a 10 page Word document with embedded excel sheets and the client has decided that they want it all in capitals now. How would I go about converting all letters to …

  5. Change format date, dd-mmm-yyyy, but month i need to be in

    Jun 11, 2002 · I'm doimg a macro , in a range of cells i need to convert the format of the cell, the format taht i want is Date: dd-mmm-yyyy but my problem is i can't convert the month in font …

  6. I can't add sheets to my Excel file because it's protected.

    Oct 11, 2005 · Somehow while protecting individual sheets I have somehow locked the entire workbook. Stupid question. How do I remove it? I likely did it accidentally but if I entered a …

  7. Forcing Caps Lock On | Tek-Tips

    Apr 16, 2001 · Is there any way to use code to turn caps lock on if it is not already on? I am trying to keep consistency in the data entered in the database. I need it to be entered in all caps and …

  8. Acessing MS SQL Data through vb script | Tek-Tips

    May 14, 2021 · Good Evening Members, Here i want to access data from Database using VBScript, so regarding that i have gone through some of the examples ,but none of them …

  9. Get vbscript to extract last pwdLastReset from AD | Tek-Tips

    May 13, 2011 · I have a pretty good script I downloaded that extracts a lot of good info about users from Active Directory and puts it into and Excel file, however I am having trouble getting …

  10. Make all capital letters bold? - HTML, XHTML & CSS | Tek-Tips

    Dec 23, 2003 · My goal was to have all capital letters show in bold, as well as convert them to lowercase, so that 'Help!' would end up being ' h elp!' on my pages, without any …