MS Office

What Is Ms Office


Microsoft Office, or simply Office, is a family of client software, server software, and services developed by Microsoft. It was first announced by Bill Gates on August 1, 1988, at COMDEX in Las Vegas. Initially a marketing term for an office suite (bundled set of productivity applications), the first version of Office contained Microsoft Word, Microsoft Excel, and Microsoft PowerPoint. Over the years, Office applications have grown substantially closer with shared features such as a common spell checker, OLE data integration and Visual Basic for Applications scripting language. Microsoft also positions Office as a development platform for line-of-business software under the Office Business Applications brand. On July 10, 2012, Softpedia reported that Office is used by over a billion people worldwide.


Office is produced in several versions targeted towards different end-users and computing environments. The original, and most widely used version, is the desktop version, available for PCs running the Windows and macOS operating systems. Office in a browser, previously known as Office Online, is a version of the software that runs within a web browser, while Microsoft also maintains Office apps for Android and iOS.


Since Office 2013, Microsoft has promoted Office 365 as the primary means of obtaining Microsoft Office: it allows use of the software and other services on a subscription business model, and users receive free feature updates to the software for the lifetime of the subscription, including new features and cloud computing integration that are not necessarily included in the "on-premises" releases of Office sold under conventional license terms. In 2017, revenue from Office 365 overtook conventional license sales.

The current on-premises, desktop version of Office is Office 2019, released on September 24, 2018.




What Is a Keyboard Shortcut?


In computing, a keyboard shortcut is a set of one or more keys that invoke a command in software or an operating system.


They are typically an alternate means for invoking commands that would otherwise be accessible only through a menu, a mouse, or an aspect of the user interface. These shortcuts can expedite common operations by reducing input sequences to a few keystrokes.


These shortcuts can provide an easier and quicker method of using computer programs. These commands are commonly accessed by using the Alt ket (on PC computers), command key (on Apple computers), Ctrl, and Shift in conjunction with a single letter.


Shortcut Keys in Microsoft Word

F1 key: Get help on a selected command or use the Office assistant.
Shift and F1 Key: Review text formatting.
F2 Key: Move text or image.
Shift + F2 Key: Copy text.
F3 Key: Insert an autotext entry.
Shift + F3 Key: Change the case of the selected text.
F4 Key: Perform last action again.
Shift + F4 Key: Perform a Find or Go To action again.
F5 Key: Displays the Go To dialogue box. You can also get to Find and Replace from here.
Shift + F5 Key: Move to a previous revision.
F6 Key: Go to the next frame or pane.
Shift + F6 Key: Go to the previous frame or pane.
F7 Key: Launch the Spell Checker.
Shift + F7 Key: Launch the Thesaurus.
F8 Key: Extend the current selection.
Shift + F8 Key: Shrink the current selection.
F9 Key: Refresh.
Shift + F9 Key: Switch between a field code and its result.
F10 Key: Show KeyTips.
Shift + F10 Key: Display a Shortcut Menu (same as right-clicking).
F11 Key: Go to the next field.
SHIFT + F11 Key: Go to the previous field.
F12 Key: Open Save As, equivalent to tools menu.
Shift + F12 Key: Save document, equivalent to tools menu.
Ctrl and A: Selects all in the current document.
Ctrl and B: Bold text.
Ctrl and C: Copies the item or text.
Ctrl and D: Displays the Font dialogue box.
Ctrl and E: Switch a paragraph between center and left alignment.
Ctrl and F: Displays the Find dialog box to search the current document.
Ctrl and G: Displays the Go To dialog box to search for a specific location in the current document.
Ctrl and H: Displays the Replace dialogue box.
Ctrl and I: Italicize text.
Ctrl and J: Switch a paragraph between justified and left alignment.
Ctrl and K: Create a hyperlink.
Ctrl and L: Left align a paragraph.
Ctrl and M: Indent a paragraph from the left.
Ctrl and N: Create a new document.
Ctrl and O: Opens a new document.
Ctrl and P: Prints a document.
Ctrl and R: Switch the alignment of a paragraph between left and right.
Ctrl and S: Saves a document.
Ctrl and U: Underlines text.
Ctrl and V: Pastes the copied item or text.
Ctrl and X: Cuts the selected item or text.
Ctrl and Y: Redo the last action.
Ctrl and Z: Undo the last action.
Ctrl and Enter: Insert a page break.
Ctrl and F2: Select Print Preview command.
Ctrl and F4: Closes the active window.
Ctrl and F6: Opens the next window if multiple are open.


Microsoft Excel Shortcut Keys


F2: Edit the active cell.
F5: Displays the Go To box.
F7: Open the Spelling dialogue box to check a selected range.
F11: Create a chart of data in the current range in a separate sheet.
Alt + Shift + F1: Insert a new worksheet.
Shift + F3: Opens Insert Function dialogue box.
Shift + F5: Opens the Find and Replace dialogue box.
Ctrl + Shift + Colon (:): Enter the current time.
Ctrl + Semicolon (;): Enter the current date.
Ctrl + A: Select all content in the worksheet.
Ctrl + B: Bold highlighted selection.
Ctrl + I: Italicize highlighted selection.
Ctrl + K: Open the Insert hyperlink dialogue box.
Ctrl + U: Underline highlighted selection.
Ctrl + 5: Apply strikethrough formatting.
Ctrl + P: Brings up the print dialog box.
Ctrl + Z: Undo.
Ctrl + F9: Minimize a workbook window to an icon.
Ctrl + F10: Maximize a selected workbook window.
Ctrl + F6: Switch to the next workbook window when multiple are open.
Ctrl + Page Up: Move to previous sheet in a workbook.
Ctrl + Page Down: Move to next sheet in a workbook.
Ctrl + Tab: Switch to next tab in dialogue box.
Ctrl + Apostrophe ('): Insert the value of the above cell into the cell currently selected.
Ctrl + Shift + !: Apply the Number format.
Ctrl + Shift + $: Apply the Currency format.
Ctrl + Shift + #: Apply the Date format.
Ctrl + Shift + %: Apply the Percentage format.
Ctrl + Shift + ^: Apply the Exponential format.
Ctrl + Shift + @: Apply the Time format.
Ctrl + Arrow Key: Move to the edge of the current data region in a worksheet.
Ctrl + Space: Select an entire column in a worksheet.
Shift + Space: Select an entire row in a worksheet.