Giới thiệu
hocvietcode.com là website chia sẻ và cập nhật tin tức công nghệ, chia sẻ kiến thức, kỹ năng. Chúng tôi rất cảm ơn và mong muốn nhận được nhiều phản hồi để có thể phục vụ quý bạn đọc tốt hơn !
Liên hệ quảng cáo: trienkhaiweb@gmail.com
Instructions for setting a password for Sheet
When working or studying, confidential information is extremely important. You have an Excel Sheet that you don't want to share with others. You are afraid that others will change the information in your Sheet. So, you need to set a password for that Excel Sheet. The article below can help you. In the following article, […]
Instructions for setting and breaking passwords in Excel
With the nature of the work of some people requiring high security, setting a password for the data file is essential, as is in Excel. The following article will guide you in detail on how to set a password for an Excel file in the simplest way on the basis of Microsoft Excel 2013. 1.Open […]
Instructions to show and hide Sheet in Excel
When using Excel, you have too many Sheets that cannot be checked. Unused Sheets will mess up when you manipulate other Sheets. You cannot delete these Sheets. So you need to hide and show Sheet in Excel. The following article will help you. In this article, I show you how to hide and show Sheets […]
How to hide formulas in Excel worksheets
When using Excel, you use a lot of formulas in spreadsheets. However, if you don't want other people to see these recipes, you need to hide them. The following article will guide you. In this article, I hide formulas in Excel 2013. However, if you use Excel 2007, 2010, 2016, the method is similar. Example […]
How to sort data ABC(alphabet) and ascending and descending in Excel
When you work with a long Excel sheet, make sure you have some way to sort the search utility. As now, there are many people who still often use a number of ways such as sorting names in alphabetical Vietnamese alphabetical order or sorting by ascending or descending digits. So what steps do you need […]
How to sort and filter data in Excel
When using Excel, you may have to sort and filter data by a certain criterion to make it easier to compare and search. This is a pretty important function, commonly used in Excel. For spreadsheets that contain a lot of different information, sorting and filtering data will help you find the information you want more […]
Enter data using the Auto Correct function in Excel
In the process of working with Excel spreadsheets, you have to re-enter the same data many times. That way you not only get bored but also waste time. Therefore, to speed up fast data entry in Excel spreadsheets, you should use the Auto correct function. Specifically how to use it, the following article we will […]
Instructions to filter duplicate data in Excel
After filtering the duplicate data, excel is to delete the duplicate data in the excel spreadsheet. If there is too much data, manual data filtering will take a lot of time of the user. The following article will guide you through the simplest and fastest way to filter duplicate data. In this article, I guide […]
Instructions for creating and removing pagination lines in Excel
When working with Excel, you often have too long table data. When you print it out, you must edit it accordingly. This requires you to know how to show pagination lines and remove pagination lines in Excel. This article will help you. In this article, I guide you to create and remove pagination lines in […]
Instructions to hide, show and color grid lines in Excel
Gridlines are translucent lines that appear cells to distinguish them across worksheets. When using Excel, you want to remove this grid or color it for easier viewing. The following article will guide you. In this article, I show you how to hide and color grid lines for Excel 2013. However, if you use Excel 2010, […]
Instructions for copying formulas in Excel
When working with Excel, you often use formulas to calculate. A data table will have a lot of data that calculate the same formula. To save time you can copy the formula without retyping. This article will guide you to do this. In this article, I copy the formula using Excel 2013. However, if you […]
How to enter math and chemistry formulas in Excel
Are you a student or teacher? Want to use Excel to enter chemical and mathematical formulas but don't know how? The following article will guide you. In this article, I show you how to enter chemical and mathematical formulas for Excel 2013. However, if you use Excel 2007,2010,2016, the same is true. The article consists […]
Some changes in Microsoft Excel 2013
Along with the continuous development of technology, software applications are also upgraded and improved strongly. And the tool that can't be talked about is Microsoft Excel. Since its inception, it has become an indispensable working environment in office computing. Until the following versions are released, they are integrated with more user support features. So what's […]
Common errors in Excel and how to fix them
In the Microsoft Excel environment, after manipulating data, some strange characters may appear, which are some errors we accidentally create. To better understand this problem, the following article will help us make the most complete statistics of common errors in Excel. 1. ##### Width error Reason: When the data cell lacks width. When entering negative […]
Common keyboard shortcuts in Excel
To make your work more professional as well as save more time, the keyboard task is a necessary condition. Keyboard shortcuts will be a great assistant for you to complete your work. And the following article will list some of the most common keyboard shortcuts in Microsoft Excel version 2013, and basically they are supported […]
How to quickly number ordinal in Excel
Numbering in Excel is one of the basic operations when you work with data tables. However, up to this point, there are still a lot of people who number manually, so it is very time consuming. So, to take advantage of the features available in this application, today I will show you more specifically how […]
How to print any document selection in Excel
On a document file that is dozens of pages long but you only want to use and print a part of that document, how do you do that? There will be different ways to handle it, some people will retype that part of the text, some people will copy to a new File and then […]
How to quickly number pages in Excel
Are there many Excel users who don't know if Excel data needs to be numbered or not? Most, in many cases, you don't need to type. However, there are also cases where you need to number the pages to make them easy to distinguish. So how to number pages in Excel is also a question […]
How to write italic with multiple angles on Excel
Sometimes at work, you need to create italic lines in a certain format in Excel tables. However, you do not know how to do? You are completely assured. It will not be difficult if you follow the steps below that I am about to show you. Excel is one of the working tools that is […]
How to close parentheses and highlight negative numbers in Excel
Excel is known as a spreadsheet that is used by many people in their daily work, especially for those who work in the accounting field. When you work with Excel, it allows you to use many different types of numbers. Therefore, so that when looking at the spreadsheet, it is easy for readers to distinguish […]
