Posted January 4, 20231 yr FPCH Admin see the latest features and fixes in Excel: Skip Blanks: Avoid pasting blank cells over existing data > with Excel Skip Blanks feature. Nov 9, 2022 Add Sheets Macro: adds new worksheet automatically with Macro > adds new worksheet automatically , Nov 1, 2022 Copy & Paste Problems: fix multiple selections error, or formulas changed to values > fix Excel copy & paste problems Dec 27, 2022. Contextures Blog: planners, Advent calendars, Christmas trees, personalized messages > Excel for the holidays , Nov 17, 2022. Pivot Table Blog: Compare years with > pivot table conditional formatting ,Nov 9, 2022. Contextures Blog: Go to the Help tab and click Feedback So have you ever > sent Microsoft a smile or frown in Excel? Nov 3, 2022. UserForm Search: Add new records, or find existing records, and view, edit or delete them in a worksheet table > Excel UserForm to search transaction records ,Sept 28, 2022 Contextures Blog: Before you click remove all button for excel subtotal feature, be prepared -- there's no Undo! > click Remove All button for Excel Subtotal , Sept 22, 2022 Count Blanks: using pivot table count blanks > pivot table, see how to count blanks , Sept 13, 2022 Contextures Blog: How to fix an excel error messages > fixed an Excel error message ,Sept 8, 2022 Contextures Blog: This shortcut might help, or try a workaround > Problems pasting into filtered Excel list?. Aug 25, 2022 Pivot Table Blog: Date filters in Excel pivot tables > try these 3 different types. Aug 3, 2022 Contextures Blog: how to use wildcards with criteria for a flexible averageIf formula in Excel > use wildcards with criteria for a flexible AVERAGEIF , July 28, 2022 Date Grouping: how to turn off automatic date grouping for Excel Pivot Tables and AutoFilters > turn off automatic date grouping , July 18, 2022 Line Breaks: Find and remove line breaks > add line breaks in Excel cells and formulas , July 13, 2022 Pivot Table Blog: feature in Excel pivot table > check sales progress with % Running Total , July 6, 2022 Contextures Blog: with 1 formula instead of 48672! > make country flags in Excel 365, June 30, 2022 Compare Lists: Compare two excel lists, to find a new items in second list, and add them to first list > Compare two Excel lists, to find new items , June 20, 2022 Pivot Table Blog: Quick and easy steps to > make a clustered stacked pivot chart ,June 8, 2022 Contextures Blog: Find Product Price for quantity ordered > find product price with Excel VLOOKUP and MATCH, June 16, 2022 Status Bar Tips: get key information for macros, show custom messages with macro progress updates > Excel Status Bar info to troubleshoot problems, June 8, 2022 Debra D Blog: Use bookmarks and shortcut keys for > quick navigation in Notepad++ file. June 6, 2022 Contextures Blog: using Excel 365 spill functions with Excel formulas > count duplicate number sets , June 2, 2022 Debra D Blog: Fix mouse double click problem with > fix mouse double click problem in Microsoft Access, May 30, 2022 Contextures Blog: Change chart setting manually or with macro > show hidden data in Excel chart or Excel sparklines , May 19, 2022 Basic UserForm - with text boxes for data entry > how to make basic Excel UserForm . May 16, 2022 Pivot Table Blog: fix the problem with > pivot table show duplicate numbers? May 11, 2022 FILTER Function Reports: create multi-column > summary reports, using Excel FILTER Function , May 7, 2022 Contextures Blog: Take a break from your work > use Excel to stream web radio. May 5, 2022 Debra D Blog: with Video Editor in Microsoft Photos program > fix avi format videos that have audio and black screen, Apr 24, 2022 Contextures Blog: warning if Excel worksheet > sheet has hidden rows or columns, Apr 21, 2022 Compare Cells: Find exact match, or partial match and percentage with > compare cell values in Excel. Apr 12, 2022 Pivot Table Blog: Help Excel by preventing automatic updates > pivot table macros run faster . Apr 6, 2022 Excel Charts: Change chart setting manually or with macro > show hidden data in Excel chart or Excel sparklines. Mar 15, 2022 Highlight Weekends: with conditional formatting. Fix rule settings to avoid problems > highlight weekend data in Excel pivot table . Mar 2, 2022 Excel Printing: check filter settings before printing > Excel report diagnostic display , Jan 27, 2022 Working Days: How to calculate project dates or upcoming workdays in Excel > with WORKDAY function and WORKDAY.INTL function. Jan 17, 2022 Cluster Stack Pivot Chart: from a pivot table. Use named Excel table or see how to unpivot data with Power Query > Cluster Stack Pivot Chart . Sept 27, 2021 Remove Duplicates: Fix problem when duplicates numbers not all removed > remove duplicate items from Excel list. Sept 16, 2021 Conditional Formatting: Fix excel manual, or macro clean up conditional formatting problems when extra rules . Sept 9, 2021 Continue reading... Off Topic Forum - Unlike the Rest
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.