Fake Data in Excel via Python Part 2
Following on from last week’s post on creating some fake data we will expand on the functionality with a few setting changes.
(more…)Fake Data in Excel via Python – Part 1
Python in Excel is new. Since it is the year of the snake let’s slither into Python in Excel.
(more…)Insert an Image in a Cell Note
Cell Notes used to be called Cell Comments and they were like a “Post-it” note for a cell. You can insert a picture in a Note. This could be useful to show a picture but not to have it take up space on the sheet or print.
(more…)Another Alt key Shortcut in Excel
When you press the Alt key there are numbers and letters that appear above the Quick Access Toolbar. These allow you to access those icons. Here is a trick I learned from Mike Girvin (ExcelisFun) to use the QAT shortcuts multiple times. When you press the Alt key and then press another key you perform the action once. If you want to repeat the action and you are only pressing one key for the QAT options, you can hold the…