归档： 2019 August 01
-
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 […]
