How to Set Password to Protect Excel Workbook and Specific Cells

Posted on April 16, 2013 by admin

In some occasional situations, you may want to set password to protect the Excel workbook and prevent other people from copying, changing or editing cell data. For example, you just create an Excel workbook and do not want others open it, you may need to set an open password; or only want others open the Excel but not change data in the Excel, you can set password to let the Excel Workbook to be read-only; or you just want to protect specific cells.

Protect specific Cells

Step1, select the cells you want to protect > right click and choose Format Cells.

Step2, Click the Protection in the Custom Lists > check Locked option to protect selected cells. Below the Hidden, you will see a sentence: Locking cells or hiding formulas has no effect until you protect the worksheet. So we go to step3 to set password to protect the worksheet.

 

 

 

 

 

 

Step3, click Review tab > go to Protect Sheet > type password to protect the sheet.

 

 

 

 

 

 

 

 

 

 

Secure Excel Workbook

First method: From the above image, we will find the Protect Workbook is just next to Protect Sheet, click it > go to Protect Structure and Windows or Restricted Access, which needs a Windows Live ID to register this service. Or use other ways to set password to protect Excel Workbook as below.

 

 

 

 

 

 

Second method: Click Office button > go to Save As > on the Tools menu, click General Options.

  • If you want users to enter a password before they can view the workbook, type a password in thePassword to open box, and then click OK.
  • If you want users to enter a password before they can save changes to the workbook, type a password in the Password to modify box.

 

 

 

 

 

Third method: Just as to set password to protect Word documents, you can also use that way to set password to protect Excel workbook:

Step1, click Microsoft Office button, point to Prepare, then click Encrypt Document.

 

 

 

 

 

 

 

 

 

 

 

Step2, in the Password box, type a password, and then click OK.

Step3, in the Reenter password box, type the password again, and then click OK.

Step4, to save the password, save the file.

You can set password to protect your Excel workbook or specific cells with any way above. And if you have other ideas on protecting Excel spreadsheets, please leave your advice in the comments.

Posted in Tutorial, useful info | Tagged , , , | Comments Off

Rumors: Apple may delay the debuts of iPhone 5s and next iPad mini

Posted on April 12, 2013 by admin

Ming-chi Kuo of KGI Securities, who has a strong track record in revealing Apple’s future product plans, shared a research note on Thursday that suggested Apple’s so-called “iPhone 5S,” a rumored low-cost iPhone, and a second-generation iPad mini will all launch later than market consensus expects.

Kuo has previously forecasted earlier in January about Apple’s entire 2013 product lineup, said that new iPhone, iPod, iPad, Mac would be released in this autumn. He was targeting a June/July for new iPhone models, with a version specific to China Mobile arriving a bit later in September.

According to Kuo’s report on Thursday, these apparent delays are driven by a variety of issues:

  • Fingerprint sensor for iPhone 5S. Work on finding the right color coatings in order to prevent interference with the sensor offers a technical challenge for Apple, and software integration in iOS 7 will also require additional work.
  • Color coatings for lower-cost iPhone. Apple’s lower-cost iPhone has been rumored to be arriving with a plastic shell in a number of different colors, and Apple’s efforts to keep the shell as thin as possible will likely lead to production ramping issues for coatings and surface treatments.
  • iPad mini Retina display. Kuo expects the second-generation iPad mini to adopt a Retina display, and technical challenges related to its design and manufacture are likely to slow Apple’s release timetable.

Kuo does not provide a new specific target date for the launches of the updated models, instead laying out a series of three scenarios modeling how Apple’s shipments could be affected based on August/September, September/October, and October/November timeframes.

As a result of these issues, Kuo said it’s likely that Apple will see single-digit growth in iPhone and iPad shipments in the third quarter of 2013. That would be well below the market consensus, which sees Apple growing its sales by between 30 and 40 percent with the introductions of new products.

Kuo’s report comes as Morgan Stanley’s Katy Huberty has released her own report projecting new iPhone launches for September following an iOS 7 preview at Apple’s Worldwide Developers Conference (WWDC) expected in June. Huberty projects that Apple will show off a new “killer app” such as mobile wallet at WWDC, with the new iPhone and iPad hardware following several months later.

Posted in Tech News | Tagged , , , , | Comments Off

How to Protect Word Documents with Password or Remove the Password to Unprotect

Posted on April 9, 2013 by admin

Sometimes, you want to set password to protect the Word documents from being opened or modified by other people. If you are using Office 2007 Suite or Word 2007, you’ll find it is really easy to do this.

Set password to protect Word document:

