Categories：Excel Tips
-
how to Quick Capitalize the First Letter or Each Word in Excel
When entering some specific information like company names or employee names into an Excel sheet, you may want to capitalize the first letter of each word in each cell. But instead of changing the text case one by one, can you do it in batch? 1. First of all, you can create a new column […]
-
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. […]
-
How to Print Excel Documents in Black and White
Some documents are not suitable for color printing, you may want to set the printer to black and white. So how can we achieve it? Here’s a simple guide. 1. First, click File in the upper left corner. 2. Then, click Print in the left-hand list box. 3. Next, click Page Setup at the right […]
-
How to Insert Data Bars or Directional Icons to Excel Cells
Excel can not only process data quickly, but also display data in various ways intuitively. For example, you can insert data bars or directional icons to show numerical value of each cell in Excel. And the method is very simple. How to Insert Data Bars 1. Select the cells you want to add data bars. […]
-
How to Circle All the Invalid Data in Excel at Once
It’s not surprising that there’s some invalid data in an large Excel spreadsheet. If you want to screen out all of them at once, the best idea is to set Data Validation in Excel, and then choose to Circle Invalid Data. Here’re the detailed steps: 1.Select the cells. 2.Go to Data tab. 3.Click Data Validation […]
-
How to Sort Excel Cells by the Number of Characters
If most of the data in an Excel spreadsheet is text, and each cell has a different length of content, it may look untidy on the whole. For this situation, you can sort these cells by the number of characters. But as you know, there’s no such an existing sorting rule to use directly. Before […]
-
How to Recover an Unsaved File in Microsoft Word, Excel or PowerPoint
If you close a file in Microsoft Word, Excel or PowerPoint before saving it by accident, take these steps to recover the unsaved content in Office instead of restarting your hard work. 1. You might unexpectedly click Don’t Save button in Microsoft Office dialog box. 2. Click File at top left in the Ribbon. 3. […]
-
How to Multiply Numbers in Microsoft Excel Quickly
Multiplication and division are very common in mathematics as well as in Excel calculations. To multiply numbers in Excel, there’re 2 simple ways you can try. I’ll share the detailed steps in this post. Method 1: Using Formula to Multiply 1. Click the cell for outputting the calculation result. 2. Input the formula directly: =A2*B2 […]
-
How to Quickly Enter a Long Number with Multiple Zeroes in Excel
When making the table about financial capital in Excel, we often enter some long numbers such as amount ninety thousand, fifty million or others contain more zeroes. They might make give you a headache and it is also very easy to cause input problems. So how can we quickly enter a long number with multiple […]
-
How to Highlight All the Nonworking Days in Excel Spreadsheet
If you entered a series of dates into Excel spreadsheet, and want to highlight all the nonworking days. Do you have to pick out the weekends manually? In my previous post, I’ve introduced some uses of the powerful Conditional Formatting. It enables you to apply a format to multiple cells that meet the specific criteria. […]
