For some reason, after Excel 2003, you just can’t change the textbox name on a chart tab anymore. (It still works in a normal worksheet tab.) And it’s actually a crucial feature since it is how textbox are referenced in VBA. In Excel 2003, you can read the textbox name by clicking on it, and…
Sometimes Excel does not calculate numbers correctly and gives an “incorrect” result. Avoiding technical jargon, its basically because Excel rounds of the results of its calculation. This typically isn’t a problem because most users will not need the 10th decimal place, and would never notice the problem. However, the problem is quite noticeable for those who are doing…
In Excel 2003, when multiple cells are merged, it is hard to select each of the columns individually. Right clicking a selected row column will result in all the rows columns of the merged cell being selected. This typically causes a headache if you are trying to insert a column, hide a column, or change…
The Problem When pasting a Picture (Enhanced Image or Windows Metafile) into Powerpoint, the picture may turn mushy, fuzzy, blurry and even unreadable when being printed. This usually only happens if you put a gif, jpg, or raster image as part of the cells that are pasted into Excel. Typically, the fuzziness is not noticeable on screen,…