1. Click the Microsoft Office Button, go to Prepare, click Encrypt Document.

 

 

 

 

 

 

 

 

 

 

 

2. Type a password in the Encrypt Document dialogue box, then click OK.

 

 

 

 

 

You can type up to 255 characters. By default, this feature uses AES 128-bit advanced encryption. Encryption is a standard method used to help make your file more secure.

3. In the Confirm Password dialogue box, in the Reenter Password field, type the password again and click OK.

With a password preventing other people opening your Word document, you yourself also need to enter the password every time you want to read it. So, it is a bit trouble sometimes and you want to remove the password to unprotect the Word:

1. Open the Word with password.

2. Click the Microsoft Office Button, point to Prepare, click Encrypt Document.

3. In the Encrypt Document dialog box, in the Password box, delete the old password, and then click OK.

4. Save the Word document.

Then you will not be asked to enter a password to open it.

These tips are useful for Office 2007 users, but it is a little different in Office 2010 to set password to protect the document in the first step: click the File tab, go to Info, click Protect Document, then click Encrypt with Password. Then do as above to set password to Word 2007.

 

 

Posted in Tutorial, useful info | Tagged , , , , , | Comments Off

How to Set Password to Protect PDF Files with Adobe Acrobat

Posted on March 29, 2013 by admin

Adobe PDF are one of the most popular file formats, according to Google, there are 667 million PDF files created and used in the worldwide. For sharing information and exchange documents, PDF is absolutely the most appropriate file format, its high compatibility, and strong encryption, make it more and more used in many fields. But there is a problem, you do not want other people to copy or change the PDF contents. So you want to set password to protect your PDF files.

If you have installed Adobe Acrobat Pro/Stand (not Adobe Reader version), you can follow below steps:

Step1, click Secure and open the drag-down list. Then choose Password Encrypt to open the password setting box.

 

 

 

 

Step2, set password to protect PDF files. There are two types of PDF password – Open Password: to prevent other people from opening your PDF documents. This is only used for those very confidential cases that you don’t want anybody else know the PDF content or some PDF ebooks sold on the internet; Permissions: usually called Owner Password. If you do not want others make any changes but only printing allowed, you can set PDF password as below: Print Allowed – High Resolution; Changes Allowed -None.

But if you have created a PDF form, like a job application which every candidate needs to fill in personal information, you can set the Changes Allowed to let others Filling in form fields and signing existing signature fields.

 

 

 

Of course, other settings are allowed as your specific need, as Adobe Acrobat are a professional PDF tool. But there is a drawback for this application, it’s too expensive, costs hundreds of dollars, not affordable for most of us. If you have not enough budget, you may try this PDF creator, which allows you to set password while creating PDF from other printable files, but much cheaper than Adobe Acrobat Pro.

 

Posted in Tutorial, useful info | Tagged , , , , , , | Comments Off

Six Regular Lucky People Got Invited to Use Google Glass

Posted on March 27, 2013 by admin

Maybe every one has heard of Google Glass is dreaming of getting an opportunity to try Google Glass.  After almost one months of Google’s calling in appropriate person to be the first to use the Glass, Google announced the six lucky ones, who can buy Google Glass device for $1,500.

They are:

  • Sarah Hill (Columbia, MO) would take Glass to a VA hospital and let veterans see their war memorials

  • Herschel Taghap (Seattle) would show people what it’s like to be a line cook in a restaurant

  • Shannon Rooney would travel to Japan and help her Grandma re-experience her homeland without leaving her home in the U.S.

  • David Moriarty: improving doctor-patient interaction for clinical trials

  • Anthony Brown (San Francisco, CA) is a zookeeper who would show penguin feedings with Glass

  • Max Wood (Gray, GA) is a firefighter who would improve fire safety by using pre-fire planning maps

Congratulations for these six lucky gays or gals.

If you really want to get a Google Glass, you may keep on paying close attention on the Glass Project.

Posted in Tech News | Tagged , | Comments Off

Eleven Google Products and Services You May Never Know Existed

Posted on March 22, 2013 by admin

As a giant in Information Technology industry, Google is famous for its search service, which hold more than 65% market share in US and world wide. We also know that Android is one of the most popular mobile system developed by Google and YouTube is the most amazing video website owned by Google. But you may never know these 11 products and service that Google has involved in.

1. Google Mars

Google Mars is just like Google Earth except this program lets you explore the red planet.

 

 

 

 

 

 

 

 

2. Google Scholar

Google Scholar is a search engine for scholarly articles. Scholar is pretty expansive, letting you access articles, theses, books, abstracts and court opinions, from academic publishers, professional societies, online repositories, universities and other web sites.

 

 

 

 

 

 

 

 

