Save Time in Excel: Keys Shortcuts to Speed Up Your Workflow

March 22, 2013 Excel  No comments

 

Who would not want to save time in Excel?

Here at Desktop Training Academy we are committed to help you using Excel in a professional setting, saving time, getting more effective and reducing the frustration that comes with it.

We talk and work with MS Certified Professionals on a daily basis, and we were able to come up with some key tips, tricks and shortcuts that will make your life in Excel much easier!

Save Time in Excel – 5 Easy Tips

 

1) Writing Multiple Lines in the Same Cell

The default Excel setting is one line per cell. There might be times when you need to have multiple lines in the same cell, so how do you do that and save time?

While you are typing in the cell and you are ready to move to the second line (in the same cell) just press:

ALT+ENTER

And you’ll start a new line.

There is also a button in the ribbon that allows you to select a cell or multiple cells and split the text into multiple lines: the button is call Wrap Text.

Wrap Text Excel Function photo

 

2) Quickly Move Through Your Worksheets

How annoying is to use the mouse to move between Excel spreadsheets or worksheets?

Here are a few shortcuts that will speed up the process!!

To move one worksheet to the right press
CTRL+PAGE DOWN

To move one worksheet to the left press
CTRL+PAGE UP

If you have multiple excel files open you can press
Alt+Tab to move between them

 

3) Group/Ungroup Data and Freeze Panes

Often we are stuck working with huge charts or the chart we are using contains old data that is not relevant anymore but that cannot be deleted or we need to show different lines depending on who we present the data to.There are 2 functions in Excel that will help you group and ungroup data so that you can hide it or show it as you please.

How do we group and ungroup data fast?

There are 2 buttons in the data tab in your ribbon, that are placed at the right end.

Group and ungrouping cell in excel photo

Now all you need to do is select the rows you want to hide/show and click “group” or “ungroup”. This is the end result

grouping data in excel photo

Other times you may have a chart with so many rows that while you scroll down you loose the first line with the column names. A quick fix will allow you to save time e work faster while analyzing data.

In your ribbon, in the “view” tab, there is the “Freeze Panes” button. At this point you want to select the raw that is underneath the one you want to actually freeze and click “Freeze Panes”. There are also other 2 options with different functions.

Freeze first line in excel photo

 

4)Print a Specific Area

Too often we are stuck working with gigantic Excel spreadsheets, and printing a specific area is not always possible without some cut and paste and extra work.

For this reason Excel, to save you time and headaches, has a specific button that let you choose the area you need to print.

This button is located in your ribbon, in the page layout tab, and it’s called “Print Area”:

Excel Print Area button photo

Before you click on the button, select with the mouse the cells you need to print and then click “Print Area”->”Select Print Area” and you will be able to print only one chart, maybe only a few columns and so on.

 

5) Display All the Formulas in the Spreadsheet

A single shortcuts lets you switch between Excel‘s normal display, which shows the results of the formulas in the spreadsheet, and a display mode that shows all the actual formulas in your spreadsheet.

The keystroke is

Ctrl + `

(The grave accent key is located on the top left of the keyboard next to the 1 key, in the US it’s the Tilde key); press it once, and Excel displays formulas instead of results. Press it again, and the results appear again.

Excel show all the formulas in one spreadsheet photo

 

Here are 5 useful shortcuts that will save you time in Excel and make your workflow more effective!

If you want to learn more power Excel shortcuts check out our Excel tips/Tricks online training!

 

Vince – Desktop Training Academy

email

Leave a reply

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>