12 Time Saving Excel Tips You May Not Know About
Regardless of your profession or the industry you’re in, chances are Excel plays an important part in your daily working routine. However, even though most of use Excel at work nowadays, there are a number of tricks and shortcuts that could save us a considerable amount of time – the problem is, many people don’t know about them.
So, to help you improve your speed and efficiency in using Excel and complete your tasks faster, I have created a list of 12 time saving Excel tips you may not know about below. And, as an added bonus, some of these tips are universal, so they can be used across other Microsoft applications as well.
One of the best ways to speed up your work process and save a considerable amount of time is to use one of Excel’s many keyboard shortcuts. Although there are hundreds of shortcuts available, learning even a few of them will help you increase your productivity in the long run. Below are some of the best – and possibly most important – ones I thought you should know about.
1. Create a chart in seconds
If you’d like to add a chart to your spreadsheet, use the F11 function key, or Alt + F1 if you’re looking for a floating chart. However, always make sure to highlight your data first before using these shortcuts. This article on the Office Tool Tips blog explains how to use this feature in more detail.
2. Navigate between sheets without using your mouse
The best way to quickly move between your worksheets is to use Ctrl + Page Up for moving to the left, or Ctrl + Page Down for moving to the right. This shortcut is especially useful on a laptop or if, like me, you don’t like using the touchpad and you have lots of worksheets to deal with at the same time.
3. Jump to any cell
If you want to go to a particular cell, you can use the F5 key. This will show all the named cells on your worksheet – simply type in a reference like Z100, then press Enter.
4. Open and save excel files quickly
The quickest way to open a file is to use the Ctrl + O shortcut. Similarly, if you want to save your document, you can use either Ctrl + S, or F12 if you want to use the ‘save as’ feature. The latter opens a browser window for you to easily find your files, and allows you to either save the updated file or save it under a different name.
5. Fix formulas with absolute references
The F4 key has two main functions in Excel. If you press F4 but you’re not actually editing a cell, Excel will repeat the last action. However, it can also be used for cycling through all 4 types of cell references.
6. Double click to copy down a formula
If you’d like to continue down a formula, just double click the small square in the bottom right corner of the cell. This trick is especially useful when you have hundreds or thousands of rows using the same formula – just click the square and let Excel do the work for you.
Christy’s article on the Pryor blog explains this – and other alternatives – in more detail.
7. Zoom in and out easily
Another feature many people don’t know is how to zoom in and out. You can zoom in easily by pressing Ctrl and moving the scroll wheel on the mouse up or down. Try zooming to 25% and you will see any named ranges in the worksheet.
8. Format your cells quickly
Instead of right clicking, you can open the ‘Format Cells’ window very easily using the Ctrl + 1 shortcut. Needless to say, not only is this is a handy way to format your data cells in the quickest time possible, but right clicking, then selecting the ‘Format Cells’ option and what exactly you want are all extra mouse clicks you don’t need to do.
9. Shortcuts to everything in Excel
Use the Alt key to activate the Ribbon Tab shortcuts to every command in Excel. For example, Alt + W + VG will switch off the gridlines in your sheet so that it looks more like a report. Although this only applies to Excel 2007 and newer versions of Excel, the beauty of this shortcut is that you don’t need to remember them all, only the Alt key itself.
Other useful tips
10. Pasting across multiple sheets
Want the same data across multiple sheets? Then pre-select all the sheets needed and copy paste or type in the data and every selected sheet will have the same data on it ready for you.
11. Quickly create an excel table
Convert your data to a smart data table using Ctrl + T. This way, you will have striped rows, filtered headings, and the ability to add a “Totals” row.
12. Name cells for easy access
And last but not least, another feature that can save you a considerable amount of time and help you navigate more easily is naming your cells. For example, you can name a cell as VAT or MARKUP and if you need to get to it quickly, simply use the F5 key to go to a cell and your names will be in there.
Apart from single cells, you can also name whole tables of data, or even columns and rows. Find the ‘Name Manager’ in the ‘Formulas’ tab for creating these, or use the name box above column A. Additionally, you can use F3 to paste names into a cell or formula because in a few weeks’ time you may not remember the names you have created.
If you want some more ways to save time, there’s an interesting new section recently launched on the Activia Training website which has how-to videos and free templates for you to download.
Can you think of any other time saving Excel tips you would add to the list? Let us know in the comments below.
7 Common Reasons Why WordPress Websites Get Hacked
If there is one content management system (CMS) that’s credited for revolutionizing the modern web, it’s WordPress. Thanks to this revolutionary software, making any type of website is not difficult today. Its flexibility and ease of use make it so popular that WordPress powers as…
Manage Endpoint Security With Cloud-Based Action 1
Meet a free Cloud-based endpoint security and patch management solution from Action1 (www.action1.com). This top-ranking solution facilitates network discovery, enables you to find installed software and orchestrate software updates across all your endpoints regardless of their location. With many tools over there, you might be…
Private Practice: Crucial Services Your Startup Needs
Medical professionals around the world dream of having their own private practice. It allows more freedom for dictating your own schedule but it does come with its own set of challenges and while many are similar to those most startups face, starting a business in…
How To Keep Your Personal Information Anonymous And Secure While Using A Web Browser
Browsing the web or checking Facebook a few times a day has recently become something natural as breathing and eating. People wake up, immediately reaching for their phones to be up to date. Is it already an addiction to the Internet? Of course, it depends…
How To Stay More Secure When Using Kubernetes
Kubernetes is an open-source system for automating deployment of new apps and software, and is becoming increasingly popular due to its utility in going back to previous versions. But while lots of developers are excited to take advantage of the benefits and convenience offered by…
- 3D Printing
- App Dev
- Artificial Intelligence
- Arts and Entertainment
- Big Data
- Blockchain Tech
- Business Technology
- Car Technology
- Cloud Computing
- Cloud Storage
- Computer and Technology
- Conference Calling
- Coupons and Deals
- Cyber Security
- Dark Left 1
- Data Center
- Data Recovery
- Digital Arena
- Digital Marketing
- Edu Tech
- Email Marketing
- Google Glass
- Guides and Tutorials
- Health and Fitness
- Home Appliance
- Home Improvement
- Home Security
- Internet and Businesses Online
- Internet Marketing
- IT Careers
- Mobile Apps
- Mobile Security
- New Tech
- Online Shopping
- Project Management
- Reference and Education
- Reputation Management
- Sales & Marketing
- Self Improvement
- Shopping and Product reviews
- Small Business
- Social Media
- Tech Trends
- Technical Support
- Technology in Education
- Tips & Tricks
- Tips And Tricks
- Video Conferencing
- Virtual Reality
- Wearable Technology
- Web Design
- Web Development
- Web Hosting
8 Best Home Updates To Do In The Spring
8 Best Home Renovations To Take On In The Spring When the snow starts to melt and the weather slowly warms up, you likely have the urge to do a little work around the house. Here are some improvements to make before summer arrives: 1….
Use Android Parental Control Apps And Take An Interest In The Digital Activities Of His Children Without Blame
The screens quickly create a gap between parents and children. They limit conversations, disrupt meals, homework… Children are absorbed by their smartphones, tablets and other screens, so that they quickly become a source of tension. We use the deprivation of such a video game as punishment on…
Online Security Tips You Might Not Know About
Technology is now playing a major role in our daily lives. From how we work to how we spend our leisure time; it is central to us all now. Of course, a tech advance that has transformed our lives the most is the internet. While…
Here’s How Proxies Can Aid Email Protection
Are you concerned about your email protection measures? If that is the case, then this is for you. It all began in November 2014 with leaked emails from Sony Movie Pictures. After this leakage of emails went viral all over the world, people, organizations and…
3 Ways to Prepare For Cyber Security Risks That Employees Must Know
In a world where everything is much easier to do via mobile, app, or device, technology is not going to slow down. We’re all guilty of potentially owning more than one device, whether that is our personal phones, work phones, tablets or fitness trackers. All…
Non-Negotiable Elements For Your Business IT Security Plan
In 2019, having a business IT security plan is more important than ever. An IT security plan is the first line of defense you have for protecting your business – and your clients – against cybercriminals. Cybercriminals include hackers, who frequently obtain personal information with…