Is this you? You open the May file and make the changes for June and save it and then remember you hadn’t renamed the file as June. Well, I’ve done that too.
Sometimes in Excel you need to paste just the values from copied cells. You don’t want the formulas. You may have created temporary formulas that you need to replace with their values. You may need to capture the current values, make some changes and then compare the new values with their old values to see the difference.
Styles are an underrated feature in Excel. They provide an easy way to achieve consistent formatting throughout a workbook.
If you need to move or amend a lot of graphics at once Excel has a feature that can save you time and effort. It’s been around for a while, but it’s been hidden away in the latest few versions.
Right clicking in Excel offers many productivity benefits. If you don’t already right click try it, it’s fun to see all the options that are just a click away.
There’s a little icon that was introduced in Office 2007 that is very useful but sadly, many people don’t know about it. It’s a pin icon and it allows you to “pin” files to the recently used file list in Excel 2007.
When you set calculation to manual in Excel you have turned off calculation. You can press F9 at any time to update the calculations. F9 doesn’t turn on calculation, it just does a recalculation.
Excel 2010 introduced the File tab with its new Print Preview screen. Many users don’t like this new layout and want the good old fashioned Print Preview screen they are used to. As with many features in Excel, it’s still there, you just need to find it.
Excel 2007 introduced the new interface called the Ribbon. It’s a cross between a toolbar and a menu. It also has a Quick Access Toolbar (QAT) that many people don’t seem to be using.