Categories: Excel Tips
-
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. […]
-
2 Tips of How to Switch Between Multiple Worksheets Quickly in Microsoft Excel
While dealing with many worksheets at the same time, you will certainly need to switch between them. If you know how to switch between multiple worksheets quickly, it could definitely save a lot of time and avoid possible mistakes. Here I’ d like to share two tips of it. Tip 1. Switch Windows in View […]
