Unix, Linux, and Microsoft Excel

Unix ABCs

Unix, which is not an acronym, was developed by some of the members of the Multics team at the bell labs starting in the late 1960's by many of the same people who helped create the C programming language. The Unix today, however, is not just the work of a couple of programmers. Many other organizations, institutes and various other individuals contributed significant additions to the system we now know today.
  • See additional Unix information and variants and information on the Unix definition.

Linux ABCs

Developed by Linus Torvalds and further elaborated by a number of developers throughout the world, Linux (lee'nuhks/ or /li'nuks/,_not_/li:'nuhks) is a freely available multitasking and multiuser operating system. From the outset, Linux was placed under General Public License (GPL). The system can be distributed, used and expanded free of charge. In this way, developers have access to all the source codes, thus being able to integrate new functions or to find and eliminate programming bugs quickly. Thereby drivers for new adapters (SCSI controller, graphics cards, etc.) can be integrated very rapidly.
  • See additional Linux information and variants and information on the Linux definition.

MS-DOS vs. Linux and Unix

If you are able to navigate a computer using MS-DOS or the Windows command line, you should be able to quickly pick up on the navigation of Linux and Unix. In the below chart is a listing of common MS-DOS commands with their Linux and Unix counterpart.

Microsoft Excel shortcut keys

 Its About shortcut page if you are looking for other shortcut keys used in other programs.
ShortcutDescription
F2Edit the selected cell.
F3After a name has been created F3 will paste names.
F4Repeat last action. For example, if you changed the color of text in another cell pressing F4 will change the text in cell to the same color.
F5Go to a specific cell. For example, C6.
F7Spell check selected text or document.
F11Create chart from selected data.
Ctrl + Shift + ;Enter the current time.
Ctrl + ;Enter the current date.
Alt + Shift + F1Insert New Worksheet.
Alt + EnterWhile typing text in a cell pressing Alt + Enter will move to the next line allowing for multiple lines of text in one cell.
Shift + F3Open the Excel formula window.
Shift + F5Bring up search box.
Ctrl + ASelect all contents of the worksheet.
Ctrl + BBold highlighted selection.
Ctrl + IItalic highlighted selection.
Ctrl + KInsert link.
Ctrl + UUnderline highlighted selection.
Ctrl + 1Change the format of selected cells.
Ctrl + 5Strikethrough highlighted selection.
Ctrl + PBring up the print dialog box to begin printing.
Ctrl + ZUndo last action.
Ctrl + F3Open Excel Name Manager.
Ctrl + F9Minimize current window.
Ctrl + F10Maximize currently selected window.
Ctrl + F6Switch between open workbooks or windows.
Ctrl + Page upMove between Excel work sheets in the same Excel document.
Ctrl + Page downMove between Excel work sheets in the same Excel document.
Ctrl + TabMove between Two or more open Excel files.
Alt + =Create a formula to sum all of the above cells
Ctrl + 'Insert the value of the above cell into cell currently selected.
Ctrl + Shift + !Format number in comma format.
Ctrl + Shift + $Format number in currency format.
Ctrl + Shift + #Format number in date format.
Ctrl + Shift + %Format number in percentage format.
Ctrl + Shift + ^Format number in scientific format.
Ctrl + Shift + @Format number in time format.
Ctrl + Arrow keyMove to next section of text.
Ctrl + SpaceSelect entire column.
Shift + SpaceSelect entire row.
Ctrl + -Delete the slected column or row.
Ctrl + Shift + =Insert a new column or row.
Ctrl + HomeMove to cell A1.
Ctrl + ~Switch between showing Excel formulas or their values in cells.




0 comments:

Post a Comment