Office
Lesson 30: How to save Excel files in 97 – 2003 format
If you save the file Excel files in 97-2003 format (.xls instead of the new .xlsx format), users who don't...
Read moreDetailsLesson 31: How to use Zoom – zoom the interface in Excel
In most cases, you can use the minus and plus icons on the status bar to zoom in Excel. Use...
Read moreDetailsLesson 32: How to use Split (split) worksheets in Excel
Split (split) your sheet to view multiple parts of the sheet at once in Excel. You can split the sheet...
Read moreDetailsLesson 33: How to use Freeze Panes – Fix columns when scrolling in Excel
If you have a large data table in Excel, it can be very helpful to freeze rows or columns. This...
Read moreDetailsLesson 34: How to group sheets – Merge Sheets into Groups in Excel
You can group sheets in Excel if you want to edit multiple sheets at once. My workbook (workbook) contains 3...
Read moreDetailsLesson 35: How to merge worksheets to process data in different Excel files
You can use the Consolidate feature in Excel to merge your worksheets (located in one workbook or multiple workbooks) into...
Read moreDetailsLesson 36: How to view multiple worksheets at once in Excel
If you want to view multiple sheets at once in Excel then you can do the following steps. Join the...
Read moreDetailsLesson 37: How to get the sheet name in Excel
You can get the name of the sheet using CELL, FIND and MID in Excel. There is no built-in function...
Read moreDetailsLesson 38: How to check spelling in Excel
Learn how to check spelling of text in Excel, add words to a custom dictionary or AutoCorrect list, and learn...
Read moreDetailsLesson 39: How to reverse decimal places in Excel
In this article, we will learn how to move decimal places further back in Excel without changing that number. You...
Read moreDetails
AnonyViet
AnonyViet is a website share knowledge that you have never learned in school!
We are ready to welcome your comments, as well as your articles sent to AnonyViet.