Online Computer Repair - Archive for the 'Online Computer Repair Tips for Microsoft Office' Category


Online Com­puter Repair Tips for Microsoft Office

These tips can save time, sim­plify your work flow, and help reduce the need for elab­o­rate online com­puter repair services.

Microsoft Excel:

Enter Con­sec­u­tive Dates into a Series of Cells:
This one is very easy and can become quite use­ful when try­ing to out­line work for the upcom­ing week, month or year. Just enter the first date into the com­mon date for­mat (mm/dd/yy) and then move the mouse to the bot­tom right cor­ner of the cell. You’ll get a small cross, which is known as a Fill Han­dle and after that, sim­ply click and drag across all of the cells you’d like to fill with the dates. No online com­puter repair necessary.

Lock Cells from use:
This helps keep you from los­ing your work by acci­den­tally mod­i­fy­ing data that’s already been entered and is espe­cially use­ful for online com­puter repair. High­light the cells you’d like to allow for use, by either hold­ing the Ctrl key and con­tin­u­ally high­light­ing each one, or by click­ing on the high­est cell while hold­ing the shift key, then click­ing on the low­est cell. This will select every­thing in between. After the selec­tion, go to Format>Cells and under the Pro­tec­tion tab, uncheck the Locked check­box. Then click OK. Then go to Tools>Protection and select the Pro­tect Sheet option. When it asks for a pass­word it’s just optional, so don’t enter one if you don’t want to. Click Ok. When you try to write in the locked cells there will be an alert mes­sage, so real­ize that you’re not in need of any com­puter repair.

Microsoft Word:

Turn­ing off Auto­Cor­rec­tions
To turn off this auto­matic, and some­times annoy­ing fea­ture, go to Tools>AutoCorrect then click the Auto­Cor­rect tab. There will be a series of options, all of which will have boxes which you can des­e­lect, allow­ing you to cus­tomize them. This is use­ful for online com­puter repair. There’s also an Aut­o­For­mat As You Type tab under the Tools menu which has a sim­i­lar option. You can also go to Tools>Options and des­e­lect any boxes for other unde­sir­able auto­matic func­tions, like spelling and gram­mar check

Microsoft Pow­er­Point:

Mov­ing Objects Slightly
There’s a way to use the arrow keys to move objects very small dis­tances, which is par­tic­u­larly use­ful for those work­ing from a lap­top. Sim­ply select the object and use the arrow keys. This will move the object 1/12th of an inch. Very use­ful for per­fec­tion­ists and online com­puter repair.