Download
Just download the ATOZ.zip file from the above Download button link, extract it and then work with the two major files, viz. atoz.xlsx and atoz.html.
Please see the VIDEO / SCREENSHOTS below, in FULL SCREEN mode, to gather all finer details and for easy explanation and help.
If you want to extend the records count in the HTML Sheet, then view the additional video : https://youtu.be/bEkksYRp_zM
Additional Points ( Not Covered in the Video ) :
1. Sort your data in the DATA Sheet, before you pick up your html from the HTML Sheet.
2. Copying Hyperlinking Formulas from Sample.xlsx file to the DATA Sheet, adjacent to the column to be linked. Refer Feature 1 below.
3. For Point 2, refer Wiki Page : Copy_Formulas for more general details
4. For Mouse or Trackpad Horizontal Scrolling for large data, refer Wiki Page : Scrolling
5. Use Ctrl+F / command+F feature in the Internet Browser, for further Searching of Classified Table Data. Use Google Chrome.
See Wiki Home Page
Features
- 1. Copy the required Hyperlinking Formulas from the Sample.xlsx file to the DATA Sheet, preferably adjacent to the column to be linked and edit them fully for correct cell references. Also, give a heading to the new columns created, in the process.
- 6. in Sublime Text Editor, Click View menu, then click Word Wrap, to toggle it, between on and off condition.
Project Samples
