Microsoft Excel is a very popular software among professional and everyday users. What you may not know is that Excel can do a lot more than you think. You could be missing out on some great functions and not be aware of it. The following tips will help you get things done faster and impress others in the process.
Eliminate Blank Cells
If you’re working with an Excel document with tons of Excel data, this is a trick worth trying. Select the column or row with the blanks and press Ctrl + G.
When the window appears, click on the “Special” button and choose Blanks. Click Ctrl + -, then “Shift cells up,” and OK.
Modify the Size of the Rows and Columns
The size of the cells in Excel may not always be the one you need. If you need to adjust the size, select the row or column you want to change and choose the Home tab.
Click the “Format” option and click on “Row Height” to make the cell taller. To make the cell wider, click on “Column Width” and enter the measurement you need.
Add and Remove Columns, Rows, or Cells
With the “Insert” and “Remove” commands, you can add or delete as many rows, cells or columns as you want. Towards the top-right of your display you’ll see the “Insert” and “Remove” options.
Use Conditional Formatting
By using conditional formatting you can highlight or change the color of cells depending on their value. To give it a try, choose the column that you’re going to format and click the “Conditional Formatting” option. Choose “Highlight Cell Rules” from the drop-down menu and choose “Duplicate Values.”
Create a Diagonal Like to Any Cell
You may need to create a diagonal line, and the good news is that it’s easy to create. Click on “Home -> Font -> More Borders.” You’ll see various options, but the one that will give you the diagonal line is the one located at the bottom-left corner. Click on it to save your options. You should have your diagonal line after that.
Conceal Your Formulas
If you click the top of the preview area beside the Function button, you can see the formula. It’s a handy feature but a messy one if you’re dealing with a complicated formula. To clean things up a bit you can hide your formula by clicking on the cell that has the formula.
Right-click and choose “Format.” Go to “Protection” and click on the “Hidden box” option. Click OK to save your choice. Keep in mind that this isn’t enough to protect your document from others.
To add a password to your Excel document, go to the Review tab and click “Protect Sheet.” Create your password and watch how your formula disappears.
Convert Your Rows into Columns and Vice Versa
This is a handy Excel tip if your rows are too long, and you want your document to look more organized. Select and copy the cells that you want to organize. Click on the cell where you want to place the data and right-click to select “Paste Special.”
When the new window appears, select the “Transpose” option and click OK.
Save Charts as Templates
If you’re proud of the chart you’ve created, save it! You can do that by right-clicking on the chart, and you should see the “Save as Template” option. This option will save you some valuable time on your next document.
Excel Keyboard Shortcuts
- Ctrl + – – Makes delete options appear
- Ctrl + A – Selects all your data
- Shift + Space bar – Selects the cells you’re currently using
- Ctrl + V– Pastes what you’ve copied
- Ctrl + Space bar – Selects the column of the cell you’re using
- Ctrl + End – Goes to the last cell with data
- Ctrl + Down Arrow – Goes to the last cell of the column you’re using
- Ctrl + Home – Selects the first cell with your data
- Ctrl + Up arrow – Goes to the first cell of the column you’re currently using
Quickly Copy a Formula
To copy a formula quickly, place the cursor on the bottom-right corner that has the cell you want to copy. The cursor will turn into a plus sign; when it does, simply double-click to copy.
Eliminate Extra Space from Any Cell
To get rid of that extra space, select the cell where your formula will appear. Type
=trim(name of the cell) and Press Enter. This command won’t remove the single space between any letters.
Text to Column Trick
This trick makes it easier for you to separate the data of a single cell into various cells. To use this trick go to the “Data” tab and choose the column that you want to separate. Click “Text to Columns” and then click Next. Choose the characters you want to split into columns by filling in the box next to Other.
Excel can seem like an intimidating software to some, but once you get the hang out of it, it’s not so tough. What Excel tips do you use to impress your boss? Leave a comment below and let us know.