Recommanded Excel Recipes
-
How to Embed SWF File in Microsoft Excel
-
Perhaps, you often insert movies or other videos into PowerPoint Presentations. You may have never heard that you can embed videos into Excel file. Yes, it is cool. Well, I will show you how to embed SWF file in Microsoft Excel.
Excel : Tutorials, Troubleshooting, Tips and Tricks
Sort By :
- How to Convert PDF files to Excel spreadsheet
- People often need to extract the data from PDF to Excel for further analysis or connecting with the ERP system. So many people may retype the data again. In fact, you can easily convert the PDF into Excel spreadsheet with a good PDF to Excel Converter.
- How to Protect a worksheet in Excel
- After you have completed your Excel worksheet, maybe you want to prevent others from changing the worksheet accidentally. To achieve this, you can protect the worksheet. Here I will show you how to protect a worksheet in Excel.
- How to Paste Special in Excel
- When we copy some cells in Excel, we copy the format and formula as well. Sometimes the paste is just what we want, but sometimes we just want the content not the format. Then we will use the function of Paste Special. Here I will show you how to paste special in Excel.
- How to Add a Header or Footer to the Reports in Excel
- When we make a report in Excel, we can add head and footer to the reporter to make report contains more information, such as you name, the date and page number. Here I will show you how to add a header and footer to the reports in Excel.
- How to Copy or Move Range in Excel
- When we work with our Excel worksheet, we need to copy or move a range of information for some reason. Excel provides us several methods to make it. Here I will show you how to copy or move range in Excel.
- How to Change the Look of a Table in Excel
- When we create a table in Excel, it has a default table style. We can change the look of the table to make our worksheet more beautiful and understandable. For example, we can change the tables fill color and font color. Here I will show you how to change the look of a table in Excel.
- How to Hide or Show the Formula Bar in Excel
- Formula bar is very useful for you to enter and edit data, particularly when a cell contains a formula or a large amount of information, instead of editing directly in your worksheet. The following steps will show you how to hide or show the formula bar in Excel.
- How to Insert Copied or Cut Cells in Excel
- You can simply cut and paste new information into the blank rows or columns in Excel. In some cases, you may want to insert information into an existing row or column. Now the following steps will show you how to insert copied or cut Cells in Excel.
- How to Add, Delete and Hide Worksheet in Excel
- When you open a workbook in Excel, you get three blank worksheets automatically in it. You can easily add more worksheets. If you want to get rid of information you don’t want, you can just delete the worksheets or hide a worksheet temporarily. The following steps will show you how to add, delete an
- How to Enable or Disable Error Checking in Excel 2010
- When we use Microsoft Excel to deal with data, it is necessary for us to insert all kinds of formulas. So it is possible that we may make some errors with formulas. And Microsoft Excel provides a good and useful tool for error checking. First, you need to know how to enable or disable error checking
- How to Annotate a Worksheet with Comments in Excel 2010
- You can add notes to a worksheet by using comments. Using comments can help you make a worksheet easier to understand by providing additional context for the data it contains. For example, you can use a comment as a note that provides information about data in an individual cell. You can also add a
- How to Wrap Text in a Cell in Excel 2010
- When you put a long text in a cell, you may find it is not visible all the time. At this time, if you want text to appear on multiple lines in a cell, you can format the cell so that the text wraps automatically. Also, you can enter a manual line break. Here, I will tell the first method which is a
- How to Display Numbers as Fractions in Excel 2010
- I always use data as fractions in Microsoft Excel because the original data I need to deal with is in this format. But I find it is quite trouble that when I type the data as fractions as usual, it is converted the date format. It is so bad that I have to convert the original data to decimal format.
- How to Change the Default Font in Excel 2010
- When I use Microsoft Excel 2010 in my computer, it always provide "Arial Unicode MS" font with the size 11. This default font brings me a lot of trouble. Each time I need to change the font manually. So could I change the default settings and set my own default? If so, how should I do?
- How to Change the Color of Gridlines in a Excel 2010 Worksheet
- Gridlines in Microsoft Excel 2010 are displayed in worksheet using the color that is assigned to Automatic, usually black color by default. If you don't like this color and want to change the color of gridlines, you can use the following procedure. It is pretty simple.
- How to Find and Search within a String in Excel
- In Microsoft Word, we can find letters or words using Find and Search functions in the ribbon. In Excel, we can also use the functions. We can use the two functions by typing formula to find and search within a string. Here I will tell you how to achieve it.
- How to Display Data Labels in a chart in Excel
- Sometimes we want the chart in Excel display the actual number of each data. This will help us to analysis the chart more conveniently. Here I will show you how to display data labels in a chart in Excel.
Write a Recipe
Recommend a Software
Narrow Results by Related Topics or Software
