Online PC Support

OPS Technical Solutions : +1 833-522-1003

Welcome

How to Restore Microsoft Excel to Its Default Spreadsheet

Microsoft Excel is used as a spreadsheet tool for performing calculations, analyzing data and integrating information.

Here are some of the basic steps to restore the default settings in spreadsheet:

Step 1:

If you want to restore Microsoft Excel to its default Spreadsheet, you can go to my computer then Documents and Settings folder, open your username and then Application Data, Microsoft and finally the templates folder then rename the book and sheet files to something that you will remember. Always remember that you have to save the settings for later use, either move or delete them if you don’t want to use the template.

Step 2:

Now open Microsoft Excel and locate the options settings under the Tools menu, then click the General tab and after that note which folder is listed at Startup, now open all files in, minimize or close excel  and navigate to the folder listed in that box.

Step 3:

After all these actions now delete any existing files in that folder, save them if you want to use them later, to save you can rename the template using a name that you will remember.

Step4:

Reopen Microsoft Excel to verify the settings returned to default. If you face the same problem again then you can either repair the complete Microsoft Office application or just MS Excel tool. Re-installing MS Excel can also resolve the problem and it is also safe step as it is not going to delete or affect any existing MS Excel data and files.

These basic steps can help you to restore the basic or default manufacture settings of MS Excel which might have been corrupted due to any reason. By these settings you can Restore Microsoft Excel to its default Spreadsheet, and you can easily do your work again as you want. The steps mentioned above do not require any hardcore computer knowledge and can be performed by any laymen as well.

Tips to Back up your data on Urgent basis

Computers have become a part of our lives. We rely so much on them that we seldom keep hard copies of important documents, pictures etc in our cabinets and just stay comfortable if we have them on our computer’s hard drive. But what if the hard drive goes bad? What if the computer which has important data gets lost or theft? If something of this sort happens to your computer than the first question which anybody will ask you will be – do you have the backup? If your answer to this question is “Yes”, then there is no panic, but if the answer is “No”, then you will find yourself in serious trouble. One should always keep in mind that the computer system is yet another electronic device and is ought to fail at some point in time. It is just a piece of expensive commodity and can be stolen or get lost. One should always be prepared for such cases if they happen. In this post we will tell you about the backup techniques so that you at least have a copy of your important data in such scenarios.

There are many ways and data storage techniques by which you can keep a copy of data safe at some other place. Let’s discuss some of them which are most widely and commonly used.

External Drives: External drives are the best and the most commonly used mode of taking the backup. Backup and restore technique may be different but people mostly rely on external drives. This kind of backup can be taken on DVD Disks, CD Disks, Tape Drives (Rarely used now), External Hard Drives etc. whatever the drive type be you should always keep a copy of your important data at some other place for restoring it back in case of any mishap.

Online Backup: This is another widely used and accepted mode of keeping the data safe. This is done by saving the data at some third remote location which is a server or data storage service provider’s computer. There are many online data backup service providers available now and they charge a very nominal price for providing this service to you. Charges are proportional to the amount of storage space you acquire on their servers. Larger the space, more the amount they charge.

Network: If you computer is on a Network then the best way to safe guard your data is on the network share drive. This enables you to  share space allocated to you which can only be accessed by you and you can keep your data safe on that space. Servers are generally kept in secured, water proof, fire proof vicinities and chances of your data getting lost from there is very low.

Above I have mentioned the places where you can save your data; now let’s see what all data you should backup.

Personal Folders: Folders like Desktop, and Documents are the ones on which we keep the maximum of our personal data. If your computer is shared by others as well then Desktop and Documents are the folders which stay private and others don’t get access to them. Generally we keep are personal files and folders on these two locations so backup of these locations is really important.

Emails: These days the maximum of communication happens only on Emails and of you are using any Email client like Outlook or Outlook Express then backup of Emails is also very important. If you do not use Email clients then there is no need of Email backup because they are already safe on the Email Server.

Lastly since its your computer so you are the best one to tell what is important and what is not. So whatever is important should be backup up on regular basis to avoid such situation.

12 tips for creating better documents

Earlier people used to inscribe on the skins of animals to convey the messages and at that time, this was a kind of documentation. As time evolved man started using paper and pen. To add more flair nowadays we use our computers for documentation. We can not only convey our message with precision but also we can give a better touch to them with the help of our computer.

A dozen tips for better documentation will help you through.

Tip one

Be precise in your decision when you choose content for your document. If you flock up a bunch of excerpts or graphics, page starts looking quite chaotic and difficult to understand. So, be precise and selective when you are choosing content for your document.

