Categories：Excel Tips
-
How to Clear the Format of a Table in Microsoft Excel
Sometimes you may not be satisfied with the current format of an Excel sheet and want to reconstruct it from the beginning. Clearing the format at once is the best idea at this point comparing to cancel each operation you’ve done. So how to do it exactly? 1. Drag your mouse to select the whole […]
-
How to Enable Autosave in MS Excel to Protect Your Data
An Excel sheet containing many complicated data can take much of your time to deal with. If there’s any emergency happens in the process of editing it like power outage, switch trip or system halted, your effort may lead to no end. Therefore, we better enable the autosave feature in Excel. 1. Click File, and […]
-
How to Screen Out the Specific Data in Excel
In a large, complex Excel sheet, you can find the data meets your criteria quickly through the powerful function called Filter, while other data that doesn’t meet your need is automatically hidden by Excel. How to screen out the data that equals/larger than/smaller a specified value Using the Filter function, you can screen out all […]
-
How to Create an Inverted Histogram in Microsoft Excel
We have shared the method to make a histogram in Excel in previous post, but sometimes you might need to personalize it for special display purpose. Just follow these steps and let’s see how to create an inverted histogram in Microsoft Excel. 1. You got an original histogram in Excel worksheet, and here I take […]
-
How to Input the Same Content in Different Excel Cells or Sheets
While editing a table in Excel, it’s hard to avoid a kind of situation which requires you to input the same content in different cells or even different sheets. In this instance, using shortcut keys or shortcuts could greatly improve your efficiency. 1. Select all the cells you want to input the same content in, […]
-
How to Check Correctness of Words in Microsoft Excel
Hate to do error checking? Too many words to check? Is there a method to check correctness of words in a quick way? Here’s a simple guide for you to built a perfect worksheet in Microsoft Excel without any mistake. Below is a sample of worksheet in Excel, and there are spelling mistakes in every […]
-
How to Insert Pictures to a Microsoft Excel File
Besides texts and numbers, we can also insert multi-media files, like images to make the worksheet more vivid and informative. In this post I’ll share a simple tip to add pictures to Excel file, here are the steps: 1. Open a worksheet, click any place at the page you want to insert a picture. Then […]
-
How to Replace Specific Content in Excel Sheets More Precisely
Imagine that you have a grade table and need to replace all the “0” scores in it with “Fail”, how can you do it without replacing the “0” in other values like 60, 70? Is there a way to replace the specific content in Excel Spreadsheet more precisely? It’s a tricky situation cause normally the […]
-
How to Create an Uninterrupted Sequence in Microsoft Excel
When inserting or deleting some rows to Excel spreadsheet, the sequence number will be interrupted and become incoherent, which could also affect your counting. In fact, you can use a very simple Excel formula to create an uninterrupted sequence in a column. 1. Enter the formula: =ROW()-1 in the first cell of the sequence column. […]
-
How to Merge Multiple Cells in Microsoft Excel
While making a form in Excel, a header which takes up the width of several cells is often needed. If we have no space to add a new one, the only way may be merging existing cells. Let’s see how to merge multiple cells in Microsoft Excel. 1. Select all cells you want to merge. […]
