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.