Useful Excel Tricks

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.

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.

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.

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.”

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.

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.

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.

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.

  • 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

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.

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.

Author

Oge