Lotus 1-2-3

 Streamlined Data Entry
 Customise Lists
 Format Now
 Not-So-Splashy
 Beam It to Me

 Back to Index

Streamlined Data Entry
If you complain of sore fingers because of using the Tab button to jump between cells, then this will definitely help. You can select the cells where you intend to add data. Now you can enter data into the first cell and press Enter to move the cursor to the next highlighted cell. You can even select disjoint groups of cells that are not concurrent.

Customise Lists
Click for larger versionTo create custom SmartFill lists, click on File > User Setup > SmartFill Setup. Click on New List, enter a name for the list and click on OK. Click on Add Item to add items to the list.

Format Now
Click for larger versionTo quickly format a range of cells, select a range and click on Range > Range Properties. Under the Named Style tab, click Style Gallery and pick one of the predesigned styles.

Not-So-Splashy
Click for larger versionTo disable the opening splash and welcome screens, right-click the shortcut that opens Lotus 1-2-3 and click on Properties. At the end of the Target line, type '/q'. To disable only the logo screen, type ' /s' (without the quotes). Hence, if Lotus is installed in C:\Lotus, the command line would be C:\LOTUS\123\123W.EXE /L EN /q.

Beam It to Me
Click for larger versionIf you want to add hyperlinks within your spreadsheet, you can add an Internet button with the URL anywhere on the sheet. Using the Internet SmartIcons, click on the Create Internet Button icon, enter the text you want to appear on the button and the URL it should point to. Click on OK to create the button.