12-25-2008, 02:04 PM
|
|
Registered User
|
|
Join Date: 19 Dec 2008
Location: Dhaka
Posts: 2
|
|
|
Selim's tips (1)
Please Register to Remove these Ads
1
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 on OK.
2
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
3Enter 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
4
Calculate running totals
Enter the numbers to be added in column A, say A1 to A5, then enter
=SUM($A$1:A1) into column B. Highlight the cells beside the ones with
numbers in (in our example, B1 to B5) and go to Edit, Fill, Down. This places the running total of the figures in A1 to A5 in the adjacent column.
5
Remove hyperlinks from your work
If Excel has already converted your written URL into a hyperlink, you can
cancel it by right-clicking on the offending address and selecting Hyperlink, Remove Hyperlink from The menu that pops up.
6
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.
7
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
8
Use template worksheets
Templates can save you considerable time when you’re setting up a new
worksheet. Click on File, New…, select the Spreadsheet Solutions tab and
choose a template from the list.
11
Customise your AutoFills
If you use the same list over and over in different worksheets, you might want to add it to your AutoFill list – this will save you heaps of time in future. Highlight your list, click on Tools, Options… and select the Custom Lists tab. Click on Import, then OK.
12
Use the
Auto Calculator
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.
More tips can be found http://exceltip.com/
Last edited by Simon Lloyd; 12-26-2008 at 11:58 AM.
|
Linear Mode