3. Google Art Project

Google Art Project is a site that lets users takes virtual tours of museums and art galleries, similar to Google Street View.

 

 

 

 

 

 

 

 

 

 

4. Google Transliterate

Google Transliterate is a service that helps users type in a different language.

 

 

 

 

 

 

 

 

 

5. Build with Google

Build with Chrome is a partnership between Google Australia and Lego. The project is a way to show how Google’s Chrome web browser can display 3D images. Users can build their own 3D Lego structures too.

 

 

 

 

 

 

 

 

 

6. Think of Google

Google Think is a site for advertisers and similar professions to get marketing insights and inspiration straight from Google.

 

 

 

 

 

 

 

 

 

7. Inside Google search

Power Searching with Google is a feature that sharpens users search skills. Google’s search experts offer tips and tricks to better navigate the search engine and help you find exactly what you’re looking for.

 

 

 

 

 

 

 

 

 

8. Schemer

Schemer is a network that helps plan things to do with your friends. The service works especially well in densely populated areas.

 

 

 

 

 

 

 

 

 

 

9.  Google Sound Search

Google Sound Search is a service that is similar to Shazam that tells you what song is playing.

 

 

 

 

 

 

 

 

 

1o. Google Moderator

Google Moderator is an open forum for discussing topics, asking questions, and sharing ideas. Moderator helps anyone receive feedback on anything they want.

 

 

 

 

 

 

 

 

 

11. Google Encrypted

encrypted.google.com is a more secure way to search for things. Encrypted uses Secure Sockets Layer (SSL) which is the same security that banks use online.

 

 

 

 

 

 

 

 

Posted in Tech News | Comments Off

How to Add Header and Page Number in a Word Document

Posted on March 19, 2013 by admin

In order to well organize Word document content and basically introduce the main content of each chapter, we would like to add header and page number in a Word document. But some times, people may come cross a problem: the header and page number can not be inserted on the top of Word document at the same time, when adding header, the page number disappears and vice versa.

Actually, this question can be easily fixed with below steps:

Step1, open the Word document;

Step2, go to Insert Tab and find Header & Footer option. You can choose to insert header or page number, in this article, I would like to insert page number first, so I choose Page Number from the options and want to add the page number on Top of Page. Of course, you can add page number at the bottom of page and set other customization, like page margins and position.

 

 

 

 

 

Step3, edit page number in the opened Design tab. And you can also add header in the Header section, like below image,

 

 

 

 

 

Step4, click “Close  Header and Footer” to quit after adding the header and page number.

It is really easy to add header and page number in Word document, isn’t it? Just within 4 steps, you can do this in seconds. And if you meet a situation to insert the header or page number, you can follow above steps.

If you have any advice on adding header and page number in a Word document, please leave your comments.

Posted in Tutorial, useful info | Tagged , , , , | Comments Off

Google Reader Will Be Retired, Here Are Some Alternatives

Posted on March 14, 2013 by admin

After released for eight years, Google Reader is inevitably shut down by Google, due to the product’s usage was declined by years. The popular of social network site, like Twitter, Facebook, and other news apps have lead the downfall of RSS feeds. But if you are used to RSS feeds reading, there are some alternatives for the retired Google Reader.

1. Flipboard 

Flipboard is already an immensely popular newsreader and social-network hub, it has no desktop or browser-based component, but it is compatible with both iOS and Android. So, no matter what kind of devices you have, an iPhone or an Android smartphone, you can use it to organize the info you want to look at and then flip through it like a magazine.

2. Feedly

One of Feedly’s most popular features is that it can sync with Google Reader. Thought this feature will soon be useless, we can find that Feedly is also a top-north RSS reader. You can not only subscribe sites of exited categories, but you also can search any sites within Feedly for subscribes. Besides, it supports iOS, Android, and desktop.

3. Pulse

Pulse News gives you all the news from your favorite feeds with an intuitive interface for touch screens. It is an intuitive app, you can recorder the feed list to show your favorite and most-read sites after launching it. And you can even add Facebook to your feed if you want to know the latest news from friends. It works on iOS, Android and Web.

4. Taptu

Taptu gives you a visual interface for browsing news feeds, a lot like Pulse (see above), and also lets you add your personal Twitter and Facebook feeds. And it is great to tailor the news to your specific needs according to your customs. Compatible with iOS, Android and web.

 

5. Google Current

