Smart Text Editor

Click My View Smart Text Editor helping every-day business users of Excel to work faster, more efficiently and enhance spreadsheet capabilities, with little or no effort.

 

This enables simple text editing in a window, for easier reading and faster, more accurate entry, especially where you need to format text as rows, text indenting, columns, bullets, etc. Then click "copy all" and paste into MS Word, retaining the format. The window opens automatically as you select a text cell.

 

All Click My View tools are specially designed to help business users of Excel improve efficiency and productivity. They are for people who want to complete their work in minimum time, with minimum effort, ideally for it to be automated or just require a click. Smart Forms work straight away, with little or no time to set up and no technical skills are needed.

 

Open A Text Cell In Smart Text Editor - Automatically!

Then click "copy all" and paste into MS Word, retaining the format.

Smart Text Editor Form

 

The example demonstrates column alignment, using real Tab and Enter keys, plus the addition of bullets, etc.

 

 

The window opens automatically when a user selects a cell that is formatted as "Text". 

 

Text is displayed as Calibri font, size 12,  for ease of reading, irrespective of cell font or screen zoom setting.


Use the tab key and enter keys to indent and break lines of text, which auto wraps across lines as you type.

 

Bullets can be added with a button, as can hyphens and simple line numbering

 

Text can be copied by dragging and selecting or you can copy all the text by clicking the Copy All button.

 

When pasting this text into Word, it retains the formatting you have specified. The exception being auto-wrapped lines. These will be automatically adjusted by Word.

 

The windows display 20 rows at a time and a vertical scroll-bar enables fast navigation. (vs. the limited text displayed in a cell, which does not have a scroll bar).

 

Note: As this is a "text" cell, Excel always treats the contents as plain text and the same for the window. Whilst it is possible to see bold text, underlined text and different fonts within a cell, this information is not contained within the text of the cell. This, unfortunately, means, that the degree of editing we can provide is limited to what is described above.

 

 

Setup is a single step: Set the format of relevant cells to TEXT. That should only be used for cells that contain textual content, such as notes, specification, etc.

Fast Navigation To Next Cell:

  • OK button – default Excel cursor movement to select next cell (to go right or to go down)

  • Enter key -  go to next visible row

  • Tab key - go to next visible column

  • Arrow keys – go left, right, up or down to the next visible cell

Other keys:

  • Delete  - deletes cell content and exits, remaining in the active cell

  • Escape  – exits, leaving unchanged, remaining in the active cell

Smart Forms Control Menu

   Overall control of the Smart Forms is through a ribbon menu, entitled CMV

 

  • About: Displays a message box containing information about the software version

  • Start Functions: Starts all functions – checks the licence and awakes the functions.

  • Stop Functions: Stops all functions – puts them to sleep.

  • Backup File: Creates a backup of your workbook with a time-stamped file name.

  • Sheets: Opens the Sheets window for fast navigation to hidden sheets.

  • Menus On - Off: Enables / disables automatic display of menus.

  • Lists On - Off: Enables / disables automatic display of Smart Lists / Dependant Lists.

  • Calendar On - Off: Enables / disables automatic display of cell calendars.

  • Smart Text On - Off: Enables / disables automatic display of text editing windows.

 

Please join our mailing list for news and updates

Smart Forms Overview Header Play.png

Smart Forms Productivity Tools


   Helping every-day Excel users to work faster, more efficiently and increase spreadsheet capabilities.

  • Smart List - automatically replaces Excel drop downs, searchable, multi-column display, multi-selection. With numerous options, which includes viewing photos, documents, web pages and enabling Smart Dependency Lists – with a new approach, that is much faster and easier than traditional methods
     

  • Smart Cell Calendar – no more blindly typing dates – with fast selection of real working days, etc.
     
  • Smart Dependency List – a new, much faster and easier method, than traditional methods
     

  • Smart Text Edit – an automatic window for cell text editing - with basic formatting, real tabs, bullets, etc.
     

  • Smart Menu -  intelligent menu - go to any cell - auto opens workbooks, sheets and runs macros
     

  • Smart Sheets – click to go to any sheet - hide/unhide individual sheets or all sheets with just a click

 

 

This is a short overview of Smart Forms

"Smart Forms save me time!"

Customer Satisfaction Is Important To Us
We believe in the effectiveness and quality of our products and are confident they will save you time and ease your workload.
 
If for any reason you are not satisfied within 30 days, we will happily return your money.
Guaranteed!

 

Smart Forms Pack Inclusions

 

  • Smart Lists – replaces Excel drop downs, searchable, multi-column display, multi-selection. With numerous options, which includes enabling Smart Dependency Lists – which is a new approach, much faster and easier than traditional methods
     

  • Smart Text Editor – for reading & editing text - with basic formatting, real tabs, bullets, etc.
     

  • Smart Cell Calendar – no more blindly typing dates – fast selection of the day, month & year
     

  • Smart Menu -  intelligent menu - click to open workbooks, unhide sheets & cells, run macros
     

  • Smart Sheets – click to go to any sheet, plus click for fast hiding / unhiding of sheets
     

  • Free point release updates, support, User Manual, Examples workbook, Access to all Videos

 

 

Plus a Free AddIn for Cell & Sheet Magnification!

 

 

 

 

 

 

 

 

SMART FORMS Subscription 

 

Pack Starts From

$2 per Week!

subscribe-2580606_1920.png
Sunshine Solutions Pty Ltd (ABN 30 124 423 552)
34 Balemo St, Minyama, Queensland Australia 4575
Email info@sunshinesolutions.com.au
  • YouTube Social  Icon
  • Facebook Social Icon
  • Twitter Social Icon