Search This Blog

Monday, June 20, 2011

How to configure Excel to open only 1 sheet by default

Ever wondered why Excel opens 3 Sheets in a new Workbook and how to fix that to have only 1 sheet by default instead?

Here is a small setting officially provided by Microsoft to configure that.

  1. Start Microsoft Excel
  2. Ideally by default it should open a new workbook with 3 sheets
  3. Click on File tab, now select options from this tab
  4. In the resulting window with "General" section pre-selected, look for "When creating new workbooks" section
  5. 4th field in this section says "Include this many sheets" with default as "3"








  6. Change this to 1







Voila! Next time you start Microsoft Excel, it will create a new workbook with only 1 Sheet.

Tuesday, June 14, 2011

How to setup Exchange account on Samsung Galaxy S or Froyo based Android phones

I already have a Google Apps account as the primary Email account on my Samsung Galaxy S device aka Samsung Captivate (AT&T) and trying to setup Corporate Exchange account was becoming a nightmare. After doing some research here is what I came up with to get this configured and setup correctly.

Info you will need to have handy:
- Domain Name and Domain Username with Password
- Exchange OWA URL

  1. Open the E-mail application.
  2. Press Menu, select Add Account
  3. Enter your email address and password.
  4. Select Manual Setup
  5. Select Exchange Account.
  6. Enter your: DOMAIN\username, password, and Exchange server address.
  7. Check Use Secure Connection and Accept All SSL Certificates.
  8. After authentication, check the boxes associated with the features you want to include such as Push, Amount To Sync, Notifications, Sync Contacts, Sync Calendar.
  9. Click Next.
Note:
  1. In the next screen, you need to give an account name (This just identifies the account if you have more than one email account configured on your device).
  2. Make sure the DOMAIN\username is set up in exactly that format, and the domain should be in all caps.

With an Exchange account set up on your Android phone, you will not find one built-in application to handle all of the apps in one location; instead, you have to view the email, calendar, and contacts separately. Fortunately, when you set up the email account for an Exchange server, it automatically pulls the information for calendar and contacts — as long as you’ve set it up to do so.

Caution: Most Enterprises normally push a restrictive policy on your device for security reasons and they request reset to factory settings and various other permissions based on their policy. Please ensure to check your company policy before you activate your corporate account.