标签：format cells
-
Five Ways To Find Day Of Week From Date In Excel
If you want to quickly find out what day of the week it is, are you ready to turn on your phone calendar right away? In Excel, there are actually five ways to quickly figure out what day of the week any date is. Let’s get started. No.1 Format Cells Select the area of dates […]
-
How To Lock Excel Formulas To Protect Them?
Sometimes, we just want others to see the number, but couldn’t see how the number came from. There is a nice way that works. Click on the green triangle to select the whole sheet. Then right-click and choose Format Cells in the list. Go to protection, and uncheck the Locked box. Press F5 to quickly […]
-
Excel 2016 Help: Solutions to 7 Common Problems
In our daily using Microsoft Excel, we can often encounter some knotty questions. This tutorial is a guide to tell you how to do it. Q1：Why these 0 disappeared？ When you enter a string of numbers starting with 0 in the cell, you will find that all the zeros at the beginning are gone. You can […]
-
How to Quick Input Specific Words or Text in Microsoft Excel
If you want to type a great many repeated data in an Excel file like the information of gender, department, etc. There’s a quick way in addition to add drop-down list, which allows you to enter just a simple number and make it shown as specific word or text. Let’s see the detailed steps. Assuming […]
-
How to Hide and Protect the Formulas You Used in Excel
As the work requires, you may send your Excel spreadsheet to other people at times. It means they can not only view the data, but also click any cell to check the formula it contains, or even modify it without your permission. To keep that from happening, you can try these steps to hide and […]
-
How to Fully Display Long Numbers Over 11 Characters in Excel
Have you ever input long numbers in Excel and only to find the digits in the middle have been abbreviated? It’s actually because of scientific notation, which automatically abbreviates the number over 11 digits in length. So how could we fully display long numbers in Excel? One solution for this situation is converting the property […]
-
How to Use Format Cells to Quick Enter a Series of Data in Excel
When editing Excel spreadsheet, you can hardly avoid entering a series of similar data, like departments in company, product ID, e-mail address, etc. Some of them are almost the same, just a little difference in the begging or ending, but you still need to input them completely over and over, which is quite exhausting. In […]
-
How to Calculate the Time Difference Quickly Using Excel Functions
In practice, we often need to calculate the difference of years, months, weeks or days between 2 separate dates. And like many other calculations, Excel functions can help you calculate the time difference quickly and accurately. Let’s see how to do it. Case 1: Calculate the Difference of Years Formula: =DATEDIF(A2,B2,”y”) A2, B2 corresponds to […]
-
How to Display Numbers in Excel as Cell Phone Numbers
In Excel spreadsheet, the long numbers are often displayed in segments, which is not only easy to view, but also more standardized. So how to segment long numbers in Excel cells and make them displayed as cell phone numbers? You can solve this kind of problem simply by change the setting in Format Cells. 1. […]
