Moving Images in Excel
When you are moving images, charts or other objects that float above the grid you can use the Shift key to make it easier.
(more…)
Entering Dates in Excel
There are only two characters Excel recognises when separating numeric days, months and years in dates. They are the / and – characters. Please don’t use the full stop as Excel won’t recognise it as a date. Below you can see examples of using / and – in dates. When you use the full stop Excel won’t recognise it as a date – see below. Its left aligned and will be treated a text.
Free Excel Webinar Recording – Mastering Form Controls
In March 2019 I demonstrated how to use some of Excel's Form Controls. CPD note - if you are claiming CPD for watching this recording you need to keep your own records. People who attend the live sessions receive an annual listing of attendances. Download Webinar Materials https://vimeo.com/322983267 Learn how to build better spreadsheet interfaces using form controls like check boxes, scroll bars, option buttons and combo boxes. Form controls can reduce the number of input errors; simplify and speed…
Pasting or inserting with a Formatted Table
When you need to paste new rows to the bottom of a formatted table, or insert blank rows at the bottom, one way is much quicker than others when working with large, complex models. (more…)
Autofit columns with a limit
The column Autofit on the whole sheet is a great Excel feature. But if you have a few columns that have lots of text it can make using it problematic as you need to manually adjust those wide columns. Here’s a macro to make it easier.
(more…)Increasing Excel Formula Bar Font Size
I recently saw a good post on Linkedin from Leila Gharani MVP on increasing the Excel Formula Bar font size. It seems useful for training, so I wrote a simple macro to simplify the process. (more…)