Tuesday Tip: Excel Keyboard Shortcut

by Tony Rushin

If you never use Excel then save your time: this tip isn’t for you.

If you’re like me, you use Excel on a regular basis.  I use it weekly, if not daily, even if I’m not seriously crunching numbers.  I’ve been using the same Excel shortcuts for years so when Steve Guthman, IT Director at Quantum Radiology, recently sent me an email entitled “Excel tip – One of the Most Forgotten Shortcuts, for a future blog”, I was intrigued.  I’ve been using Steve’s tip for several weeks now; it’s definitely a time-saver.

Thank you, Steve, for sharing.  Here’s his tip just as he sent it to me:

F2: Edit a cell in Excel

Forget the clumsy task of clicking in the formula bar when editing a cell in Microsoft Excel. Instead, press F2 and you’ll be editing the cell right in the spreadsheet where the cell is.

Once you’re editing a cell, you can use the standard navigation keys (Home, End, Ctrl+Left Arrow, Ctrl+Right Arrow) to get to where you want, then press Enter to accept your changes (or press Esc to cancel).

For example, suppose you need to change the number “151,000″ into “15,100.” Don’t retype it! Just press F2, then press Backspace to get rid of the extra zero, then press Enter. Done!

F2 saves me hours each week!

That’s all there is to it… have fun!

Network 1 Consulting is a 14-year-old, IT Support company in Atlanta, GA.  We become – or augment – the IT department for professional services companies: law firms, medical practices and financial services firms.  Our IT experts can fix computers – but what our clients really value is the industry-specific best practices we bring to their firm.  This is especially important with technology, along with regulations and cyber threats, changing so rapidly.  We take a proactive approach to helping our clients use technology to gain and keep their competitive advantage.

Tony Rushin Headshot

Tony Rushin: In his role as VP of sales & marketing, he is responsible for hiring, managing and coaching the sales team and always staying on top of (and meeting) the needs of clients. Under his leadership, the company has steadily grown each year.

Network 1 designs, builds and supports the IT you need to run your business more securely, productively and successfully. Whether you want to outsource all of your IT needs to a reliable, responsive, service-oriented company, or need to supplement the work of your internal IT staff, we will carefully evaluate where you are now, discuss where you want to go and implement and support a plan to get you there with as little interruption as possible.

Leave a Comment

Related Posts