- December 2024
- November 2024
- October 2024
- September 2024
- August 2024
- July 2024
- June 2024
- May 2024
- April 2024
- March 2024
- February 2024
- January 2024
- December 2023
- November 2023
- October 2023
- September 2023
- August 2023
- July 2023
- June 2023
- May 2023
- April 2023
- March 2023
- February 2023
- December 2022
- November 2022
- October 2022
- September 2022
- August 2022
- July 2022
- June 2022
- May 2022
- April 2022
- March 2022
- February 2022
- January 2022
- December 2021
- November 2021
- October 2021
- September 2021
- August 2021
- July 2021
- June 2021
- April 2021
- March 2021
- February 2021
- January 2021
- December 2020
- November 2020
- October 2020
- September 2020
- July 2020
| ID | Title 1 | Title 2 |
|---|---|---|
| Sample #1 | Row 1, Content 1 | Row 1, Content 2 |
| Sample #2 | Row 2, Content 1 | Row 2, Content 2 |
| Sample #3 | Row 3, Content 1 | Row 3, Content 2 |
Border Styles Comparison
I’ve often wondered why the Format Cells window for conditional formatting only has half the border styles found in the standard one. I like the thick border styles because they stand out more. There have been numerous occasions when I’ve…
Calculate the Difference Between Dates
The easiest way to find the difference between two dates is to subtract the older date from the newer one. That will return the number of days; however, you may want it in weeks, months or years. DATEDIF is a…
Keyboard Shortcut for VBA Comments
VBA lacks a keyboard shortcut for commenting. This is a standard feature in modern IDEs, however, the VBA Editor is not modern, so we are forced to tolerate its drawbacks. Comments are denoted using a single quotation mark (‘). Block…
Insert Function Arguments in Formula Bar
Press Shift + Ctrl + A after a function to display all its arguments. Then put a leading single quote to signify text. I often find this useful if I need to retrieve the arguments of a function I’m explaining….
How to replicate Sheets’ FLATTEN function in Excel
Wednesday’s announcement of 14 new Excel functions was welcoming news. However, despite switching to the BETA Channel yesterday, I am not one of the lucky ones who have access to the new batch yet. Nevertheless, I was particularly drawn to…
How to Create an Excel Calendar
Calendars are useful for scheduling events, constructing to-do lists, and managing projects. Many applications exist for mobile and desktop, such as Outlook, iCloud Calendar, and Google Calendar. Whilst these are feature-packed and great for day-to-day use, nothing beats an Excel…
I’ve often wondered why the Format Cells window for conditional formatting only has half the border styles found in the standard one. I like the thick border styles because they stand out more. There have been numerous occasions when I’ve…
The easiest way to find the difference between two dates is to subtract the older date from the newer one. That will return the number of days; however, you may want it in weeks, months or years. DATEDIF is a…
VBA lacks a keyboard shortcut for commenting. This is a standard feature in modern IDEs, however, the VBA Editor is not modern, so we are forced to tolerate its drawbacks. Comments are denoted using a single quotation mark (‘). Block…
Press Shift + Ctrl + A after a function to display all its arguments. Then put a leading single quote to signify text. I often find this useful if I need to retrieve the arguments of a function I’m explaining….
Wednesday’s announcement of 14 new Excel functions was welcoming news. However, despite switching to the BETA Channel yesterday, I am not one of the lucky ones who have access to the new batch yet. Nevertheless, I was particularly drawn to…
Calendars are useful for scheduling events, constructing to-do lists, and managing projects. Many applications exist for mobile and desktop, such as Outlook, iCloud Calendar, and Google Calendar. Whilst these are feature-packed and great for day-to-day use, nothing beats an Excel…