Hide or show Ribbon in Excel

The ribbon in Excel, which was introduced in Excel 2007, is a major improvement from the old menus. But it takes up a lot of space, so sometimes you want to hide it. There are several ways to do it, but all you have to learn is the shortcut:

Hide ribbon: Ctrl + F1

Show ribbon: Ctrl + F1

Easy-Excel_5_1

This also works in Word, Powerpoint and Outlook 2007 and later


Are you using a non-English version of Excel? Click here for translations of the 100 most common functions.

Did you enjoy this article? Get free email updates! Enter your email address here:

Delivered by FeedBurner

Convert text to numbers in Excel using formulas

Easy-Excel_4_1Have you ever imported data into Excel that won’t calculate? Look at this example where the earnings look like numbers to the human eye, but not to Excel. And when Excel is not able to identify any numbers, it can’t calculate any sums or averages either.

This happens all the time if you use data from other data sources: It could be a txt-file from a booking system, a copy-paste from a website or even a database export.

Enough about the problem. Let’s solve it, and let’s not spend more than 2 minutes doing it!

READ MORE

Custom number formatting in Excel is easy!

Easy-Excel_3_1Excel has a lot of built-in number formats such as $100.00 or ¥100,00. But what if you want something that is not in the standard menu, like 100 km/h or 14 stone?

If you type “14 stone” in the cell, Excel will interpret it as text, and you won’t be able to do any calculations. We need to find another way.

READ MORE