About Microsoft Office 2010
Microsoft Office 2010 released and added many new functions compared to Office 2007. Microsoft Office will help users easily compose documents, create tables Computer, presentation design, email management... 1 mobile way. If you are a professional office user, you cannot ignore this Office 2010 suite.
Office 2010 retains the clean ribbon interface, but the "Office" button has been renamed to "File". The context menu in Word is much improved and allows users to see changes in real time as you browse through different options. You'll now be able to add videos to your own Power Point presentations, remove unnecessary messages from conversations in Outlook, and insert new ones. small color chart inside cells in Excel.
Especially, with Microsoft Office 2010 users can save documents on OneDrive and share online with just 2 clicks. Convert documents to PDF files in an easier way. Microsoft continuously develops its own office applications up to version Office 2016 or Office 2019 to meet the increasing demand of users. use. But it seems that users still prefer to use Office 2007 and Office 2010 versions.
Microsoft Office 2010 office suite includes
- Word 2010: Supports text editing.
- Excel 2010: Support creating spreadsheets.
- PowerPoint 2010: Create impressive presentations.
- Outlook 2010: Effective email management.
- OneNote 2010: Note-making app.
Functions of the Microsoft Office 2010 office suite
Express your ideas in more detail
Office 2010 opens up a world of design options to help you express your ideas. Newly improved image formatting tools, such as color saturation and artistic effects, help you turn your own images into works of art. Rich in new, customizable themes and graphic presentation SmartArt provides more ways to bring ideas to life.
Improve working efficiency when working together
Break up new ideas, synchronize versions, and get work done by deadlines as you work in teams. Brainstorming ideas together in shared notebooks Microsoft Word 2010, Microsoft PowerPoint 2010, Microsoft Excel Web App and Microsoft OneNote 2010 lets you edit the same file side by side with others — even when they're in different locations.
Get a trial of familiar Office from multiple locations and devices
With Office 2010, you'll be able to get everything done as planned.
- Microsoft Office Web Applications. Extend the Office 2010 experience to the Web. Store Word, Excel, PowerPoint, and OneNote files online and then access, view, edit, and share content from virtually anywhere
- Microsoft Office Mobile. Stay up to date and react quickly using mobile versions of Office 2010 applications designed exclusively for your Windows Mobile smartphones
- Microsoft SharePoint Workspace 2010. Sync SharePoint 2010 lists and libraries with SharePoint Workspace, formerly known as Microsoft Office Groove, so you'll be able to access, view, and edit files anywhere anytime and anywhere on your own PC. Everything automatically syncs with the SharePoint server when you're connected to the network.
Completely groundbreaking new interface of Microsoft Word 2010
Stay connected to business and social networks
Outlook 2010 is a hub to connect with colleagues, customers and friends. Use Outlook Social Connector to quickly review the e-mails, meetings or attachments you receive from others. Receive additional information about others, such as two-way relationships and other social information, via SharePoint My Site, Windows Live or other popular 3rd party websites, to stand out in the business and social networks.
Instant messaging
Broadcast your PowerPoint presentation to distant listeners, whether or not they have PowerPoint installed. The new Broadcast Slide Show function lets you quickly share your own presentations via the browser, without the need for additional installation or additional software.
Complete new look of Microsoft PowerPoint 2010
Improve data insights
Track and highlight important trends with new graphical and data analysis capabilities in Excel 2010. The new Sparklines function supports a clean and clear visual representation of data by projects. You go through the mini charts located in the cells of the worksheet. Slicers help you filter and categorize PivotTable data into multiple classes so you can spend more time analyzing it with less time spent on formatting.
Manage large number of e-mail
Save precious time through inbox synchronization. Outlook 2010 helps you compress long email threads (thread) into dialogues (conversations) that can be classified, prioritized and prioritized. first and save the file in a convenient way. The new Quick Steps function allows you to do multi-command tasks (multi-command tasks), such as reply (reply) and delete (delete) ), in the same click.
Deliver good presentations
Engage your audience with personalized videos in presentations. Embed and edit video clips directly in PowerPoint 2010. Crop, add blur effects and more, or bookmark important scenes. Movies inserted from later files will be automatically embedded by default, so you'll be able to share your own dynamic presentations without having to manage media files separately. .
Store and track your ideas in one place
It's like you have an electronic notebook to track, organize and share documents, images, audio, and video files with OneNote 2010. New functions such as page version tracking, auto-highlighting, and linked notes give you a greater degree of control over information, so you're always on top of what's great changes made by others.
Work faster and easier, your way
Microsoft Office Backstage view replaces the traditional File menu to provide you with a centralized space for all management tasks, including saving, sharing, printing. ) and publish. Improved Ribbon functionality, available across all Office 2010 applications, helps you access commands quickly and create or customize tabs to fit the way you work. .
A lot of formats are supported
Microsoft Office 2010 supports the following formats: DOC, DOCX, XLS, XLSX, PPT, PPTX, MDB, ACCDB, PUB, RTF, TXT, HTM, JPG, PNG, TIF, EMF, WMF, XML, WRI, ODT, ODP, ODS, WMV, AVI, PDF.
The most popular Excel keyboard shortcuts
1. Navigation shortcuts in Excel spreadsheets
- Key ← ↑↓ →: Move left, up, down, right in the spreadsheet.
- Home: Moves to the first cell in the row.
- Ctrl + Home: Moves to the first cell of the worksheet.
- Ctrl + End: Moves to the last cell containing the content on the worksheet.
- Ctrl + F: Displays the search and replace dialog (opens the search field).
- Ctrl + H: Displays the search and replace dialog box (replaces available).
- Shift + F4: Repeat previous search.
- Ctrl + G (F5): Displays the "Go to" dialog box.
- Ctrl + ←/→: Moves to the left or right of the cell.
- Alt + : Displays the AutoComplete list.
- Ctrl + ← ↑↓ →: Move to the edge cells of the data area.
- Page Down/Page Up: Scroll to the bottom/top of the worksheet.
- Alt + Page Down/Page Up: Move right/left of the worksheet.
- Tab/Shift + Tab: Move 1 cell to the right/left in the worksheet.
2. Data Format Shortcuts
Format cells:
- Alt + ': Displays the Style dialog box.
- Ctrl + 1: Displays the Format dialog box.
- Ctrl + B (Ctrl + 2): Apply or cancel bold formatting.
- Ctrl + I (Ctrl + 3): Apply or cancel italic formatting.
- Ctrl + U (Ctrl + 4): Apply or remove the underline.
- Ctrl + 5: Apply or remove strikethrough formatting.
Align cells:
- Alt + H , A, I: Align cells to the left.
- Alt + H, A, R: Align cells to the right.
- Alt + H , A, C: Center the cell.
Number format:
- Ctrl + Shift + $: Apply currency formatting to 2 decimal places.
- Ctrl + Shift + ~: Apply General-style number formatting.
- Ctrl + Shift + %: Apply percentage format without decimal places.
- Ctrl + Shift + #: Apply date formatting as: day, month, and year.
- Ctrl + Shift + @: Apply time format: hours, minutes including AM/PM.
- Ctrl + Shift + !: Apply a number format with 2 decimal places and a minus sign (-) to negative values.
- Ctrl + Shift + ^: Apply scientific number formatting to 2 decimal places.
- F4: Repeat last format selection.
3. Shortcuts when using formulas
- =: Start a recipe.
- Alt + = : Insert AutoSum formula.
- Ctrl + Shift + Enter: Enter the formula as an array formula.
- F4: After typing the cell reference as the absolute reference.
- F9: Calculates all tables in all worksheets.
- Shift + F9: Calculate active worksheet.
- Ctrl + Shift + U: Toggle the formula bar to expand or collapse.
- Ctrl + ': Toggle the display of formulas in cells instead of values.
- Shift + F3: Displays the Insert Function dialog box.
- Ctrl + A: Displays the input method after entering the name of the formula.
- Ctrl + Shift + A: Inserts arguments in a formula after entering the name of the formula.
- Shift + F3: Insert a function into a formula.
4. Manipulating selected data
Select cells:
- Ctrl + Shift + *: Selects all area around running cells.
- Ctrl + A (Ctrl + Shift + spacebar): Select all worksheets (or areas containing data).
- Ctrl + Shift + Page Up: Selects the current and previous Sheet in the same Excel file.
- Shift + arrow keys: Extend selection from 1 selected cell.
- Ctrl + Shift + arrow keys: Extend the selected range to the last cell in a row or column.
- Shift + Page Down/Page Up: Extends the selected area to the bottom of the page/to the top of the screen.
- Shift + Home: Extends the selected range to the first cell of the row.
- Ctrl + Shift + Home: Extends the selection to the first of the worksheet.
- Ctrl + Shift + End: Extends the selection to the last cell used on the worksheet (lower right corner).
- Shift + Space: Select all rows.
- Ctrl + Space: Select all columns.
Manage selections:
- F8: Enables expanding selection without having to hold down the Shift key.
- Shift + F8: Adds 1 (adjacent or non-adjacent) range of cells to select. Use the arrow keys and Shift + arrow keys to add to the selection.
- Enter/Shift + Enter: Moves the current cell selection down/up within the currently selected range.
- Tab/Shift + Tab: Moves the current cell selection right/left within the currently selected area.
- Esc: Remove the selected area.
Edit in cell:
- Shift + ←/→: Select or deselect 1 character to the left/right.
- Ctrl + Shift + ←/→: Select or deselect 1 word from the left/right side.
- Shift + Home/End: Selects from the text cursor to the beginning/end of the cell.
5. Keyboard shortcuts for inserting and editing data
Working with Clipboard:
- Ctrl + C: Copy the contents of the selected cell.
- Ctrl + X: Cuts the contents of the selected cell.
- Ctrl + V: Pastes content from clipboard into selected cell.
- Ctrl + Alt+ V: Displays the Paste Special dialog box (in case the data is in the Clipboard).
Shortcut to edit inner cell:
- F2: Edits the selected cell with the mouse pointer at the end of the line.
- Alt + Enter: Move down a new line in the same cell.
- Backspace: Deletes the character to the left of the text cursor, or deletes selections.
- Delete: Deletes the character to the right of the text cursor, or deletes selections.
- Ctrl + Delete: Delete text to the end of the line.
- Ctrl + ;: Inserts the current date into the cell.
- Ctrl + Shift +:: Insert current time.
- Enter: Complete 1 cell input and move down to the cell below.
- Shift + Enter: Finish entering 1 cell and move up to the cell above.
- Tab/Shift + Tab: Complete enter 1 cell and move to the right/left cell.
- Esc: Cancel editing in 1 cell.
Undo/Redo Shortcut:
- Ctrl + Z: Undo previous action (Undo).
- Ctrl + Y: Go to next action (Redo).
Edit active or selected cells:
- Ctrl + D: Copy the content in the box above.
- Ctrl + R: Copy the contents of the left cell.
- Shift + F10, then M: Delete comment.
- Alt + F1: Create and insert a chart with data in the current range.
- F11: Create and insert a chart with data in the current range in a separate chart sheet.
- Ctrl + K: Inserts a link.
- Enter (in a cell containing a link): Activate the link.
- Ctrl + ": Copy the cell contents above and in editing state.
- Ctrl + ': Copy the formula of the cell above and in editing state.
- Ctrl + –: Displays the delete cell/row/column menu.
- Ctrl + Shift + +: Displays the insert cell/row/column menu.
- Shift + F2: Insert/Edit 1 comment cell.
Hide/show elements:
- Alt + Shift + →: Group of rows or columns.
- Alt + Shift + ←: Ungroup rows or columns.
- Ctrl + 9: Hide selection.
- Ctrl + Shift + 9: Unhide the hidden row in the selection.
- Ctrl + 0: Hides the selected column.
- Ctrl + Shift + 0: Unhide the hidden column in the selection.
Combining the most popular Word shortcuts
1. Basic keyboard shortcuts in Word
- Ctrl + N: Create a new document page.
- Ctrl + O: Open the document.
- Ctrl + S: Save the document.
- Ctrl + C: Copy text.
- Ctrl + X: Cut the selected content.
- Ctrl + V: Paste text.
- Ctrl + F: Enable the search dialog.
- Ctrl + H: Enables the replace dialog.
- Ctrl + P: Opens the print window.
- Ctrl + Z: Go back 1 step.
- Ctrl + Y: Restores the current state of the text before executing the Ctrl + Z command.
- Ctrl + F4, Ctrl + W, Alt + F4: Close window/text.
2. Shortcuts with text or objects
Feature Shortcuts:
- Ctrl + A: Select all text.
- Shift + →: Select 1 character after.
- Shift + : Select 1 character ahead.
- Shift + : Select 1 row above.
- Shift + : Select 1 row below.
- Ctrl + Shift + →: Select 1 from the following.
- Ctrl + Shift + ←: Select 1 from the front.
Text formatting shortcuts:
- Ctrl + B: Format text in bold.
- Ctrl + I: Format italic text.
- Ctrl + U: Underline formatting.
- Ctrl + D: Opens the font formatting dialog box.
- Ctrl + E: Center the selected text.
- Ctrl + J: Aligns the selected text.
- Ctrl + L: Left-align the selected 3̉n paragraph.
- Ctrl + R: Right align the selected 3̉n paragraph.
- Ctrl + M: Indent text.
- Ctrl + Shift + M: Remove indentation.
- Ctrl + T: Indent the 2nd line onwards of paragraph 3̉n.
- Ctrl + Shift + T: Removes 2nd line indentation and beyond.
- Ctrl + Q: Removes paragraph alignment formatting 3̉n.
- Ctrl + Shift + C: Copy all data area formats.
- Ctrl + Shift + V: Paste copied formatting.
Keyboard for deleting text/objects:
- Backspace: Delete 1 character in front.
- Delete: Deletes one character after the cursor or selected objects.
- Ctrl + Backspace: Delete 1 word in front.
- Ctrl + Delete: Delete 1 word from behind.
Move Shortcut:
- Ctrl + ←/→: Move left/right 1 character.
- Ctrl + Home: Go to top of text 3̉n.
- Ctrl + End: To the end of the text.
- Ctrl + Shift + Home: Selects from current position to beginning of text 3̉n.
- Ctrl + Shift + End: Selects from the current position to the end of the text 3̉n.
3. Shortcuts for Menus and Toolbars
- Alt, F10: Activate Command Menu.
- Ctrl + Tab, Ctrl + Shift + Tab: Executed after the menu bar is activated, used to select between Menu bars and Toolbars.
- Tab, Shift + Tab: Selects the next or previous button on the Menu or Toolbars.
- Enter: Executes the current command on the Menu or Toolbars.
- Shift + F10: Displays the context menu of the currently selected object.
- Alt + Spacebar: Displays the System Menu of the window.
- Home, End: Select the first or last command in the Submenu.
4. Dialog shortcut
- Tab: Moves to the next selection, select group.
- Shift + Tab: Moves to the selection, the previous selection group.
- Ctrl + Tab: Moves to the next tab in the dialog box.
- Shift + Tab: Moves to the previous tab in the dialog box.
- Alt + Underline: Select or deselect the item.
- Alt + ↓: Displays a list of drop-down lists.
- Enter: Select a value from the drop-down list.
- Esc: Turns off the content of the drop-down list.
5. Keyboard shortcuts with tables
- Tab: Move to and select the contents of the next cell. Or create a new line if you are standing in the last cell in 3̉ng.
- Shift + Tab: Move to and select the contents of the adjacent cell.
- Hold Shift + ← ↑↓ →: Select the contents of the cells before, above, below, after.
- Ctrl + Shift + F8 + ↑↓ →: Expand selection by table cell.
- Shift + F8: Reduces the size of the selection cell by cell.
- Ctrl + 5 (when Num Lock is off): Select content for the entire 3̉ng.
- Alt + Home: Returns to the first cell of the current line.
- Alt + End: Returns to the last cell of the current line.
- Alt + Page Up: Go to the first cell of the column.
- Alt + Page Down: Go to the last cell of the column.
- ↑: One line up.
- ↓: One line down.
6. Shortcut to create index
- Ctrl + Shift + =: Create superscript.
- Ctrl + =: Create subscript.
7. Shortcut from F1 - F12
- F1: Help.
- F2: Move 3̉n text or images.
- F3: Insert text automatically.
- F4: Repeat last action.
- F5: Execute Goto command.
- F6: Moves to the next Panel or Frame.
- F7: Perform a spell check command.
- F8: Extend selection.
- F9: Update for selected fields.
- F10: Activate the Command Menu bar.
- F11: Moves to the next field.
- F12: Execute the save command with a different name.
- Shift + F1: Displays the help pointer directly on objects.
- Shift + F2: Quickly copy text 3̉n.
- Shift + F3: Convert uppercase to lowercase.
- Shift + F4: Repeat the action of the Find, Goto command.
- Shift + F5: Moves to the position with the last change in text 3̉n.
- Shift + F6: Moves to the previous adjacent Panel or Frame.
- Shift + F7: Perform a synonym search.
- Shift + F8: Shorten selection.
- Shift + F9: Toggle between the code and the result of a field in text 3̉n.
- Shift + F10: Show context menu (corresponding to right-click).
- Shift + F11: Moves to the previous adjacent field.
- Shift + F12: Execute the command to save the document.
- Ctrl + F2: Execute print preview command.
- Ctrl + F3: Cut a Spike.
- Ctrl + F4: Close the 3̉n text window (do not close the Word window).
- Ctrl + F5: Restores the size of the text window 3̉n.
- Ctrl + F6: Moves to the next 3̉n text window.
- Ctrl + F7: Execute the move command on the system menu.
- Ctrl + F8: Execute command to resize window on system menu.
- Ctrl + F9: Inserts a blank field.
- Ctrl + F10: Maximizes text window 3̉n.
- Ctrl + F11: Lock a field.
- Ctrl + F12: Execute command to open text 3̉n.
- Ctrl + Shift + F3: Insert content for Spike.
- Ctrl + Shift + F5: Edit Bookmarks.
- Ctrl + Shift + F6: Moves to the previous text window.
- Ctrl + Shift + F7: Update text from linked source documents.
- Ctrl + Shift + F8: Extend selection and block.
- Ctrl + Shift + F9: Unlink a field.
- Ctrl + Shift + F10: Kích hoạt thanh thước kẻ.
- Ctrl + Shift + F11: Mở khóa 1 trường.
- Ctrl + Shift + F12: Thực hiện lệnh in.
- Alt + F1: Di chuyển tới trường tiếp theo.
- Alt + F3: Tạo 1 từ tự động cho từ đang chọn.
- Alt + F4: Thoát khỏi Word.
- Alt + F5: Khôi phục kích thước cửa sổ.
- Alt + F7: Tìm các lỗi chính tả và ngữ pháp tiếp theo trong văn bản.
- Alt + F8: Chạy 1 Marco.
- Alt + F9: Chuyển đổi giữa mã lệnh và kết quả của toàn bộ các trường.
- Alt + F10: Phóng to cửa sổ Word.
- Alt + F11: Hiển thị cửa sổ lệnh Visual Basic.
- Alt + Shift + F1: Di chuyển tới trường phía trước.
- Alt + Shift + F2: Thực hiện lệnh lưu văn bản.
- Alt + Shift + F9: Chạy lệnh GotoButton hay MarcoButton từ kết quả của những trường trong văn bản.
- Alt + Shift + F11: Hiển thị mã lệnh.
- Ctrl + Alt + F1: Hiển thị thông tin hệ thống.
- Ctrl + Alt + F2: Thực hiện lệnh mở văn bản.
