Some useful Excel shortcuts

Here’s some useful Excel shortcuts, which I’ll add to as I find more useful ones.

One of the main ones I’ve found is Insert a New Row – without a shortcut this is an extremely clunky operation of selecting the current row using the mouse and then selecting to Insert a new row in one of several ways (right-click menu or Ribbon Menu or shortcut key) There doesn’t seem to be a one-step shortcut for Inserting a New Row, but there is a two-step shortcut, see below.

Insert a New Row

1) Shift + Spacebar Select current row
2) Ctrl + ‘+’ Insert row
(On my Asus laptop I have to actually do Ctrl + Shift + =/+ key)

Other Useful Shortcuts

Ctrl + ; Insert current date
Ctrl + : Insert current time
Ctrl + ” Copy value from cell above
Ctrl + ‘ Copy formula from cell above
Alt + Enter Start a new line in same cell
Ctrl + Spacebar Select entire column

Useful Excel Shortcut Links

http://www.ddmcomputing.com/excel/keys/xlsk05.htm
http://www.asap-utilities.com/excel-tips-shortcuts.php
http://excel-tips.blogspot.co.uk/2005/08/insert-new-row-or-column-excel.html

Pat has been absolutely incredible at testing each of our projects he works on. He’s very professional, organised and diligent. I look forward to using him again in the future.

Oliver Thurtle, Director of Technology, Drum

Pat performs comprehensive website testing for us, across all the main browsers and platforms, including mobile devices. His flexible approach to testing and clear feedback enable us to have confidence that the business end of our website is still working smoothly after system updates and changes.

Steve Liu, Manager, Wicked Lasers

We’ve worked with Pat Walsh on a number of very different projects, from interactive video projects to mobile apps. His work is very thorough and has quickly become an essential and important phase of all the production work we do at Storythings. He’s thorough, diligent, and a pleasure to work with.

Matt Locke, Director, Storythings

Pat Walsh fixed my site within hours of my contacting him – his WordPress website fix service clearly works!

Douglas Green, Douglas Software

Pat is an excellent one-stop-shop for testing Apps and Websites. He is a self-starter who just knows what needs to be done and gets on with it, and is responsive to requests for any specific testing requirements. He provides test plans and reports as a matter of course and was a pleasure to work with. I will definitely be working with Pat again if the opportunity arises.

Andrew Birley, PM, Storythings

Pat came to Composed to respond to our (increasingly urgent) need of QA on mobile and web and I can testify he more than fulfilled the task. On the Android side, his very structured approach (first exploratory testing, then focus on defining test plans for a variety of scopes) and his clear knowledge of the latest mobile technologies have quickly paid off. He was involved directly with the developers (including myself) and this very dynamic relationship enabled us to annihilate bugs swiftly and efficiently.

David Ferrand, Android Developer, Composed

Couldn’t recommend Pat highly enough. He goes beyond what you’d expect of a QA tester, commenting more broadly on user experience and even design. He’s quick, efficient and thorough – couldn’t ask for any more.

Rob Calvert, Director, Click

We hired Pat to help with QA of a music streaming app. We needed someone with that magic “6th sense” of where the bugs are lurking; the ones which developers tend to miss. Pat more than fulfilled this need, with highly methodical approach and a great eye for detail.

Subsequently Pat has provided QA services for a personal app project of mine, finding a significant issue which had been lurking for some time.

Pat is a real asset to any team – highly competent technically but also easy going and a great guy to work with. Highly recommended!

Andrew Ebling, Head of App Development, Composed

Pat Walsh provided Kingston Valdes with a professional and personable service that was excellent value. The site was built and tested quickly, we are delighted with the results, and we have already had positive feedback from some of our clients. If you’re thinking of building a new site or adapting an existing one, I’d certainly recommend speaking with Pat about it.

Kathy Valdes, Kingston Valdes