Similar to Flipboard, Google Currents employs a magazine-style interface with large images and paginated posts. It lets you subscribe to and download app-optimized editions of publications like Forbes and CNET, and you can subscribe to any RSS-enabled sites you like, just like with Google Reader. It only works on iOS and Android now, not for desktop.

6. NewsBlur

NewsBlur is also a great option, with an interface that’s very similar to Google Reader. You create an account, subscribe to your favorite sites, and read them on any computer. They even have Android and iOS apps that’ll sync your feeds, too.

 

All of above news RSS are totally free, only NewsBlur charges if you want to subscribe a premium account.

What apps are you usually using for news reading? If you have other options, please do leave your advice in the comments.

Posted in Tech News | Tagged , , , , , , , , , , , , , | Comments Off

How to Print Out One Page from a File?

Posted on March 12, 2013 by admin

In our daily life and work, it is common to print out a file to hard copy. So, many people may meet this situation: How to print out one page from a file? As you only need a specific page from a large multi-pages Word, PowerPoint or PDF document.

In this article, I will tell you some tips to extract one page from a file and print it out.

First, open the file you want to print, let’s take a PDF file for example.

Second, go to File and select Print to open the print options box.

 

 

 

 

 

 

 

 

 

Third, choose the page to be printed. You have two ways to choose the page: one is to go to that page and then check up Current page in the Print Range field; the other is to specify that page you need to print out in the Pages option, just enter the page number of that page.

Fourth, click OK to proceed to print out one page from a file.

Just in four simple steps, you can do this in seconds. Another tips: You have to choose the correct Printer in the Printer Name field;  those printer showed on the above picture is not real printers, only some PDF tools to print files to PDF format on the computer, not print out a file from computer to real paper.

Posted in Tutorial | Tagged , | Comments Off

The Only Smartphones You May Want to Have One

Posted on March 5, 2013 by admin

On the MWC (Mobile World Conference) last month in Barcelona, many mobile giants show   off their upcoming newest gadgets for the spring and summer release cycle. In the pageant, We can find a lot of interesting phones that will be launching soon. And BI have ranked some top smartphones for you if you are gonging to buy one, just check to find if your favorite is in the list.

1. iPhone 5

For most people, the iPhone 5 is the best smartphone you can buy. It has an interface that’s more accessible and easier to use than Android phones, plus you’re guaranteed to get the best apps and content.

 

2. Samsung Galaxy S III

All things considered, the Galaxy S III is still the best Android phone you can buy. Bottom line: If you want a phone with a large, brilliant display, consider this your first option.

 

3. Google Nexus 4

Getting the Nexus 4 ensures you’ll always have the latest Android updates and features first, so you don’t have to worry about the manufacturer or carrier to update your phone.

 

4. HTC Droid DNA

Verizon and HTC worked together to launch the Droid DNA late last year. It has a brilliant 5-inch display that can play full 1080p HD video.

Since the HTC One won’t be coming to Verizon, the Droid DNA is your best bet on the carrier if you like HTC products.

 

5. LG Optimus G

On paper, LG’s new Optimus G is one of the most powerful smartphones you can buy today. It’s not the prettiest phone, but it’s a good option if you want a lot of horsepower.

 

6. HTC Windows Phone  8x

If you’re interested in Microsoft’s Windows Phones, HTC’s Windows Phone 8x is the best one you can buy. It has just about all the great benefits as Nokia’s Lumia 920, but in a thinner and lighter package. Plus it’s just a gorgeous device.

7. HTC One X+

HTC’s One X was one of the best smartphones to launch in 2012. HTC released an updated version called the One X+ last fall that had a faster processor and a few other advanced features.

8. Samsung Galaxy Note II

The Galaxy Note II is a large Android phone with a 5.5-inch display and a stylus for doodling or writing notes. If you want a giant screen on your phone, this is probably your best choice.

 

9. Nokia Lumia 920

Nokia’s Lumia 920 is one of the first two phone to run Windows Phone 8. Most consider it to be the flagship Windows Phone.

The Lumia 920 is a capable device, but be warned that it’s extremely thick and heavy compared to other top-tier phones out there.
10.  Samsung Ativ Odyssey

The Samsung Ativ Odyssey is the company’s first in the U.S. to run Microsoft’s newest mobile operating system, Windows Phone 8. It’s not the best Windows Phone available, but it certainly won’t crush your wallet

11. iPhone 4S

The iPhone 4S is still a great device, but it’s starting to feel rather dated compared to the other great stuff coming from Apple’s competitors.

What is your choice? Is your favorite phone in the list? If not, which brand and which series do you like? Please post your comments below.

Posted in Tech News, useful info | Tagged , , , , , , | Comments Off