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.
Posted by at No comments:
Labels: , ,

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.
Posted by at 1 comment:
Labels: , , , , ,

Wednesday, April 6, 2011

How to include external link in Google Sites

To include external link in an 'IFrame', there are gadgets that are available, however following steps allow you to do that natively in Google Sites without using external gadgets.

  • Edit the page you would like to include external link
  • Click "Edit HTML Source" from the toolbar on the top of the page
  • Embed the following code
      • <html> <body> <iframe src="http://www.google.com" width="100%" height="150"> <p>Your browser does not support iframes.</p> </iframe> </body> </html>

In this case the google.com search page will show up in the page where you inserted the above code.
Posted by at No comments:

Wednesday, March 30, 2011

How to re-download all Apps from Apple AppStore in your iTunes library?

Have you ever been frustrated after a backup/restore process when iTunes library is missing all the Apps you have purchased (free or paid) and downloaded. Here is a simple way to re-download all your Apps into iTunes library.
  • First you need to authorize your computer in iTunes, if you haven't already. 
    • Store > Authorize Computer
      • Note: If you have already reached your 5 computer limit call iTunes Customer support to get your computer authorized on your account.
  • Next, check for available downloads 
    • Store > Check For Available Downloads

iTunes will then check for what apps you have purchased before, and will give you an option to re-download your purchased apps or it will just show you all Apps and show updates that you need to download which essentially seems to re-download all the Apps with the latest versions available.
Posted by at No comments:

How to re-download all Apps from Apple AppStore in your iTunes library?

Have you ever been frustrated after a backup/restore process when iTunes library is missing all the Apps you have purchased (free or paid) and downloaded. Here is a simple way to re-download all your Apps into iTunes.

  • First you need to authorize your computer in iTunes, if you haven't already. 
    • Store > Authorize Computer
      • Note: If you have already reached your 5 computer limit call iTunes Customer support to get your computer authorized on your account.
  • Next, check for available downloads 
    • Store > Check For Available Downloads

iTunes will then check for what apps you have purchased before, and will give you an option to re-download your purchased apps or it will just show you all Apps and show updates that you need to download which essentially seems to re-download all the Apps with the latest versions available.

Posted by at No comments:
Labels: ,
Subscribe to: Comments (Atom)