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
Excel Quiz 35
Tips & Tricks 150 – Save Each Worksheet as Different Workbooks
You have got a workbook and you want to save each worksheet as different workbook – You can adopt following method to do so if worksheets are not many in number. 1. Right click on a worksheet tab 2. Move or Copy 3. Select new book 4. Save this new workbook 5. Do it for…