7 Top Microsoft Excel Tips and Tricks

The Microsoft Office bundle changed everyday office work right from its early days, in 1995. After more than 20 years on the market, the bundle is still a market leader and its numerous programs are extremely useful in our everyday office environment. Microsoft Excel has grown spectacularly from its earlier versions, and the 2010 version brought tons of new features. The latest upgrade called Office 2016, includes all the fabulous functions we already know about, but also a lot of new features and interesting settings.

Microsoft Excel is a great tool for office work and both beginners and advanced users will love to see these 7 top tips and tricks that will increase their productivity:

Microsoft Excel Tips and Tricks

  1. Select All with a single click

Cell selection used to be a hassle in early Excel versions, but the 2010 version made it easier than ever to select them. You can either use the Ctrl+A shortcut or the new triangle-shaped button located in the top-left corner of your spreadsheet. Just click this button once and all your data will be selected in seconds.

  1. Bulk open spreadsheet files

Gone are the days when you had to open each spreadsheet separately. The newer versions of Microsoft Excel allows you to open spreadsheets in bulk, with just one click. Simply select the files you want to open and press Enter on your keyboard. All your files will open up simultaneously and you’ll be able to edit them in real time.

  1. Diagonal lines for cells

Everyone knows that Excel can split cells horizontally and vertically, but some spreadsheets or lists will require a diagonal line across a cell. Luckily, now there’s a trick for this. Simply go to Home>Font>Borders and click on More Borders to find the diagonal line option. Click it, save it and you are good to go.

  1. Quick move and copy data in multiple cells

Moving one column in a spreadsheet is quite simple and straightforward. Just select it, move the pointer to the border and drag the column freely, placing it wherever you want it. Copying the data inside the column is also simple: press the Ctrl button before dragging it, move the column and place it. You’ll have a new copy of the column exactly where you want it.

  1. Quick delete function to delete empty cells

Empty cells are a pain and can make your spreadsheet difficult to read. To delete them, you’ll have to select them one by one, a tedious process which everyone hates. A new function, however, will help you delete them with just a few clicks. Choose the column you want to be filtered, pick Data>Filter and check the Select All option. Pick the last button, called Blanks, and all your blank cells will be highlighted. Simply hit the Delete button and every blank cell will disappear instantly.

  1. Transfer data from rows to columns

This new function will help you immensely when you want to visualize data better. In previous Excel versions, you had to painstakingly retype all the data all over again, but the new version has the Transpose function in the Paste menu. Here’s how you use it: copy the area you want to transfer, move the pointer to the new blank location, go to Home>Paste>Transpose and click on the button. In mere seconds, your rows will be neatly displayed in columns.

  1. Hide data

Every user already knows about the Hide function in Excel, but if you want to hide multiple areas you should choose the Format Cells function. Go to Home>Font>Open Format Cells>Number Tab>Custom>Type ;;; and click OK. Now, all the values in the area will be invisible and can only be viewed in the preview area.

If you’re working on an excel document for your office business meeting, by adding it to an online sharing document software, like Lucion’s FileCenter, each attendee can have it beforehand, and you ensure that if your computer crashes, you have it in a secure online document storage.

About the author

Raymond L. Torbert

Add Comment

Click here to post a comment