A quick way to date and time stamp your spreadsheet is to make use of Excel shortcuts using the control key.
So for example, if I want to put a date time stamp in a spreadsheet cell, you’ll see that if I hold control down and push the semi- colon (;), you’ll see what happens. You’ll see it puts today’s date in. Now push enter and you’ll see because I formatted it in another way, it shows the date in that format. Similarly with the time if I hold the control and shift key and press semi colon, you’ll see it puts in the time today. Push “Enter”. When you look at the formula bar you’ll see that these aren’t linked, they are actually stamped. They are values that you have actually entered and each time you want to change them you can use those shortcuts again.
If I understand the query below correctly, the one idea is to type some words in a cell, and then, while holding the ALT key down, click ENTER. Within the cell you will get another line. Hope this helps. Original query Hi, … Continue reading
A recent email query asked how to share and unshare workbooks in Microsoft Excel with a specific focus on switching off the sharing. The method to share and ‘unshare’ the workbook is the same. As shown in the image below, … Continue reading
The remarkable thing about Adrian's presentation is his ability to further change and adapt the focus of the course as issues arose. He was also able to keep the more skilled delegates challenged...– Alexander Proudfoot Consultants