Useful Excel Tricks that Will Impress Your Boss

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.

excel-special

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.

excel-change-size

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.

excel-delete

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

excel-conditional

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.

excel-diagonal-lines

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.

excel-hidden

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

excel-paste-special

When the new window appears, select the “Transpose” option and click OK.

excel-transpose

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-templates

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-text

Conclusion

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.

2 comments

  1. Many of the comments within my Excel spreadsheet are very lengthy. So I would like to know if there is someway (perhaps a VBA macro) that can be used to not only find a given string within the comments of all cells within a spreadsheet (which is done by Excel itself), but moreover, point to the line within the comment where the string is found.

  2. Many of these ways of doing things have even shoter/better ways of doing them..

Comments are closed.

Sponsored Stories