[Affiliate]
Blog Stats
- 3,316,202 hits
-
Join 3,247 other subscribers
- Follow wmfexcel on WordPress.com
Search wmfexcel
Want Google to translate this page?
-
Recent Posts
Top Posts & Pages
- Date Formats - A trick to format date with "st", "nd", "rd", "th"
- Paste Special – Linked Picture (aka “Camera” in earlier versions of Excel)
- Highlight weekends and holidays using Conditional Formatting in #Excel
- F8 - It is for selecting range(s) of cells
- Quick Tip - Edit #DAX formula in #PowerBI Desktop efficiently
- The INDIRECT trick of using Structured Reference in Conditional Formatting
- #Excel Add current selection to filter. What it does?
- Highlight differences in two ranges with Conditional Formatting in #Excel
- Quickly delete/hide records (rows) with Strikethrough format by using Find and a couple of simple techniques.
- Do you know Menu Key??
My YouTube Channel
My Facebook page
- My Tweets
Tag Archives: CELL
A trick to SUM visible columns only (without VBA)
We know that SUBTOTAL allows us to perform some basics functions like SUM, COUNT, AVERAGE, etc. that apply to visible rows only. However, there is no similar function for visible columns only. If we need to SUM visible columns only, we will need … Continue reading
Put a dynamic hint for showing or hiding rows or columns hidden by Data Group
This is about using SUBTOTAL and CELL function to detect whether a row and a column is hidden respectively. When rows are hidden by Data–>Group, you will see a +/- button on the leftmost of spreadsheet to remind you that … Continue reading
wmfexcel 