归档： Cordelia
-
How to Add Covers to Word Documents
If you want a beautiful cover page for your document in Word, of course you can design it by yourself elaborately. But if you don’t want to spend too much time on it, try making use of the templates of covers provided by Word! Open the document you want to add a cover. Switch to […]
-
How to Stop the Automatic Capitalizing of the First Letter in Word
While editing documents in Word, the first letter we input in every sentence will be automatically capitalized. It’s convenient in most of situations, but not all. How can we stop Word from capitalizing the initial letter automatically if we don’t need? First, open any of the word file. Switch to File tab and choose Options. […]
-
How to Rotate the Text in Word 2016
When you are designing a Word document, you may need to make some changes to the text for aesthetic reasons such as reversing the characters. Here I’d like to give a simple guide of how to rotating the text based on Word 2016. First of all, typing the text in Word document with the font […]
-
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 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 […]
