Excel Chart Tips: Plotting With a Dynamic Range Another tip that I learnt today. When plotting a graph, the data that is to be plotted must be linked to the graph. What happens when the range of the data changes in length? You need to be able to plot using a dynamic range. 1. Specify…
Read More
Excel Worksheet Tips: Adding ticks and crosses Have you created a list and you want to tick off an item? 1. Select the cell you wish to add the tick to. 2. Change the font to “webdings” 3. To enter a tick – enter the letter a. To enter a cross – enter the letter…
Read More
Excel VBA Tips: Running macros using hyperlinks At work today I had to create a workbook that provided links between different sheets within a workbook and turned on a filter. However, I didn’t want to use buttons, as it would be become extremely cluttered. I discovered that you can run macros using hyperlinks, so commandbuttons…
Read More
SUBMEG 