How to stop overwriting files in Excel
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. (more…)
Techniques to Paste Values in Excel
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. (more…)
Formatting with Style in Excel
Styles are an underrated feature in Excel. They provide an easy way to achieve consistent formatting throughout a workbook. (more…)
Handling graphics in Excel
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. (more…)
Right Clicking in Excel
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. (more…)
Pinning your file hopes with Excel
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. (more…)
Calculating Excel
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. (more…)
How to see the old Print Preview in Excel 2010
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. (more…)
Customizing Excel 2007 and 2010 [VIDEO]
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. (more…)