Excel Worksheet Tips: PDF Table to Excel – UPDATE On occasion I need to pull in a table of data from a PDF file into an excel spreadsheet to manipulate the data or to add to it. However, highlighting the table in the PDF, copying…
Excel VBA Tips: Stop Users from Adding Sheets Do you have a spreadsheet that you want to stop users from adding sheets to? Of course, you could lock the workbook using the “protect workbook” feature and ensuring that the protect structure is selected. However, say…
Excel Worksheet Tips: Remove First and Last Character From a String Perhaps you have a list of data that you wish to remove the first and last characters. For example, there is a list of values similar to these: “Data” “Trial” “Test” What you are…
Excel Worksheet Tips: Reversing Rows of Data OR Columns of Data – Version 2.0 After creating a procedure to reverse rows or columns of data, I was informed of a much simpler way to do this. Reversing Rows of Data If you have a list…
Excel Worksheet Tips: Reversing Rows OR Columns of Data There are times when you realise your list of data is in the wrong order; for example in rows 1 through 4 you have D then C then B then A. You realise you need the…
Excel Worksheet Tips: Switch Between Formula and Results If you have created a worksheet in excel with formula all over the sheet and want to quickly see what the formulae are, use: Ctrl + ~ (Where ~ is tilde; which is located underneath the Esc…
Excel Worksheet Tips: Unlocking Specific Areas of a Protected Worksheet If you create a workbook that others are going to use, but you don’t want them to corrupt certain parts of the workbook, you will want to protect the workbook. However, if they are required…
Excel Worksheet Tips: Extract Date or Time from Date/Time Do you have a cell that contains both a date and time value but only need one or the other? To extract the date Assuming the date time value is in cell A1, you can use…
Excel VBA Tips: Convert Number to Text I have covered how to do this using worksheet formulae, but it can also be done using vba. If your variable (that is a number) is called Number, to convert this to text, use the following code: Number…
Excel Worksheet Tips: Keyboard Shortcuts I was searching for a particular shortcut but unfortunately I was unable to find the one I was looking for; however I have found many more. Check out all these useful shortcuts here. Come check out the directory for the…