Hide unhide multiple columns in Excel with a click! | [SOLVED]
EXCEL USERS - IN 2 MINUTES this video will make you want FLEXIBLE SPREADSHEETS.
This is a revolutionary tool for business users of Excel. It makes your current spreadsheets flexible, faster and simpler to use. Flexible Sheets are automated “views” into the data within your spreadsheet, complementing the flat view you are used to seeing.
Setup is really simple. Import an existing spreadsheet into the template and in moments dynamic views are instantly available - using the columns headings, helping you get your work done faster and more accurately. Then add words or phrases, using your own terms, for regular views. You can also add your own selection criteria for both rows and columns and you have a truly flexible spreadsheet that changes the view with a click or two. Enabling you to work more easily, work faster and have more time for what is important to you. Below is a summary of the primary ways Click My View can help you
See the “view” of just data you need on-screen, side-by-side using a word or phrase. E.g. “total sales”
Create ad hoc views of anyone’s spreadsheet, literally in seconds, using just the columns headings
Add your own selection cells and criteria for filtering rows and columns in the “view”
Instantly see the “view” include or exclude your “selected” columns
Hide your selected rows with just a click – e.g deselect “HIDE” in the column filter
Hide or unhide all sheets with a click, or a selected sheet
Make dynamic headings that reflect the current “view” - using the content of selection cells
Click My View workbooks and sheets can be shared, viewed and updated as normal by people without Click My View. They are normal Excel workbooks. The only difference they will see is the inclusion of columns and rows above and to the left of your existing sheet.
Please share this news with friends who also use Excel, they may find this to be a great time saver for themselves.
Visit www.clickmyview.biz to see more details and also a video that showcases the ease of setup.