Categories：Excel Tips
-
How to Change the Color of Gridline in Excel
If you are tired of the default grey grids of Excel, try refresh your eyes with a new color. Here’s a simple guide of how to change the color of Excel gridlines. Open any of your Excel file. Click File tab – Options. Click Advanced and then scroll down to find Display options for this […]
-
How to Change the Default Column Width in Excel
When you open a new Excel file, the cells present in front of you have their own default data of width. If you have a certain need and don’t want to adjust the width of each cell one by one, you can change the default width of columns. Click Home tab, find Format in the […]
-
How to Set Horizontal Alignment in Excel as Fill
In Home tab of Excel, you can set the horizontal alignment as Align Left, Align Center or Align Right easily. But if you want to make the content you typed to fill a cell automatically no matter how wide the cell is, these basic alignments may can’t satisfy you. Take this table as an example. […]
-
How to Hide the Content in an Excel Cell
I’ve introduced how to hide cells (precisely speaking, rows or columns) in Excel. In this post I’ll share another trick about hiding the content of one or multiple specified cells without affecting the structure of the table. And the best thing is, when you double-click that cell, the content will show again. In this table […]
-
How to Import Data from TXT to Excel
Not all the people are used to organize information with Excel all the time. Sometimes we already have the data recorded in Word or TXT and want to import them to Excel for convenience and intuition. How can we convert all the text content into a table? The first step is organizing the data in […]
-
How to Merge Duplicate Cells and Calculate the Summation in Excel
In actual statistics, a person or an item could appear multiple times in the list with different values followed. We can’t simply delete any of them. Instead, we need to combine these cells and sum their values. So how can we achieve it? Look at the table below. It’s apparently that there’re 2 person show […]
-
How to Insert a Superscript in Microsoft Excel
Sometimes you can’t avoid the units with superscripts in Excel sheet such as m2 and m3. Inserting superscripts in Excel is not as easy as in Word. Let’s see how to achieve it. Now I want to input m2 in Excel, so I type m2 in the cell first. Select the content you want convert […]
-
How to Freeze Specific Cells in Microsoft Excel
A large table with tons of data usually can’t be fully displayed in a single page. You must scroll down or scroll to the right for a more complete viewing. In order to correspond these data with the title or other key content intuitively, you can freeze some specified cells in the table. In this […]
-
How to Remove the Dotted Borders in Excel
Have you ever seen one or more dotted borders in your Excel worksheet? It appears all of a sudden and can’t be deleted by normal means, which could be quite annoying. This kind of dotted line is actually caused by the switching of workbooks views. You can see this feature in View tab or the […]
-
How to Copy Excel Formulas to Multiple Cells or Entire Column
If you have tons of data to deal with in a spreadsheet, it’s much more convenient to use Excel functions instead of manual calculations. But inputting formulas in each cell can also take a lot of time. Is there a way to enter it just once and apply the formula to multiple cells within seconds? […]
