标签:Excel
-
How to Insert a Text Box to Excel Worksheets
Different from the text in cells, a text box can be placed at anywhere in Microsoft Excel as the label or comment of the spreadsheet in a separate window. To insert a text box, you should switch to Insert tab at first, then find the button of Text Box in Text section. Click it to […]
-
How to Paste Data Skipping Blanks in Microsoft Excel
Copy and paste is a basic operation in Microsoft Excel that should be familiar to everyone. But what if you need to copy a column of data with blanks to another column? If you copy it directly, the data in the target column would be overwritten by the blanks. You can also, of course, copy […]
-
How to Change the Color of a Picture in Microsoft Office
Working with Microsoft Office programs often requires you to insert pictures to make the documents more informative and lively. But the pictures are not always suitable from the beginning. If you aren’t going to use any of the graphics processing tools on the market, you can turn to Office itself which has some basic functions […]
-
How to Enter the Same Data in Non-Adjacent Cells in Excel
It’s not difficult to autofill multiple cells with the same data or text. But most of the existing methods require these cells to be continuous. In fact, entering the same data in non-adjacent cells is probably more common in practical terms. If you’ve also been in this situation, try this small trick: First, press the […]
-
How to Change the Default Save Location in Microsoft Excel
When you done with a workbook and save it, Excel will save it to My Documents folder automatically. But sometimes you need to save the workbook to another folder which is more consistent with the use of your habits. In this case, you need to select the correct location in the Save As dialog box, […]
-
How to Insert a Per Mille Sign in Microsoft Excel
Making spreadsheets in Microsoft Excel often involves mathematics, which probably requires you to type percentages and per mille in the cell. So, how to enter them in an Excel sheet? You may already know that a percentage sign (%) can be typed with pressing Shift+5. But the way to insert a per mille sign (‰) […]
-
How to Make a Treemap in Microsoft Excel
Treemap is a simple chart in which you can see the value of each item from the spreadsheet clearly and intuitively. It’s a little bit like pie chart but not that focusing on showing each item’s share of the total. If you’d like to try creating a treemap in your Excel file, here’s the method: […]
-
How to Change the Color of Tabs in Microsoft Excel
The color of inactive sheet tab is gray, and active or selected sheet tab is white by default in Excel. If you have a lot of sheets to deal with, it might be hard to find a specific one quickly. In this case, you could change the color of tabs to differentiate sheets. So how can […]
-
How to Change the Resolution of Microsoft Excel
A high resolution in Excel will significantly increase the size of the document. Accordingly, you can control the file size by selecting a proper resolution. For example, if you need to send an EXCEL file with mail, free up more space on your hard drive, or reduce its upload / download time on Internet, you […]
-
How to Search Data in Microsoft Excel
This might occur to you some time when you use specific data incorrectly while working with Excel. What’s worse, the data reappears in the file irregularly, which means you will spend a lot of time searching and modifying. Here I’ d like to share the tip of how to search data in Excel. Here’s the […]