You are here > News Letters

    Did you know? Hundreds of dollars can be saved with "Fax by Automation"                                                                                       Did you know? Outlook Forms can be used to provide a seamless and paperless "Approval Process"
What our clients say?

Microsoft Excel Shortcuts
  
 
The exceptional services and the quality of deliverables at USAT saved a great deal of cost and efforts in building our software product.
 
CEO, Crane Care Inc. MI
 
Your method of analysis and approaches to problem solving are impressive. We would not be able to develop our customized operations management software without your help. All our employees are very happy with the final outcome. The product we are now using and is saving tremendous amount of  time and cost in running our business. 
 
President
GemStone Real Estate Inc. MI
 
The quality and the stability of the project management system you developed is greatly appreciated by our Project Managers around North America. We recommend USAT to any company without reservation. The continuity of your support is helping our operations. 
 
We want to thank you for your help in entire project life cycle and continued support.
 
Sr. National Ops Manager
Building Technologies division of fortune 500 company.  


 

 Microsoft Excel Shortcuts - List 1

Often you puzzled to figure out how to quickly perform a routine step while working on any application. Shortcuts are a great way of getting this done. But, it would be difficult to remember all the shortcuts on any given office application. Here are some of useful shortcuts on Microsoft Excel.  

  • Ctrl + Space will select a column 

  • Shift + Space will select a row

  • Ctrl + Arrow Key moves the cursor along a series of cells

  • Ctrl + Page Up (or Page Down) will cycle through your worksheets

  • Alt + = brings up the Auto Sum feature. Although it usually “guesses” correctly which cells to sum, if it is incorrect it is simple to fix. 

  • The F4 key will repeat the last command you performed 

  • Alt + I and then R will insert a row 

  • Alt + I and then C will insert, you guessed it, a column 

  • Shift + F11 is to insert a whole new worksheet, use  

  • Ctrl + Shift + 1 formats the cell as a number (with two decimals)

  • Ctrl + Shift + 3 formats it as a date

  • Ctrl + Shift + 4 gives you currency

  • Ctrl + Shift + 5 formats as percent

  • Ctrl + Shift + # will allow let you remove all formatting from a cell, use