Skip to main content

Posts

Showing posts with the label Microsoft Office

Microsoft Outlook Signature : Location of the File

Another simple post - Where is the location of Outlook Signature ? It is at........ C:\Users\<UserID>\AppData\Roaming\Microsoft\Signatures So there are 3 files :  *.htm - for HTML email format *.rtf - for Rich Text email format *.txt - for plain Text email format all of them can be edited via Microsoft Word. simple as, aye?

How To Do : Microsoft Office Excel - Compare 2 Sets of Data

A bit different thing today, a simple task but greatly helps me in getting my jobs done fast. I am in the middle of housekeeping our Citrix licenses as it needs to be renewed. Due to the fact that we are using User/Device model, some users who are already left the Company might have their ID still utilizing the licenses. By freeing up the licenses, it will help the Company to reduce Operational costs and assign the licenses to the other users. Well, it is almost year end, and everybody is coming up with their plan for performance review, why shouldn't I? ^__^! Description : To compare 2 sets of data (Data 01 : all users who are utilizing the licenses, Data 02 : all disabled users id AD). I there are match, it means the users can be removed and the licenses can be released. How To Do : Launch MS Excel, put the first group of data in Column A Put the second group of data in Column C Put the following formula in Cell B1 : Syntax : =IF(ISERROR(MATCH(A1,$C$1:$C$5,0)),

Unable to Increase Row Height in Microsoft Excel

On one fine day, when I wanted to do something with Excel, I realized that I was not able to expand the row height as mush as I wished. so When I tried to change the height by putting the value, I received below error. It turned out that, maximum row height for Excel is 409 points, or 546 pixels. This has been documented in Excel Specifications and Limits, which you may refer to below link (under Reference). As a workaround, you can merge 2 (or more) adjacent rows, and you will get 409n points of row heights ( where n is the number of merged rows was I being silly here by providing that info? ). Give it a try :) Reference  https://support.office.com/en-nz/article/Excel-specifications-and-limits-1672b34d-7043-467e-8e27-269d656771c3
Microsoft has removed a feature from Microsoft Office 2010 which quite oftenly being used by end users - that is Microsoft Office Document Imaging ( MODI ). Therefore, as a workaround, MODI can be installed in 2 ways - MDI to TIFF Converter or Installing MODI from SharePoint Designer 2007. For this purpose, we will focussing on getting MODI installed from SharePoint Designer 2007. Description : Installing Microsoft Office Document Imaging ( MODI ) from SharePoint Designer 2007. How To Do :  Download SharePoint Designer 2007 from http://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=21581  Run the installer  Extracting file  Accept the agreement, and click  Continue   Click at Customize  Put everything as Not Available , at first. Now expand Office Tool , and Choose " Run All From My Computer " for Microsoft Office Document Imaging    So this is how it looks like...  Key in Desired location...  As well as User Information