标签：Excel
-
How to Speed Up the Boot Time of Excel
When you open an Excel file on your computer and find the startup speed is rather slow, it’s may not due to the size of the file, but the quantity of add-ins. To improve the boot speed of Excel, you can try disabling some add-ins. Let’s see how to achieve it. Choose Options in File […]
-
How to Change the Background of the Chart Area in Excel
If you’ve inserted a chart in the Excel file, you can change the chart style to make it fit your taste. But do you know how to change the background of the chart? The method is also simple. First, open the file, right-click the chart you want to adjust. Please note that if the place […]
-
How to Restore the Default Setting of Excel
We may make some changes to the setting of Excel in the process of editing files like adding ribbons and quick access toolbars. But if we don’t want those changes after opening a new file, how can we restore the default setting of Excel? First, switch to File tab in the new file. Click Options […]
-
How to Import Data from HTML into Excel
If you have some brilliant tables on your computer but not in Excel format, can you import the data from them to Excel directly? In one of my previous post I’ve introduced how to convert TXT to Excel. Here I’d like to share the tip of importing the data from HTML to Excel as well. […]
-
How to Copy a Sheet to Another Excel File
It’s convenient to copy and paste a table in the same sheet or even workbook. But copying & pasting a sheet between two or more files might cause some problems. I’d like to share a method here to copy worksheets across Excel files. Open the two files you want to copy and paste the sheet. […]
-
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 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 […]
