Contextures (@contextures) header
Contextures (@contextures) profile picture

Excel website & blog by Debra Dalgleish @ddalgleish Excel MVP

Canada
Joined November 2008
Use #Excel SHEET and SHEETS functions to troubleshoot. Are sheets hidden? Key values missing?
66
Quickly add your #Excel macros to buttons and drop down lists on a custom Excel Ribbon tab
65
Get Ready! Tomorrow is Spreadsheet Day! October 17th #Excel #SpreadsheetDay
1
95
Get ready for Spreadsheet Day! Saturday October 17th #Excel #SpreadsheetDay
1
130
Use #Excel RANDARRAY function to make quick lists of random numbers or text
309
Pivot table shows Top 3 weeks, formula sums all other weeks #PivotTable #Excel
3
118
Enter golf scores, and see annual summaries - multi-player and multi-course
1
348
Use Excel conditional formatting to highlight cells automatically, based on rules that you set. For example, change cell colour, border, font style, or number format. Read more 👉 lttr.ai/AsVgS
1
121
Use Power Query to combine data from 2 or more tables, then create a pivot table from the merged data lttr.ai/AsRF8
14
474
Answers to frequently asked questions about the Excel application and Excel files. For example, "Why does Excel say that my file has links?" Read more 👉 lttr.ai/AsMzR
1
81
These Excel macros will help you work with a pivot cache - a special memory area where pivot table records are saved Read more 👉 lttr.ai/AsI6n
1
75
If people enter their names in a sign-up form, you might end up with a mixture of upper and lower case letters. Read more 👉 lttr.ai/AsIoc
62