Tip Two

You can choose a theme for your document. Theme in general encompasses page layout, font style, font colour, clip art and graphical effects. The MS office has same theme for Microsoft Word, Microsoft Power point and Microsoft Excel.

Tip three

You can style your document as per your desire. You can apply a certain font size and font colour to your text. You can also make the words of your document Bold, Italicised and can also underline a word or sentence as you ought it to be. This way you can give a format to document and thus, provide them consistency.

Tip four

You can also give your document a new definition by giving it graphical touch. Do not worry you not required to be an artist, but your computer will do so. You can arrange your thoughts in the form of flow charts, pie charts or in Numbered or Bulleted form. You can perform such task by accessing you Microsoft Word, Power point or Excel.

Tip five

You can increase the appeal of your content making it more presentable. But, how can you compile your work in such a way. Do not worry, allows Microsoft Word to do so.

Tip six

You can provide your document with different page layouts and thus, it become better to look at. You can create table in which you can easily allow your content flow. Tables and different shapes can be created and page layout can be done simply by your Microsoft Word.

Tip seven

If you reckon you are using certain terms which may not understood by the reader. Then you can provide footnotes for the latter or a kind of elaboration for important points or words.

Tip Eight

An appendix can be given to your document, if you think footnotes or inline details are becoming quite long and giving a wired look to your document. The appendix is the table which you can find at the end of your document and it can be identified by the reader as the content will have its page number and details.

Tip Nine

You can run a spelling or grammatical error check on the Microsoft word, once you’re done with your document.

Tip ten

You can also change your paragraph alignment form left to centre and from centre to right in the Microsoft Word.

Tip eleven

If the content deals with something related to Statistics, then you can create colourful bar graphs.

Tip twelve

You can use “Paste Special” tab instead of the “Paste” command. This way you can look after the tables, text and graphics.

How to Create a PDF or adobe Acrobat file

An adobe or acrobat file is also known as PDF file. Adobe acrobat files are one of the highly popular and standard ways to distribute and exchange electronic documents and forms around the globe. There are various reasons for the popularity of this application like it takes very less space as compared to its competitor ,it allows your document to remain durable and unaffected by others and give you a feeling of great safety and it also allow others to read and view your document negligent the format of the document.

Steps to create an adobe acrobat file


There are some tools available online to create PDF or adobe acrobat files. These applications or tools are very easy to use. You just have to stick with these instructions:
We have some easy n very convenient instructions for you to use these applications.  At first you should know about CutePDF and to create PDFs in your operating system you just need to go to Cute PDF website and download it. After downloading, install this application and one important thing you must know because this is a web based program you have to be contacted to internet.

Now open the document from the file menu in the web browser you are using and click “OK’. Now just click on the “print” tab and after clicking this button the “print window” will appear. Now choose printer as “CutePDF” and click “print”. The creation of PDF is done now choose the location where you want to save this file and click on the “save” tab, now it will save the file to the location you specified.

We have two more tools, these tools are easy to use and user friendly. Now we tell you about ghost script: as we told you all these applications is web based application.  You have to be connected to internet, now click “download” and after that click “install” the GhostScript application. After installing this application, you just open the GhostScr  ipt program and just click on the “file” tab now click “open” and select the file you want to convert into PDF. After this you save the file by selecting the file type as PDF.

How to place these adobe acrobat files on Internet

Now you want to place this newly created adobe acrobat file on web. Follow these steps to do so: go to programs and open adobe acrobat program, now click on the file tab and open file option. After selecting the files, click on the tools button, now select web link and create the file. It made all the URLs by default. If it will not create URLs then select the pages you want to create. After doing all this, resave the pages.

Basic Aspects of File Sharing in Windows7

File sharing is all about distributing data that is stored digitally. This data can be music, video, documents, photos and electronic books. There are file-hosting services to share files. These services use email, blogs or other Internet collaboration means that will allow them to insert links for downloading. Windows7 has come up with a straightforward solution for file sharing. By using this technique you can share files with anyone at home or office; procedure will be different though.

File sharing on home network

Firstly, you must create a homegroup or be a part of it. In homegroup, computers, which are members of it, share documents, videos, music and other files. Printers are even shared among homegroup. Windows7 PC is as major requisite for homegroup participation. While linking up with homegroup or creating one, it asks for libraries or folders that you want to share. You must specify folders that are to be shared and files that you want to keep private. Fastening of appropriate settings is the thing of Windows’ concern. Exception of yourself, no one has any authority to change settings customized by you. By using password of your choice, you can protect your homegroup from any strangers. This password is changeable at any time.

