Categories：Excel Tips
-
How to Insert Alternate Blank Rows in Excel Spreadsheet
It’s not rare to insert a blank row between 2 existing rows as a new header while making specific spreadsheets like salary sheets. Instead of right-clicking one cell and choose to insert a new row manually, you can actually batch create new rows alternatively using AutoFill and Go To feature of Excel. Open the worksheet […]
-
How to Add a Number to All Cells in Excel
While editing a spreadsheet in Microsoft Excel, you may encounter a situation which requires you to add a number to all cells in a column or a table. Doing the calculation manually and filling the cells one by one is apparently not the best idea. In fact, you can use Paste Special to achieve this […]
-
How to Use Conditional Formatting to Shade the Specified Data in Excel
The so-called Conditional Formatting, is a practical feature with which Excel can set the format of the corresponding data. One example is that when you want to highlight some specified data in a spreadsheet, you can use Conditional Formatting to shade them automatically avoiding a lot of manual operations. First, select the range of cells […]
-
How to Print a Part of a Spreadsheet in Microsoft Excel
Printing out a spreadsheet in Excel may not be a hard thing for you, but there’re also some tips can make you do the job better. For example, if you just want to print a part of the table in the worksheet, and it can hardly fill the width of a A4 paper, you’d better […]
-
How to Add Frames to Pictures in Microsoft Office
To make some basic adjustments to pictures that you want to insert into Office programs, you don’t need to find any third party picture editing tools, MS Office can help you do most of the things. And the steps are all the same in Microsoft Word, Excel, and PowerPoint. For example, if you want to […]
-
How to Insert a Text Box to Excel Worksheets
Different from the text in cells, a text box can be placed at anywhere in Microsoft Excel as the label or comment of the spreadsheet in a separate window. To insert a text box, you should switch to Insert tab at first, then find the button of Text Box in Text section. Click it to […]
-
How to Paste Data Skipping Blanks in Microsoft Excel
Copy and paste is a basic operation in Microsoft Excel that should be familiar to everyone. But what if you need to copy a column of data with blanks to another column? If you copy it directly, the data in the target column would be overwritten by the blanks. You can also, of course, copy […]
-
How to Change the Color of a Picture in Microsoft Office
Working with Microsoft Office programs often requires you to insert pictures to make the documents more informative and lively. But the pictures are not always suitable from the beginning. If you aren’t going to use any of the graphics processing tools on the market, you can turn to Office itself which has some basic functions […]
-
How to Enter the Same Data in Non-Adjacent Cells in Excel
It’s not difficult to autofill multiple cells with the same data or text. But most of the existing methods require these cells to be continuous. In fact, entering the same data in non-adjacent cells is probably more common in practical terms. If you’ve also been in this situation, try this small trick: First, press the […]
-
How to Change the Default Save Location in Microsoft Excel
When you done with a workbook and save it, Excel will save it to My Documents folder automatically. But sometimes you need to save the workbook to another folder which is more consistent with the use of your habits. In this case, you need to select the correct location in the Save As dialog box, […]
