In Lotus 123, pressing the home key takes you back to the first cell and first row of the spreadsheet. Pressing the home key in Excel takes you back to the first cell of the row that you will be navigating on. Both programs have therefore included a home key that can be used if there is need for fast navigation using a keyboard. Insertion of the function name in Lotus 123 is however different in that it specifically requires the function name to be inserted preceded by the ‘at’ symbol.Īs data sets grow, it can increasingly become challenging to navigate through data, and the use of keyboard shortcuts is preferred in helping fast navigation. In Excel, the function is inserted into the cells of the spreadsheet by typing in the specific function name. When it comes to functions, it is important to note that the programs use these in spreadsheets to allow for a routine calculation to be performed. In excel, the different cells are separated using a colon, while in Lotus 123 use of two periods in a row is used to differentiate values. The definition of range in both programs comes from the definition of the first and last cells. The cell ranges are also an item that needs to be mentioned. It is, however, strange that Lotus 123 does not require the equal sign when entering a formula. Excel needs the definition of the formula to start with the ‘=’ sign. When it comes to formulas, both programs are designed to be in a cell as opposed to typing in raw data. Lotus 123 has a reversed order that needs the command to be selected and then the selection of cells. Manipulation of cells in Excel needs one to drag over them so that the range of choice can be selected. Below is an outline of the differences that the two programs have.Ĭell selection in both Excel and Lotus 123 allows the cell to be selected, sorted and various operations to be handled by different cells. Inasmuch as there is a lot of similarity in how these two programs work, it is also good to know the differences of the programs too.
#Lotus 123 vs. excel software#
The spreadsheet is software that is designed to allow for improved organization of data in columns and rows. Inasmuch as the basic programs are developed to function on spreadsheets, their design and development have come from different companies and, as would be expected, their functionality is somewhat different.
![lotus 123 vs. excel lotus 123 vs. excel](https://nationaltoday.com/wp-content/uploads/2021/12/Lotus-1-2-3-Day--300x300.jpg)
![lotus 123 vs. excel lotus 123 vs. excel](https://windows-cdn.softpedia.com/screenshots/Fantastic-Lotus-1-2-3-Converter_1.png)
Prior to switching over to Excel, Lotus 1-2-3 was the spreadsheet program of choice where Bill worked.