As we talk about compatibility of Windows7 editions, all editions of it such as Ultimate, Enterprise or Professional, support homegroup. You can join or create homegroup in all editions except Starter and Home Basic editions; in them you can only join homegroup cannot create one. On joining homegroup, computers working on domain can access files that are shared by others but cannot share any.

File sharing with anyone of your choice

Homegroup is the best way to share files automatically among that particular group. But what if you want to share files with others that are not from homegroup? Windows7 offers solution for it by serving ‘Share with’ menu. This menu allows you to select preferred files or folders and share them with others. Options of this menu vary with the type of network in use and type of file that is being selected. Generally there are following options.

  • First option is ‘Nobody’. By selecting this option you can make a particular file private. Nobody can access it except you.
  • Second is ‘Homegroup (Read)’ that enables you to share file with homegroup; but read-only permission is must for this sharing. This read-only permission allows recipient only to read file; he cannot make any changes in that file. Recipient is not allowed to delete that file even.
  • Third is ‘Homegroup (Read/Write)’ which is same as ‘Homegroup (Read)’; but in this case, read/write permission will be sufficient for sharing. With this read/write permission, recipient can do anything with that file. File can be read, modified or deleted even.
  • Lastly, there is ‘Specific people’ with which you can select people precisely in File Sharing Wizard. Sharing is done with these specified people only.

Shared documents

You can easily check files or folders that you have shared. In Windows7, these details are given in Windows Explorer. You can go to Windows Explorer by clicking on ‘Start’ button and then user name specified by you. On selecting any folder, you will see all the information at the bottom of screen. It will tell you if that file is shared and if it is shared, it will also provide information about recipient.

Public Folders

As a ‘Share with’ option makes sharing effortless, there is one more option named ‘Public folders’. Like drop boxes, this Public folder makes all files or folders available to other people when you copy them to this folder. These Public folders are present in each of your libraries for instance Public Videos, Public Documents, Public music etc. Sharing on Public folders must be turned on before sharing since it is off by default. It is a useful technique for sharing some documents with several people as it holds record of shared files. Unfortunately, these folders do not allow you to protect some files in them. Either you have to hide all files or none of them. But if that much flaws are considered, option of Public folders is not that bad for sharing.

There are various ways to share a file between different users and to use them effectively you must be aware of basic knowledge required for it.

What is System Restore?

System Restore and Its Features

One day, you are minding your own business, doing some work online or just listening to some music, when you are suddenly faced with cricket-noise-inducing silence and a blank screen. Maybe you’re watching a video that you waited patiently to download and a few minutes into the opening credits the movie pauses, along with your whole screen. Those are just some of the problems that will require you to use the System Restore in your Windows operating system.

What System Restore Can Do For You

System Restore will assist you in restoring the computer system to an earlier point when it was working at its optimum efficiency. This is the system’s version of an undo that will not affect your personal files like emails, documents or photos.

Certain installations of some programs and drivers might cause some unexpected errors or changes in your computer which will cause Windows to behave in an unpredictable way. Uninstalling the program often corrects the driver problem but a System Restore will undoubtedly help make the process of restoring the computer faster. It will return the status of your computer to an earlier date when it was working properly.

System Restore has a feature called system protection so you can regularly create and you can even save restore points on your computer which you can choose from. These certain restore points have information about registry settings and other system information that Windows will use. You can create restore points manually apart from the computer’s own saved restore points. You can find information about creating restore points on the option Create.

You can use the system image backups that were stored within the computer’s hard drive for your System Restore which are similar to the restore points that were actually made by system protection procedures. System image backups may contain both your system files and personal data, but your files will not be affected by System Restore. If you need to know more about system images you can find out on ‘What is a system image?’

If you plan on backing up files, System Restore is not what you need. It will not aid in recovering personal files that have been deleted or damaged. You are responsible for backing up your personal files and important data using a backup program. If you need more information regarding the necessary backing up important personal files, look at the Back up your files option.

Simple Ways to Enable System Restore

You can access System restore if you click the Start button. Using the search box, type in System Restore, after which you will see the results where you can click System Restore. You might be prompted for an administrator password and in this case you should type it to provide confirmation. You can see more information about system protection on ‘What is system protection?’

This information will help you in knowing what to do in case you come across problems during installation or downloading of foreign files. By being informed, you can make the process of maintaining your computer at its optimum level of performance.

Call Now: +1 833-522-1003
Call Now: +1 833-522-1003
Call Now: +1 833-522-1003