You can use SUBTOTAL or AGGREGATE function to sum visible rows but Excel doesn't provide the facility to sum only visible columns. Look below. Columns B and D are hidden. Hence, our function should sum up only A, C, E and F. G2 has the formula =SUM(A2:F2) If you hide the columns, the sum stays…
Solution – Challenge 57 – Another Word Challenge – Palindrome or Not
Below is a possible solution to the Challenge 57 – Another Word Challenge – Palindrome or Not Use the below formula –
Tips & Tricks 152 – While Printing a Sheet, Don't Print Page Number on First Two Pages and Print 1 on 3rd Page
One user had a specific requirement. His first two pages were cover page and Table of Contents. Hence, he wanted to start his page number from 3rd page. He wanted to display page X of Y. Hence, if the worksheet had 10 pages, his 3rd page should say 1 of 8……Last Page should say 8…
Downloads 10 – Printable & Pin-up Sheet for Excel Shortcuts
You can download this one page pin-up sheet and take the printout and pin up to your desk for quick reference. – Excel Shortcuts Quick Reference
Solution – Challenge 56 – Cryptography Challenge 5 – Fully Functional Caesar’s Shift Cipher Decrypter
Below is a possible solution to Challenge 56 – Cryptography Challenge 5 – Fully Functional Caesar’s Shift Cipher Decrypter
Challenge 58 – Make a Vedic Square
Vedic square is below. In this, first row and first column are numbers 0 and 9. Other numbers are populated as per logic which you will need to identify. More about Vedic Square at https://en.wikipedia.org/wiki/Vedic_square
Tips & Tricks 151 – Saving in ODS (OpenDocument Spreadsheet) but Don't Need Excel Warning Message – "Do you want….."
Question – Sometimes, I may require to work in different Office Suites and to maintain compatibility, I use Open Document Format. But whenever, I save in Open Document Format (ODS – OpenDocument Spreadsheet), I get the Excel warning like below. I don't need this. What is the way out? Answer – This requires a registry…
Solution – Challenge 55 – Make an Alphabetic Triangle
Below is a possible solution to Challenge 55 – Make an Alphabetic Triangle Put following formula AB4 somewhere and drag to the right.
Challenge 57 – Another Word Challenge – Palindrome or Not
We earlier had challenges related to Pangram, Isogram and Anagram. This time, it is about Palindrome. A Palindrome is a word / sentence that reads the same from backward also as it reads from forward. Some of the famous Palindromes are