Excel Trick #6 – VLOOKUP/MATCH doesn’t work even when there is a Match The issue, in this case, is that you have accidentally activated the Scroll Lock. The problem, of course, can be solved easily without restarting. The first time this happened to me, I closed the Excel workbook and restarted my system. Excel Trick #5 – Cursor Stuck – Not Able to Change Active Cell by Arrow Keys See Also: Learn more about Paste Special Shortcuts. In the Paste Special Dialogue Box, select Values ( Keyboard Shortcut – Alt + E + S + V).If you have formulas that need to be converted to values, here are the steps: Excel Trick #4 – Need to Convert Formulas to Values This excel trick would work in this case as well. This will keep the number intact and can be used in formulas.Ī lot of people use the apostrophe (‘) before the number to make numbers as text. Numbers are formatted as text and do not work well in formulas. Check the option ‘Enable Fill Handle and cell drag-and-drop’.In the Options Dialogue box, select Advanced.The Fill handle just does not show up for work. Here is another great method by Excel MVP Tom Urtis (using Find and Replace) Excel Trick #2 – Fill Handle Does Not Show Up Change the format from Text to General.This will change the cell’s format to Text. In the Number format drop-down, select Text. Select the cells that you want to copy.This happens because the references change when you copy to another location (unless of course you be strict and fix all the references). You try to copy a cell with a formula to another cell and it gets all mixed up. Excel Trick #1 – Copy-Paste Formulas without Changing References Here are some quick fixes that will make it possible. If you work with excel, sooner or later you get into trouble with something that seems impossible.

In this blog post, let me unveil 24 Excel tricks that will save you a lot of time and energy. These are small issues that can be fixed in a few seconds, but to not know the right way to do it can cost a lot of time.

However, there are some Excel Issues that continue to waste our time and pump up the frustration levels. Excel has made our life easier in so many ways.

Finding hidden characters in excel