MENU

Microsoft Excel: Tips and Tricks

06.17.2014

Below I have complied a list of Excel tips and tricks that will help you get things done faster and more efficiently . This is a series that will cover tips and tricks for all Microsoft Office products.

 

OneClick

Click the corner button, as shown below, to select all cells in an excel file. With this one click all cells will be selected in seconds.

Screen Shot 2014-06-17 at 10.19.37 AM

Also, if all cells are selected you can adjust the column width and row height to match for all cells. Simply select all cells and move the column and row cursor to the preferred width and height.

2014-06-17_10-26-31

 

 

Shift

By using the Ctrl + Tab keyboard shortcut, you can shift between different files freely. It can become irritating shifting between different files.

1-3

Also if you have two excel documents open at the same time, excel will only let you view one document at a time. To avoid this, open up the documents separately where they are saved locally. Do not open up the second document through excel.

 

 

Delete

If you want all blank cells in your excel file to be deleted, the fastest way is to filter out all blank cells and delete them with one click.  Follow the steps below to delete blank cells.

Excel: Deleting Blank Cells from Kaitlyn Reish

 

 

Transpose

You can use the transpose feature to get a better display of your data, however, it would be a waste of time to retype all the data. Use the transpose feature in Paste drop-down to save time. All you need to do it copy the data area and navigate a free area on your spreadsheet. Navigate to the Home tab and use the transpose feature under the Paste drop-down, that you can see in the screenshot below.

Flow

Input

When a value that starts with a zero, Excel will delete the zero by default. Rather than formatting the cells, this issue can be easily solved by adding a single quote mark ahead of the first zero, as seen below.

Screen Shot 2014-06-17 at 4.20.58 PM

Post by Kaitlyn Reish, Training Specialist at HPU.

  • Click HERE to return to the Techblog

Helpful Links

Categories

Recent Posts


HPU SOCIAL
Connect with us
On the Social page, you can view all of High Point University’s social media feeds, connect to specific majors and schools on Facebook, and get the latest updates about what’s happening on campus.