Excel Tips and tricks

Convert rows to columns
You can convert rows to columns (and columns to rows) by highlighting the cells you want to switch around, clicking on Edit, Copy, selecting a new cell and then going to Edit, Paste Special… Finally, place a tick in the Transpose box on the dialog box and click OK. Below an image for your reference:

convert-rows-to-columns

Use the AutoCalculator
If you need to calculate a sum based on a row or a column of figures and
you can’t be bothered typing in a function, just select your figures and glance down at the status bar – you’ll find the sum of the selected cells there.Below an image for your reference:

Calculate time between dates
Enter in a cell the formula =A2-A1, where A1 is the earlier date, and A2 the later one. Don’t forget to convert the target cell to number format – do this by highlighting the cell, clicking on Format, Cells…, picking on the Number tab and selecting Number from the Category: list. Below an image for your reference:

calculate-time-between-dates-in-excel

Enter URLs as text, not hyperlinks
To prevent Excel from converting written Internet addresses into hyperlinks, add an apostrophe to the beginning of the address, for example ‘www.futurenet.com.

Fit wide tables to the page width
To make your tables fit neatly on the page, click on File, Page Setup…, select the Page tab, click on the Fit to: radio button and pick 1 page wide. Click on the tall box and press [Delete], leaving the box empty.

Hide your data from prying eyes
If you want to hide from view any sensitive data, highlight the relevant cell and click on Format, Cells… Click on the Numbers tab, select Custom from the Category: list, double-click on the Type: input box and enter.Undo the operation to make your data visible again.Undo this operation to make your data visible again.Below is an image for your reference:

hide-data-in-excel
hide-data-in-excel

A quick way to enter the time
To enter the current date or time click on a cell and type =today() or =now(). Excel updates the result every time you
open the sheet, so it’s always current.Below is an image for your reference:

add-time-in-excel
add-time-in-excel

Shortcut way to enter current time and date in excel
If you want Excel to enter the current date or time and fix it at that point – for example, to show the last date the sheet was modified – click on a cell and press [Ctrl] + [;] for the date and [Ctrl] + [:] for the time.

excel-tips-tricks
excel-tips-tricks

Why #NAME! and #NUM! errors occur?
Excel returns a #NAME! or #NUM! error whenever a formula refers to nonexistent names or numbers. To solve this
error, re-enter the formula correctly.
How to Merge cell contents?
To merge the contents of cells A1 and B1, click on cell C1 and enter =A1&B1.
The result is not a sum but a text string, so merging 10 and 7 will return 107, rather than 17.

excel-tips-tricks
excel-tips-tricks

How to create hyperlinks to support files?
To place links in cells that enable you to load other documents with one click, enter a name for the link in a cell and press [Ctrl] + [K]. Click on the File… button. Navigate to the file you wish to link to. Double-click on it and click
OK. From now on, whenever you click in that cell, Excel will jump to the file.

excel-tips-tricks
excel-tips-tricks